![DB2 Tutorial](/db2/images/db2-mini-logo.jpg)
- 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.
![Questions and Answers](/images/questions_and_answers.png)
Q 1 - Which of the following are physical objects?
Answer : D
Explanation
Database and Table space are physical objects.
Q 2 - Which of the following can refer to both local as well as remote tables?
Answer : B
Explanation
Alias can refer to both local as well as remote tables whereas synonyms refers only to local 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 - 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.
Answer : C
Explanation
If a user is not authorized to access DB2 objects, he will face SQLCODE -922.
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 - What action DB2 takes when a program abends?
Answer : A
Explanation
When a program abends in middle of some transaction then DB2 performs a auto rollback.
Q 8 - Deadlock resolution is done by rolling back one of the transactions which has the least log entries. State whether true or false?
Answer : B
Explanation
This statement is correct.
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 - Which utility is used to execute a COBOL-DB2 program?
Answer : B
Explanation
IKJEFT is used to execute a COBOL-DB2 program. Program name is mentioned with PLAN name & Library where program resides.