C2090-320 Online Practice Questions and Answers

Which privilege will user smith be able to grant to another user on table emp when the following SQL is executed?

GRANT ALL ON TABLE emp TO smith WITH GRANT OPTION;

A. BIND

B. REORG

C. TRIGGER

D. EXECUTE

Which of the following is NOT TRUE?

A. An index can be created on XML columns

B. Length must be specified for an XML column

C. XML columns can be added to existing tables

D. Triggers can be created on tables with XML columns

Which statement is TRUE regarding ROLLBACK processing?

A. It only reads active logs

B. It always needs archive logs

C. It can never be processed just from memory

D. It uses output buffers, active and archive logs

Which privilege or authority is required to use the DSN command?

A. None

B. SYSADM

C. SECADM

D. EXECUTE

Which of the following is NOT a valid trigger?

A. MERGE

B. INSERT

C. UPDATE

D. DELETE

What is the proper sequence for running the steps of the program preparation process?

A. Precompile, compile, link edit, bind

B. Bind, precompile, compile, link edit

C. Precompile, bind, link edit, compile

D. Link edit, precompile, compile, bind

Which of the following SELECT statements returns a different data value than the other SQL statements?

A. SELECT MONTH (CURRENT TIMESTAMP) FROM SYSIBM.SYSDUMMY1;

B. SELECT EXTRACT(MONTH FROM CURRENT TIMESTAMP) FROM SYSIBM.SYSDUMMY1;

C. SELECT LPAD(LTRIM(SUBSTR(CHAR(CURRENT TIMESTAMP(10)),6,2),'0'),11,'') FROM SYSIBM.SYSDUMMY1;

D. SELECT TIMESTAMPDIFF(64, CHAR(CURRENT TIMESTAMP ?TIMESTAMP(`2016-01-0100.00.00'))) FROM SYSIBM.SYSDUMMY1;

What is the purpose of an auxiliary table?

A. To hold the data for a column that is defined in a base table

B. To hold only XML data

C. To hold data temporarily

D. To store rows that are deleted from another table

DB2 native SQL procedures execute in which DB2 address space?

A. IRLM

B. DIST

C. DBM1

D. WLM stored procedure

Which option is used with the RECOVER utility when the data sets of the target objects have already been restored to a point of consistency by another process offline?

A. LOGONLY

B. FROMDUMP

C. TOLASTCOPY

D. CURRENTCOPYONLY