DB2 Interview Questions and Answers For Graduates Part-3
21.What are some of the main fields in SQLCA? Major Fields in SQLCA is SQL CODE, SQLERRM, and SQLERRD.
Read MoreDB2 Interview Questions and Answers For Graduates Part-2
11.When the LIKE statement is used? LIKE statement is used to conduct partial searches like the search of employees by name. It is not necessary to indicate the complete name, the partial string matches would do.
Read MoreDB2 Interview Questions and Answers For Graduates Part-1
1.How to find number of rows in DB2 tables? User has to use SELECT COUNT (*) on DB2 query.
Read MoreDB2 Interview Questions and Answers For Freshers Part-5
41.Write a query to delete a table from database.? DROP TABLE table-name is the syntax to delete a table from database.
Read MoreDB2 Interview Questions and Answers For Freshers Part-4
31.When you will face SQLCODE -911? At the time of deadlock or timeout you will face SQLCODE -911.
Read MoreDB2 Interview Questions and Answers For Freshers Part-3
21.When you will face SQLCODE -922? If a user is not authorized to access DB2 objects, he will face SQLCODE -922.
Read MoreDB2 Interview Questions and Answers For Freshers Part-2
11.In a COBOL-DB2 program all SQL statements must be coded in Area A. State whether true or false? This statement is incorrect as SQL statements must be coded in Area B.
Read MoreDB2 Interview Questions and Answers For Freshers Part-1
1.What is the picture clause of Null Indicator variable? S9(4) COMP is the picture clause of a null indicator.
Read More