Name and explain the type of locks?

Correct Answer: SELECT statement has resulted in retrieval of more than one row

Correct Answer: REORG reorganizes data on physical storage to reclutser rows, positioning overflowed rows in their proper sequence, to reclaim space, to restore free space It is used after heavy updates, inserts and delete activity and after segments of a segmented tablespace have become fragmented

Correct Answer: To insert a NULL, move -1 to the null indicator To insert a valid value, move 0 to the null indicator

Correct Answer: A DB2 utility used to collect statistics about the data values in tables which can be used by the optimizer to decide the access path It also collects statistics used for space management These statistics are stored in DB2 catalog tables

Correct Answer: 1 Based on the lock-size given while creating the table space 2 Programer can direct the DB2 what lock-size to use 3 If lock - size ANY is specified, DB2 usually chooses a lock-size of PAGE

Correct Answer: It is an MVS message that indicates the presence of a duplicate catalogue in the database This problem can be fixed by removing one of the entries and then adding a new one

Correct Answer: SELECT * FROM table_name ORDER BY column_name desc Fetch first 5 rows only;

Correct Answer: Static (embedded) SQL: 1In static SQL how database will be accessed is predetermined in the embedded SQL statement 2It is more swift and efficient 3SQL statements are compiled at compile time 4Parsing, validation, optimization, and generation of application plan are done at compile time 5It is generally used for situations where data is distributed uniformly 6EXECUTE IMMEDIATE, EXECUTE and PREPARE statements are not used 7 It is less flexible Dynamic (interactive) SQL: 1In dynamic SQL, how database will be accessed is determined at run time 2It is less swift and efficient 3SQL statements are compiled at run time 4Parsing, validation, optimization, and generation of application plan are done at run time 5It is generally used for situations where data is distributed non-uniformly 6EXECUTE IMMEDIATE, EXECUTE and PREPARE statements are used 7It is more flexible

Correct Answer: - DBRM stands for Database Request Module - The output of pre-compile process is represented as DBRM - The SQL statements are extracted from the host language by the pre-compiler

Correct Answer: DB2 use the multiple indexes to satisfy multiple predicates in a SELECT statement that are joined by an AND or OR