-
Which DB2 components allows references to Oracle and DB2 databases in a single query?
Which of the following DB2 components allows references to Oracle and DB2 databases in a single query? A. DB2 Query Patroller B. DB2 Warehouse Manager C. DB2 Relational Connect D. DB2 Connect Enterprise Edition
-
Generate DDL?
If, for a given table, the Control Center does not show the choice Generate DDL, which of the following describes the reason? A. The table is a system object. B. The table is a summary table. C. The table is in LOAD PENDING. D. The table is a replicated table. E. The table was created by a different user.
-
DB2 generate ddl
If, for a given table, the Control Center does not show the choice Generate DDL, which of the following describes the reason? A. The table is a system object. B. The table is a summary table. C. The table is in LOAD PENDING. D. The table is a replicated table. E. The table was created by a different user.
-
What is deadlock?
Deadlock occurs when transactions executing at the same time lock each other out of data that they need to complete their logical units of work. What are the four lockable units for DB2?
-
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
-
What is the purpose of the WHENEVER statement?
A54. The WHENEVER statement is coded once in the host program to control program actions depending on the SQL-CODE returned by each sql statement within the program.
-
What is the significance of the cursor with hold clause in a cursor declaration?
The clause avoids closing the cursor and repositioning it to the last row processed when the cursor is reopened.
-
-
DB2 protocol information
When using DB2 Connect, which of the following commands specifies the protocol information on how to connect to the host or to the server? A. CATALOG DCS B. CATALOG NODE C. CATALOG DATABASE D. CATALOG ODBC DATA SOURCE
-
DB2 Flavours
What are the flavours of DB2?
-
-
-
-
-
-
What are some sql aggregates and other built-in functions?
The common aggregate, built-in functions are AVG, SUM, MIN, MAX, COUNT and DISTINCT.
-
What is isolation level?
SQL statements may return any number of rows, but most host languages deal with one row at a time by declaring a cursor that presents each row at a unique isolation level.
-
-
DB2 plans
How many DB2 plans can be connected to CICS region at a time? a). Infinite b). 1 c). Depends on CICS region definitions d). 255 e). None of the above
-
Which can duplicate the structure and related objects of a DB2 database table?
Which of the following can duplicate the structure and related objects of a database table? A. Copy table B. Alter table C. Export table D. Generate DDL
DB2 Interview Questions
Ans