- 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.
Answer : B
Explanation
Yes, a DB2 system can have more than one database.
Q 2 - How many numbers of tables can be created inside a table space?
Answer : C
Explanation
A table space can house any number of tables.
Q 3 - What does SPUFI stands for?
A - SQL Processor Using File Input
B - Sequential Processor Using File Input
Answer : A
Explanation
SPUFI stands for SQL Processor Using File Input.
Q 4 - Which statement is used to revoke the access from a database?
Answer : C
Explanation
REVOKE statement is used to take away the permissions from a Database.
Q 5 - When you will face SQLCODE -803?
A - No Rows found satisfying the SQL statement or End of Cursor
Answer : D
Explanation
When you will try to insert or update a record with duplicate key then you will face SQLCODE = -803
Q 6 - How you will count the number of rows from a table TAB?
Answer : C
Explanation
This is self explanatory.
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.
Q 8 - Exclusive locks are taken for INSERT, UPDATE and DELETE purposes. State whether true or false?
Answer : B
Explanation
This is self explanatory.
Q 9 - Embedded SQL statements are used in COBOL programs to perform standard SQL operations. Embedded SQL statements are preprocessed by SQL processor before application program is compiled. State whether true or false?
Answer : B
Explanation
This is self explanatory.
Answer : D
Explanation
Locking can be applied on either of these - Page, table and table space.