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?
This is self explanatory.
Q 2 - Which of the following can refer to both local as well as remote tables?
Alias can refer to both local as well as remote tables whereas synonyms refers only to local tables.
Q 3 - Write a query to delete a table TAB from database.
DROP TABLE table-name is the syntax to delete a table from database.
Q 4 - Which statement is used to revoke the access from a database?
REVOKE statement is used to take away the permissions from a Database.
Q 5 - When you will face SQLCODE -911?
At the time of deadlock or timeout you will face SQLCODE -911.
Q 6 - Which utility provides statistical information such as the number of pages and rows and stores them in Catalog tables?
Runstats utility updated the catalog tables with the statistical information.
Q 7 - What action DB2 takes when a program abends?
When a program abends in middle of some transaction then DB2 performs a auto rollback.
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?
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?
This statement is correct.
Q 10 - What is the picture clause of Null Indicator variable?
S9(4) COMP is the picture clause of a null indicator.