DB2/DB2 MCQS Sample Test,Sample questions

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



1.Bind time

2.Recompile time

3.Runtime

4.Spufi

Posted Date:-2021-10-30 12:32:49


Question:
 What does SQLCA stands for?



1.SQL Communications Area

2.SQL Control Area

3.SQL Connection Area

4.SQL Control Access

Posted Date:-2021-10-30 12:32:49


Question:
 Which of the following are valid fields from SQLCA



1.SQLCODE

2.SQLERRM

3.SQLERRD

4.All of above

Posted Date:-2021-10-30 12:32:49


Question:
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

Posted Date:-2021-10-30 12:32:49


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



1.Database

2.Tablespace

3.Storage group

4.Tables

Posted Date:-2021-10-30 12:32:49


Question:
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

Posted Date:-2021-10-30 12:32:49


Question:
Bind component Produces:



1.Only Package

2.Only Application Plan

3.All of above

4.None of above

Posted Date:-2021-10-30 12:32:49


Question:
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

Posted Date:-2021-10-30 12:32:49


Question:
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

Posted Date:-2021-10-30 12:32:49


Question:
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

Posted Date:-2021-10-30 12:32:49


Question:
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

Posted Date:-2021-10-30 12:32:49


More MCQS

  1. DB2 MCQS
Search
R4R Team
R4Rin Top Tutorials are Core Java,Hibernate ,Spring,Sturts.The content on R4R.in website is done by expert team not only with the help of books but along with the strong professional knowledge in all context like coding,designing, marketing,etc!