Db2_quiz_for_cbe13mj6_batch

Submit

3. Which command is used to give access permission to the table?

Grant

Select

Revoke

Commit

Permit

4. NULL indicator variable pic clause?

Pic s9(4) comp-3

Pic s9(4) comp.

Pic 9(04).

S9(8) comp.

5. If any records deleted in parent table the corresponding records should get deleted?

On delete cascade

On delete restrict

On delete set to null

None

On delete update

6. Write a query to get the total sal for each project?

Select total(sal) from emp group by project_name

Select sum(sal) from emp

Select count(sal) from emp group by project_name

Select sum(sal) from emp group by project_name

Select sum(sal) from emp order by project_name

7. Declare cursor can be defined in procedure division?

True

False

8. UNION ALL eliminate the duplicate records in the result set?

True

False

9. Sqlcode =-811

Select query fetches more than one row

Trying to insert null value to the table

Timestamp mismatch error

Dbrm member not found

10. LIke statement can be used in numeric datatypes fields?

True

False

11. Which utility is used to execute db2 program?

Ikjeft01

Ikjeft02

Ikfet01

Iefbr14

Idcams

12. Package is executable ?

True

False

13. Trying to fetch the cursor wothout opening it?

-501

-503

-811

-503

14. Write a query to insert null value to the table? emp_id,emp_name,emp_sal

Insert into emp(emp_id,emp_name) values(100,'abc')

Insert into emp values(100,'abc')

Insert into emp(emp_id,emp_name,emp_sal) values(100,'abc',' ')

Insert into emp values(100,' ')

15. Sqlcode = +100

Query executed successfully

End of table or no record found

End of table reached

No record found in the table

16. Sqlcode = -180?

Date,time,timestamp are invalid

Date,time,timestamp are valid

Null value fetching

Timestamp mismatch error

Time,timestamp are invalid

17. Input to the bind ?

Sql statements

Cobol statements

Cobol &sql statements

None

18. What is the physical storage length of each of the following DB2 data types: TIMESTAMP

10

26

8

4

19. Max() function can be used in char data type?

True

False

20. What is the table name to list the structure of the db2 table?

Sysibm.systables

Sysibm.syscolumns

Sysibm.syskeys

Sysibm.syscols

21. Which of the following utility is used to take backup of the db2table?

Load

Unload

Reorg

Backup

22. What is the correct order steps in cursor?

Declare,open,close

Declare,open,close,fetch

Declare,open,fetch,close

Open,fetch,close

Declare,open,fetch

Submit

23. What is the cobol pic clause for db2 datatype decimal(9,2)?

Pic s9(9)v99 comp-3.

Pic s9(7)v9(2) comp-3

Pic s9(7).9(2) comp-3.

Pic s9(7)v9(2) comp.

Pic 9(7)v9(2) comp-3.

24. Emp_name varchar(25) cobol pic clause?

01 emp-name. 05 emp-name-len pic s9(4) comp.05 emp-name-text pic x(25).

01 emp-name. 05 emp-name-len pic s9(4) comp.05 emp-name-text pic 9(25).

01 emp-name. 49 emp-name-len pic s9(4) comp-3.49 emp-name-text pic x(25).

01 emp-name .49 emp-name-text pic x(25).49 emp-name-len pic s9(4) comp.

01 emp-name. 49 emp-name-len pic s9(4) comp.49 emp-name-text pic x(25).

Db2_quiz_for_cbe13mj6_batch

1. DBRM?

2.

What first name or nickname would you like us to use?

2. Write a query to get the 4th maximum salary employee details from table? table name :emp

3. Which command is used to give access permission to the table?

4. NULL indicator variable pic clause?

5. If any records deleted in parent table the corresponding records should get deleted?

6. Write a query to get the total sal for each project?

7. Declare cursor can be defined in procedure division?

8. UNION ALL eliminate the duplicate records in the result set?

9. Sqlcode =-811

10. LIke statement can be used in numeric datatypes fields?

11. Which utility is used to execute db2 program?

12. Package is executable ?

13. Trying to fetch the cursor wothout opening it?

14. Write a query to insert null value to the table? emp_id,emp_name,emp_sal

15. Sqlcode = +100

16. Sqlcode = -180?

17. Input to the bind ?

18. What is the physical storage length of each of the following DB2 data types: TIMESTAMP

19. Max() function can be used in char data type?

20. What is the table name to list the structure of the db2 table?

21. Which of the following utility is used to take backup of the db2table?

22. What is the correct order steps in cursor?

23. What is the cobol pic clause for db2 datatype decimal(9,2)?

24. Emp_name varchar(25) cobol pic clause?