Following quiz provides Multiple Choice Questions (MCQs) related to DB2. You will have to read all the given answers and click over the correct answer. If you are not sure about the answer then you can check the answer using Show Answer button. You can use Next Quiz button to check new set of questions in the quiz.
Q 1 - Which component is responsible for execution of SQL statements?
Database services component is responsible for execution of SQL statements and it manages buffer pool also.
Q 2 - Which table space can have one or more tables and can have rows from multiple tables on a single page?
A simple table space can contain one or more tables and there is no limit on the number of tables. Rows from multiple tables can be on a single page.
Q 3 - In which format index in stored?
An indexed is stored in B-tree format.
Q 4 - What does a positive SQL code indicates?
A negative SQL code indicates a failure while a positive one indicates an exception.
Q 5 -
Q 5 - When you will face SQLCODE -922?
If a user is not authorized to access DB2 objects, he will face SQLCODE -922.
Q 6 - Which isolation level ensures highest data integrity?
Repeatable Read ensures highest data integrity as it holds page and lock the rows until a COMMIT point.
Q 7 - If a transaction takes a Update lock on some data, then other transactions can get what type of lock?
If a transaction takes an Update lock on some data, then other transactions can only get only Shared lock on it.
Q 8 - Locking is a process that is used to ensure data integrity and prevents concurrent users from accessing inconsistent data. State whether true or false?
This is self explanatory.
Q 9 - SQLCA is a SQL communication area through which DB2 passes feedback of SQL execution to the program. It tells the program whether execution was successful or not. State whether true or false?
This statement is correct.
Locking can be applied on either of these - Page, table and table space.