DB2 Interview Questions and Answers For Freshers Part-4
32.When you will face SQLCODE -803?
When you will try to insert or update a record with duplicate key then you will face SQLCODE = -803.
33.What does application plan contains?
Application plan consists of one or more DBRM & application package which is kept in buffer pool during program execution.
34.Suppose a Plan contains 4 Packages & we modified one of the DBRM which is present in one of the Package. Then for normal functionality of application what should we do?
We will bind only that package which contains the modified DBRM. No need to bind all the packages.
35.What happens in BIND step in a DB2 program?
Bind step converts all the SQL statements into executable form in COBOL-DB2 program.
36.What does a positive SQL code indicates?
A negative SQL code indicates a failure while a positive one indicates an exception.
37.Which statement is used to revoke the access from a database?
REVOKE statement is used to take away the permissions from a Database.
38.Which statement is used to authorize access on database tables?
GRANT keyword is used to grant privileges on DB2 tables.
39.In which statement you can define primary key?
Primary keys are optional and we can define them in CRETAE TABLE & ALTER TABLE statements.
40.How many primary keys can be declared on a table?
A table can have only one primary key.