C2090-320 Exam Questions

Which of the following is TRUE for using LOAD on a partition-by-growth table space?

Which of the following can be defined on the basis of a query?

In order to run a DB2 program, the user issues the following commands: TSO prompt: READY USER enters: DSN SYS(SSTR) USER enters: RUN PROGRAM(MYPROG) USER enters: END What is the re...

Which SQL language element can be used to define a set of actions that are executed when a DELETE, INSERT, or UPDATE operation occurs on a specified table or view?

When a stored procedure returns a result set to the calling program, which of the following statements is true about the two programs?

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

Which of the following are advantages of DB2 for z/OS data sharing over a standalone DB2 subsystem implementation? (Choose two.)

The maximum size for each partition of a partition-by-range table space, with fewer than 255 partitions, is determined by which combination of options? (Choose two.)

Which of the following statements about a system-period temporal table is TRUE?

Which types of user-defined data types are supported? (Choose two.)

Which BIND option determines when DB2 will do authorization checking?

COL1 is defined as CHAR(05) and contains CHAR(`12345'). Which of the following expressions returns the digits 12345 for further calculation?

Which DB2 address space manages DB2 locking?

What are two major encoding schemes? (Choose two.)

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 transaction reads the same row twice and needs the same value returned each time. However, it is not concerned about new rows appearing during the course of the transaction's exe...

Which of the following data types would be used to specify an implicit decimal point?

Which of the following tables can be used to set the default of the special register CURRENT APPLICATION COMPATIBILITY for remote users?

Which statement is TRUE regarding catalog table SYSIBM.SYSROUTINES?

Which SQL statement can be used to provide diagnostic information about the last SQL statement that was executed?

Consider the following question: "What is the average salary by sex within education level?" An occasional uncommitted record can be tolerated in the average. Which of the followin...

Which component of the program preparation produces a DBRM (Database request Module)?

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

A clone table can only be created in which of the following?

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

A summary table can be easily maintained using which of the following?

In the parent table of a referential constraint, a parent key must be which of the following? (Choose two.)

How can a stored procedure be invoked?