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
0
1 (A)
5 (A,B,C,D,E)
2 (A,E)
Which IBM tool can you use to debug stored procedure?
Control centre
IBM Data studio
Visual Explain
Command editor
What is the Output ?
Returns current date
Generate the access plan
Suggests performance hints that can be implemented
Drop and create the stored procedure
The table rows and column are also known as?
Attributes and Fields
Fields and Records
Records and Fields
Fields and Attributes
Which of the following SQL functions can operate on any datatype?
TO_CHAR
TO_DATE
MAX
LPAD
Normalization is…?
A special way of selecting data
The process of adding primary key to a table
The process of arranging information stored in a database in a way, which removes redundancy and ambiguity.
A special way of retrieving data
which is also known as n-dimensional cross-tabulation ?
Rollback
Rollup
CUBE
Commit
Retrieving data end with "abc" which wildcard use with like keyword?
abc%
%abc_
%abc
%abc%
which is also known as "n dimensional cross tabulation"?
which commands is combination of unions ?
I and III both