- DB2 Tutorial
- 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 Useful Resources
- DB2 - Questions and Answers
- DB2 - Quick Guide
- DB2 - Useful Resources
- DB2 - Discussion
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 component is responsible for execution of SQL statements?
A - Locking Services Component
Answer : C
Explanation
Database services component is responsible for execution of SQL statements and it manages buffer pool also.
Q 2 - Which table space houses only one table?
Answer : C
Explanation
A partitioned table space can house one table and allows a table to be divided by rows into partitions that the system can manage separately.
Q 3 - Write the query to delete all the rows from a table TAB.
Answer : B
Explanation
DELETE * FROM table-name is the syntax to delete all the rows from a table.
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.
Q 5 - When you will face SQLCODE -805?
A - No Rows found satisfying the SQL statement or End of Cursor
Answer : C
Explanation
You will face SQLCODE = -805 when program has not been binded to the plan.
Q 6 - Which isolation level provides maximum concurrency?
Answer : D
Explanation
Uncommitted read provides maximum concurrency.
Q 7 - When a table is dropped all the synonyms get dropped automatically. State whether true or false?
Answer : B
Explanation
Synonyms get dropped automatically when we drop the table but alias of the table remains there.
Answer : B
Explanation
Yes we can add columns after table declaration by using ALTER statement.
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 component is used to processes SQL statements and selects the access paths?
Answer : C
Explanation
DB2 optimizer is used to select the access paths & to process the SQL queries.
To Continue Learning Please Login
Login with Google