- 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 DB2 component is used for remote database server connection?
A - Locking Services Component
Answer : D
Explanation
Distributed Data Facility Component is responsible for handling remote database server connections.
Q 2 - Which columns are good for indexing?
Answer : D
Explanation
The purpose of index is to retrieve the data faster. So we choose those columns which are unique.
Q 3 - Which index must be present for partitioned table space?
Answer : B
Explanation
A partitioned table space must have a clustered index.
Q 4 - What does a negative SQL code indicates?
Answer : B
Explanation
A negative SQL code indicates a failure while a positive one indicates an exception.
Q 5 - When you will face SQLCODE -811?
Answer : A
Explanation
You will face -811 SQLCODE when the SELECT query returns more than one number of rows.
Q 6 - How you will count the number of rows from a table TAB?
Answer : C
Explanation
This is self explanatory.
Q 7 - Which utility is take the backup of table spaces and index spaces?
Answer : D
Explanation
Copy utility is used to take the back up of table spaces and index spaces.
Answer : B
Explanation
Yes we can add columns after table declaration by using ALTER statement.
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.
Q 10 - What is the physical storage length of TIMESTAMP data type?
Answer : C
Explanation
TIMESTAMP data type takes 10 bytes and default is YYYY-MM-DD:HH:MM:SS-NNNNNN