- 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 handles DB2 startup and shutdown?
A - Locking Services Component
Answer : B
Explanation
System services component handles DB2 startup and shutdown.
Q 2 - Which table space can have one or more tables and can have rows from multiple tables on a single page?
Answer : A
Explanation
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 - What is the maximum size of a VARCHAR data type in DB2?
Answer : C
Explanation
Varchar data type maximum size is of 4046 bytes.
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 -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 utility provides statistical information such as the number of pages and rows and stores them in Catalog tables?
Answer : A
Explanation
Runstats utility updated the catalog tables with the statistical information.
Answer : D
Explanation
Locks can be classified based on size, duration and mode.
Q 8 - Stored procedures require no message traffic over the network while they are running and they provide high performance. State whether true or false?
Answer : B
Explanation
Stored procedures are mainly useful in distributed environment and provide an easy way to call a remote program.
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?
Answer : B
Explanation
This statement is correct.
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
To Continue Learning Please Login
Login with Google