Tag: databases

Questions Related to databases

CREATE PROCEDURE p1() BEGIN CREATE TABLE T1 (C1 CHAR); INSERT INTO T1 VALUES ('A'); SAVEPOINT SAVEPOINT1 ON ROLLBACK RETAIN CURSORS; INSERT INTO T1 VALUES ('B'); SAVEPOINT SAVEPOINT2 ON ROLLBACK RETAIN CURSORS; INSERT INTO T1 VALUES ('C'); SAVEPOINT SAVEPOINT3 ON ROLLBACK RETAIN CURSORS; INSERT INTO T1 VALUES ('D'); ROLLBACK TO SAVEPOINT SAVEPOINT3; ROLLBACK TO SAVEPOINT SAVEPOINT1; COMMIT WORK; INSERT INTO T1 VALUES ('E'); END@ Call p1() @ How many rows will be present in Table T1

technology databases

  1. 0

  2. 1 (A)

  3. 5 (A,B,C,D,E)

  4. 2 (A,E)

Show answer
Correct Option: D

Which IBM tool can you use to debug stored procedure?
technology databases

  1. Control centre

  2. IBM Data studio

  3. Visual Explain

  4. Command editor

Show answer
Correct Option: B

What is the Output ?
technology databases

  1. Returns current date

  2. Generate the access plan

  3. Suggests performance hints that can be implemented

  4. Drop and create the stored procedure

Show answer
Correct Option: D

The table rows and column are also known as?
technology databases

  1. Attributes and Fields

  2. Fields and Records

  3. Records and Fields

  4. Fields and Attributes

Show answer
Correct Option: C

Which of the following SQL functions can operate on any datatype?
technology databases

  1. TO_CHAR

  2. TO_DATE

  3. MAX

  4. LPAD

Show answer
Correct Option: C

Normalization is…?
technology databases

  1. A special way of selecting data

  2. The process of adding primary key to a table

  3. The process of arranging information stored in a database in a way, which removes redundancy and ambiguity.

  4. A special way of retrieving data

Show answer
Correct Option: C

which is also known as n-dimensional cross-tabulation ?
technology databases

  1. Rollback

  2. Rollup

  3. CUBE

  4. Commit

Show answer
Correct Option: C

Retrieving data end with "abc" which wildcard use with like keyword?
technology databases

  1. abc%

  2. %abc_

  3. %abc

  4. %abc%

Show answer
Correct Option: C

which is also known as "n dimensional cross tabulation"?
technology databases

  1. Rollup

  2. Rollback

  3. CUBE

  4. Commit

Show answer
Correct Option: C

which commands is combination of unions ?
technology databases

  1. Rollup

  2. Rollback

  3. CUBE

  4. I and III both

Show answer
Correct Option: D