How do you insert a record with a nullable column?

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: a nonmatching index scan if ACCESSTYPE = 1

Correct Answer: DeCLarations GENerator : used to create the host language copy books for the table definitions Also creates the DECLARE table

Correct Answer: Cursor is a programming device that allows the SELECT to find a set of rows but return them one at a time Cursor should be used because the host language can deal with only one row at a time

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: SELECT statement has resulted in retrieval of more than one row

Correct Answer: There are three types of lock, namely: Shared ? This type of lock permits two or more programs to read from the locked space but does not allow them to change it Update ? This lock is more lenient It permits the program to read and change the locked space Exclusive ? This lock restricts all users from accessing the locked space

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;