C2090-320 Online Practice Questions and Answers
Which of the following locking scenarios requires the least amount of real storage in the IRLM address space?
A. 10 row locks
B. 200 page locks
C. A single table space lock
D. 6 partition locks (given a table space with a total of 10 partitions)
Which of the following can be defined on the basis of a query?
A. An alias
B. A base table
C. An accelerator-only table
D. A materialized query table
Which BIND option determines when DB2 will do authorization checking?
A. DEFER
B. DEPLOY
C. VALIDATE
D. CURRENTDATA
Which statement is TRUE regarding catalog table SYSIBM.SYSROUTINES?
A. Contains scheduled tasks for the administrative scheduler
B. Contains information about UDFs, BIFs and stored procedures
C. Contains information about bound packages
D. Contains information about UDFs and stored procedures
How can a stored procedure be invoked?
A. Via an SQL SELECT statement
B. Via a CALL statement using SPUFI
C. Directly via a RUN PROGRAM command
D. Via a CALL statement from within an application program
A view is considered read only if which of the following is TRUE?
A. The first FROM clause identifies only one table
B. The outer fullselect contains an ORDERED BY clause
C. The first SELECT clause specifies the DISTINCT option
D. The fullselect includes a column of a base table that is defined as implicitly hidden
DB2 native SQL procedures execute in which DB2 address space?
A. IRLM
B. DIST
C. DBM1
D. WLM stored procedure
Your application has a read-only cursor. You cannot tolerate uncommitted data but want to make sure that it provides the best concurrency. Which of the following bind options would provide the locking you need with optimistic locking?
A. ISOLATION(UR)
B. ISOLATION(RS)
C. ISOLATION(CS) CURRENTDATA(NO)
D. ISOLATION(CS) CURRENTDATA(YES)
Which of the following statements is TRUE when issuing an SQL ROLLBACK (without SAVEPOINT) statement?
A. All held LOB locators are retained
B. All locks that are implicitly acquired during the unit of recovery are retained
C. All rows and all logical work files of every created temporary table of the application process are deleted
D. All cursors are closed, all prepared statements are retained, and any cursors that are associated with the prepared statements are invalidated
Which of the following automatically maintains historical versions of data over several years?
A. A partitioned-by-range table
B. A partitioned-by-growth table
C. A system-period temporal table
D. An application-period temporal table