- 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 - How many databases can a DB2 system manage?
Answer : B
Explanation
This is self explanatory.
Q 2 - Suppose a table A has an Alias named AL1. Which of the query is correct to drop the AL1 alias?
Answer : B
Explanation
DROP ALIAS alias-name is the correct syntax.
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 authorize access on database tables?
Answer : D
Explanation
GRANT keyword is used to grant privileges on DB2 tables.
Q 5 - When you will face SQLCODE -818?
Answer : D
Explanation
SQLCODE -818 is a timestamp mismatch of load module and bind timestamp built from DBRM.
Q 6 - Suppose we added a new column by using ALTER statement, where the column will be added?
Answer : B
Explanation
When we use ALTER statement for adding a new column then it will be added at the end of the table.
Q 7 - If a transaction takes a Update lock on some data, then other transactions can get what type of lock?
Answer : A
Explanation
If a transaction takes an Update lock on some data, then other transactions can only get only Shared lock on it.
Q 8 - Locking is a process that is used to ensure data integrity and prevents concurrent users from accessing inconsistent data. State whether true or false?
Answer : B
Explanation
This is self explanatory.
Q 9 - Cursors are used to handle single row selections at a time. They are data structure which hold all the results of a query. State whether true or false?
Answer : A
Explanation
This statement is incorrect as cursors are used to handle multiple row selections at a time.
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.