-
-
-
-
-
-
-
Which of the environments cannot access DB2
a.TSOb.CICSc.IMSd.BATCHe.All the above can access DB2.
All the above can access DB2. -
What is DBD ?
a.Database definitionb.Database descriptorc.Data buffer definitiond.Database dependencee.Direct buffer definitionDatabase descriptor
-
What does zero SQLCODE indicate
a.No rows were selected.b.DB2 not operationalc.SQL completed successfully.d.SQL cannot be executed because program not bound.e.No SQL statements were input.SQL completed successfully.
-
DB2 transactions
Two or more transactions in a simultaneous wait state, each waiting for other to release before it can proceed, is calleda.Lost Updateuncommitted dependencyinfinite loopd.Deadlocke.With holdDeadlock
-
DB2 Table Delete Question
Target table T1 is getting deleted. Table T2 has the foreign key. We require that whenever a row from T1 is deleted, the corresponding row from T2 also be deleted. Which option can be used? a.ON DELETE RESTRICTb.ON DELETE CASCADEc.ON DELETE SET NULLd.ON DELETE CHILDe.ON DELETE MATCHON DELETE CASCADE
-
What kind of Database DB2 is ?
DB2 is aa.Database/Data Communication Systemb.Databasec.Relational Database Management Systemd.Programming Languagee.Operating systemRelational Database Management System
-
When do you open cursor before Fetching
i) Cursor should always be Opened before Fetching ii) Fetch Operation cursor retrieves Only ONE row for every execution. Of the Statement.Which are true?1 Both are True2 i) is only True3 ii) is False Both are True
-
DB2 Index Storate Format
Indexes is Stored in 1 B - Tree format2 Hash Table3 AVL Tree4 Red Black Tree
B - Tree format -
DB2 Synonyms
i) Synonyms can refer to local and remote table ii) Alias can refer only to local tables Of the Statement 1 Both are TRUE2 Both Are False3 i) is Only True4 ii) is Only True Both Are False
-
DB2 memory structures
What are memory structures used to handle multiple row selections at a time 1 Cursors2 Host Variables3 Indicator Variable4 SQLCACursors
-
What is the correct sequence of working with the cursors in a COBOL/DB2 program
1 Declare / fetch / open / close2 Open / Declare / fetch /close3 Declare / open / fetch /close4 None of the aboveDeclare / open / fetch /close
-
DB2 Storage groups
Select the correct statement 1 Storage groups can be altered2 Database can be altered3 Tablespace can be altered4 All of the Choices
All of the Choices -
-
A stored procedure has been built and deployed on the DB2 UDB server machine. What is the minimum software that must be installed to allow an application on the client to execute the stored procedure?
A stored procedure has been built and deployed on the DB2 UDB server machine. What is the minimum software that must be installed to allow an application on the client to execute the stored procedure? A. DB2 Runtime Client B. DB2 Personal Edition C. DB2 Administration Client D. DB2 Application Development Client
DB2 Interview Questions
Ans