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)

The metadata for which of the following objects is NOT stored in the DB2 catalog table SYSIBM.SYSTABLES?

A. A view

B. A temporal table

C. A created global temporary table

D. A declared global temporary table

Which package level privileges does the user smith have when the following statement is executed? GRANT ALL ON PACKAGE clct1.pkg1 TO smith;

A. GRANT, COPY, BIND, RUN

B. BIND, EXECUTE, COPY, RUN

C. CREATE, COPY, RUN, EXECUTE

D. COPY, BINDADD, SQL, EXECUTE

Given the following table and index definitions, what type of index will be created?

A. Non-partitioned index

B. Non-partitioned secondary index

C. Data-partitioned secondary index

D. Data-partitioned partitioning index

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

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 two of the following functions are synonyms of one another? (Choose two.)

A. CLOB

B. VALUE

C. IFNULL

D. DBCLOB

E. COALESCE

You have created a new index. What is the command to potentially change the access path for a static package?

A. FREE

B. RESET

C. REBIND

D. REFRESH

What is the implicitly created column in a base table which contains an XML column called?

A. Node ID

B. ROWID

C. LOCATOR

D. DOCID

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