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 19:32:49
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 19:32:49
Which of the following are valid fields from SQLCA
1.SQLCODE
2.SQLERRM
3.SQLERRD
4.All of above
Posted Date:-2021-10-30 19:32:49
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 19:32:49
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 19:32:49
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 19:32:49
Bind component Produces:
1.Only Package
2.Only Application Plan
3.All of above
4.None of above
Posted Date:-2021-10-30 19:32:49
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 19:32:49
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 19:32:49
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 19:32:49
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 19:32:49