Olete.in – MCQs, Mock Tests & Government Job Prep

Which of the following is valid in the case of Query?

1. PRICE NOT > 500.00
2. PRICE = > 500.00
3. NOT PRICE > 500.00
4. None of the above

✅ Correct Answer: 3

After successful precompilation

1. DBRM and Modified source code files are created
2. DBRM and PLAN are created
3. DBRM and Load module are created
4. PLAN and Load module created

✅ Correct Answer: 3

How would you find out the total number of rows in a table?

1. Use SELECT SUM(*) �
2. Use SELECT COUNT(*) �
3. Use SELECT TOTAL(*) �
4. Use SELECT COUNT(TOTAL

✅ Correct Answer: 2

A set of volumes which hold the databases in which tables are stored is called______ .

1. Database
2. Tablespace
3. Storage group
4. Tables

✅ Correct Answer: 3

Bind component Produces:

1. Only Package
2. Only Application Plan
3. All of above
4. None of above

✅ Correct Answer: 2

How do you eliminate duplicate values in SELECT?

1. Use SELECT DISTINCT �
2. Use SELECT UNIQUE ...
3. Use SELECT ALL UNIQUE �
4. None of above

✅ Correct Answer: 1

If there is no authority to execute the PLAN the error is at

1. Bind time
2. Recompile time
3. Runtime
4. Spufi

✅ Correct Answer: 1

What does SQLCA stands for?

1. SQL Communications Area
2. SQL Control Area
3. SQL Connection Area
4. SQL Control Access

✅ Correct Answer: 1

A Plan is

1. Is an executable module containing access path logic provided by the DB2 optimizer
2. In an non executable module containing access path logic provide by the DB2 optimizer
3. Is just a module containing DBRM
4. Is a module containing DCLGEN

✅ Correct Answer: 1

Which of the following are valid fields from SQLCA

1. SQLCODE
2. SQLERRM
3. SQLERRD
4. All of above

✅ Correct Answer: 4

How do you find the maximum value in a column?

1. Use SELECT BIG(�
2. Use SELECT HIGHEST(�
3. Use SELECT MAX(�
4. None of above

✅ Correct Answer: 3

🧪 DB2 MCQ Quiz Hub

DB2 MCQS