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.
Yes, a DB2 system can have more than one database.
Q 2 - How many numbers of tables can be created inside a table space?
A table space can house any number of tables.
A table can have only one primary key.
Q 4 - What does DCLGEN stands for?
DCLGEN stands for Declaration Generator.
Q 5 - In a COBOL-DB2 program where can we declare a cursor?
We can declare a cursor either i Working Storage Section or in Procedure Division also.
Q 6 - Which isolation level provides maximum concurrency?
Uncommitted read provides maximum concurrency.
Q 7 - When a table is dropped all the synonyms get dropped automatically. State whether true or false?
Synonyms get dropped automatically when we drop the table but alias of the table remains there.
Q 8 - Deadlock resolution is done by rolling back one of the transactions which has the least log entries. State whether true or false?
This statement is correct.
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?
This is self explanatory.
Q 10 - What SQLCODE you will get for a successful execution of query?
You will get SQLCODE = 0 if the execution is successful.