C2090-320 Online Practice Questions and Answers

Which of the following are contained in the PLAN_TABLE? (Choose two.)

A. RUNSTATS recommendations

B. Access to LOB values, which are stored separately from the base table

C. Access to parent or dependent tables needed to enforce referential constraints

D. Whether an index access or table space scan is used for each access to a table

E. The join methods and types that are used, and the order in which DB2 joins the tables

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

In which address space would a native SQL stored procedure run?

A. WLM

B. DIST

C. DBM1

D. The address space of the calling program

Given the following INDEX definition, which attributes apply to this index? (Choose two.)

A. The index is partitioned

B. The index data sets are user-managed

C. The index data sets are DB2-managed

D. The index is unique and in ascending order

E. The maximum total size of the index is 1 GB

Which type of index will cause DB2 to store the data in a given physical order?

A. UNIQUE

B. PRIMARY

C. CLUSTER

D. PARTITIONED

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

Select the SQL statement which will list the employee(empno) and the project numbers(projno) from the EMPACT table that has an employee(empno) whose salary(salary) is in the top three salaries for all employees from the EMP table.

A. SELECT empno, projno FROM empact ep WHERE ep.empno IN (SELECT em.empno FROM emp em ORDER BY salary DESC) FETCH FIRST 3 ROWS ONLY;

B. SELECT empno, projno FROM empact WHERE empno IN (SELECT empno FROM emp FETCH FIRST 3 ROWS ONLY);

C. SELECT ep.empno, projno FROM empact ep WHERE ep.empno IN (SELECT em.empno FROM emp em ORDER BY salary FETCH FIRST 3 ROWS ONLY);

D. SELECT ep.empno, projno FROM empact ep WHERE ep.empno IN (SELECT em.empno FROM emp em ORDER BY salary DESC FETCH FIRST 3 ROWS ONLY);

Which DB2 command displays the status information about DB2 database MYDB and displays the status of all objects in this database?

A. -DISPLAY DATABASE(MYDB) OVERVIEW

B. -DISPLAY DATABASE(MYDB) SPACENAM(*)

C. -DISPLAY DATABASE(MYDB) SPACENAM(*) RES

D. -DISPLAY DATABASE(MYDB) SPACENAM(*) ACTIVE

Which catalog table contains the IN, OUT and INOUT parameters used in a stored procedure?

A. SYSIBM.SYSSTMT

B. SYSIBM.SYSPARMS

C. SYSIBM.SYSROUTINES

D. SYSIBM.SYSVARIABLES

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