🧪 DB2 MCQ Quiz Hub

1. Which of the following is valid in the case of Query?
PRICE NOT > 500.00
PRICE = > 500.00
NOT PRICE > 500.00
None of the above

2. After successful precompilation
DBRM and Modified source code files are created
DBRM and PLAN are created
DBRM and Load module are created
PLAN and Load module created

3. How would you find out the total number of rows in a table?
Use SELECT SUM(*) �
Use SELECT COUNT(*) �
Use SELECT TOTAL(*) �
Use SELECT COUNT(TOTAL

4. A set of volumes which hold the databases in which tables are stored is called______ .
Database
Tablespace
Storage group
Tables

5. Bind component Produces:
Only Package
Only Application Plan
All of above
None of above

6. How do you eliminate duplicate values in SELECT?
Use SELECT DISTINCT �
Use SELECT UNIQUE ...
Use SELECT ALL UNIQUE �
None of above

7. If there is no authority to execute the PLAN the error is at
Bind time
Recompile time
Runtime
Spufi

8. What does SQLCA stands for?
SQL Communications Area
SQL Control Area
SQL Connection Area
SQL Control Access

9. A Plan is
Is an executable module containing access path logic provided by the DB2 optimizer
In an non executable module containing access path logic provide by the DB2 optimizer
Is just a module containing DBRM
Is a module containing DCLGEN

10. Which of the following are valid fields from SQLCA
SQLCODE
SQLERRM
SQLERRD
All of above

11. How do you find the maximum value in a column?
Use SELECT BIG(�
Use SELECT HIGHEST(�
Use SELECT MAX(�
None of above