6.
What is QUIESCE?
A QUIESCE flushes all DB2 buffers on to the disk This gives a correct snapshot of the database and should be used before and after any IMAGECOPY to maintain consistency.
7.
What is a Cluster Index ?
Causes the data rows to be stored in the order specified in the index A mandatory index defined on a partitioned table space.
8.
What is the difference between Primary Key & Unique index ?
Primary : a relational database constraint Primary key consists of one or more columns that uniquely identify a row in the table For a normalized relation, there is one designated primary key Unique index: a physical object that stores only unique values There can be one or more unique indexes on a table.
9.
What is SQLCODE -922 ?
Authorization failure
10.
What is SQL-811?
SELECT statement has resulted in retrieval of more than one row.
|
|
||||||||||||||||||||||||||||
