C2090-320 | The Leading Guide To C2090-320 exam

Q1. Which of the following can activate a trigger?

A. A row is inserted

B. A table or view is created

C. A check constraint is defined

D. A referential constraint is violated

Answer: D

Q2. 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

Answer: D

Q3. Which of the following SQL constructs does NOT provide information about the success or failure of the SQL statement that was just executed?

A. SQLCA

B. SQLDA

C. SQLCODE

D. SQLSTATE

Answer: B

Q4. You want to limit the access of a table to allow users to only see certain columns and/or rows.

Which of the following options CANNOT be used to accomplish this?

A. A view

B. Multilevel security

C. An MQT (Materialized Query Table)

D. A combination of row permissions and column masks

Answer: C

Q5. 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

Answer: D

Q6. What is the result XQuery FLWOR expression when running the following scenario?

A. Joe Smith

B. <name> Joe Smith </name>

C. <employeeinfo><name> Joe Smith </name></employeeinfo>

D. <name> Joe Smith </name><department name>DB2</department name>

Answer: A

Q7. Which authorizations can change the value of the subsystem parameter SYSADM using the u2013SET SYSPARM command? (Choose two.)

A. SYSADM

B. SECADM

C. SYSCTRL

D. Installation SYSADM

E. Installation SYSOPR

Answer: DE

Q8. Which of the following describes OLTP workload rather than an analytics workload?

A. Extreme data volume

B. Temporary or intermediate staging of data

C. Set-oriented processing and bulk operations

D. A large number of short, discrete, atomic transactions

Answer: D

Q9. Which catalog tables are populated by RTS? (Choose two.)

A. SYSIBM.SYSTABLES

B. SYSIBM.SYSINDEXES

C. SYSIBM.SYSINDEXPART

D. SYSIBM.SYSINDEXSPACESTATS

E. SYSIBM.SYSTABLESPACESTATS

Answer: DE

Q10. 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

Answer: D