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


Question:
 What does SQLCA stands for?



1.SQL Communications Area

2.SQL Control Area

3.SQL Connection Area

4.SQL Control Access


Question:
 Which of the following are valid fields from SQLCA



1.SQLCODE

2.SQLERRM

3.SQLERRD

4.All of above


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


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


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


Question:
Bind component Produces:



1.Only Package

2.Only Application Plan

3.All of above

4.None of above


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


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


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


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


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!