Q.2:Given the table definition:
CREATE TABLE student (name CHAR(30), age INTEGER)
To list the names of the 10 youngest students, which of the following index definition statements on the student table may improve the query performance?
CREATE INDEX youngest ON student (age, name)
CREATE INDEX youngest ON student (name, age)
CREATE INDEX youngest ON student (name, age DESC)
CREATE INDEX youngest ON student (name DESC) INCLUDE (age)
Q.3:Dynamic SQL when compared to Statc SQL.
a. Needs more System Resources
b. Needs more time for execution
c. Needs more time to bind
Q.4:Which is used to return an error or warning condition with no SQLSTATE operand to the calling program?
Q.5:In case of read only cursor with RR isolation level whcih statement is correct?
a. Program will lock the record till the rollback issue/ or end of program b. RR isolation will be ignored
Q.6:Point out types of join?
Outer joins, Inner joins
None of the options
All of the options
Q.7:which isolation levels holds the transaction till commit?
Q.8:which isolation levels holds the transaction till UOW?
Q.9:which isolation level gives access to other users to update rows in table?
Q.10:When the RLF cancels a dynamic SQL statement, DB2 returns an SQLCODE __________
Q.11:What compound index?(Is it Composite Index? As I know what is composite index)