- Home
- DB2 - Introduction
- DB2 - Server Installation
- DB2 - Instance
- DB2 - Databases
- DB2 - Bufferpools
- DB2 - Tablespaces
- DB2 - Storagegroups
- DB2 - Schemas
- DB2 - Data Types
- DB2 - Tables
- DB2 - Alias
- DB2 - Constraints
- DB2 - Indexes
- DB2 - Triggers
- DB2 - Sequences
- DB2 - Views
- DB2 with XML
- DB2 - Backup and Recovery
- DB2 - Database Security
- DB2 - Roles
- DB2 - LDAP
DB2 Online Quiz
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 of the following are physical objects?
Answer : D
Explanation
Database and Table space are physical objects.
Answer : C
Explanation
We can have only one clustering index for a table.
Q 3 - Write a query to delete a table TAB from database.
Answer : D
Explanation
DROP TABLE table-name is the syntax to delete a table from database.
Q 4 - What happens in BIND step in a DB2 program?
A - Bind step checks for data type matches
B - Bind contains SQL statements
Answer : C
Explanation
Bind step converts all the SQL statements into executable form in COBOL-DB2 program.
Answer : C
Explanation
If a user is not authorized to access DB2 objects, he will face SQLCODE -922.
Q 6 - Which isolation level provides maximum concurrency?
Answer : D
Explanation
Uncommitted read provides maximum concurrency.
Q 7 - What action DB2 takes when a program executes successfully?
Answer : B
Explanation
When a program executes successfully it does an auto commit.
Q 8 - Static SQL is compiled and optimized prior to its execution where as dynamic SQL is compiled and optimized during execution. State whether true or false?
Answer : B
Explanation
This is self explanatory.
Q 9 - Embedded SQL statements works like normal SQL statements with some minor changes like output of query is directed to pre-defined set of variables which are referred as Host Variables. State whether true or false?
Answer : B
Explanation
This statement is correct.
Q 10 - Which field in SQLCA shows the number of updated rows after update statement?
Answer : C
Explanation
Check the value of SQLERRD to know how many rows got updated after an update statement.