C2090-610 Online Practice Questions and Answers

Which two operations are allowed in the body of an SQL scalar user-defined function? (Choose two.)

A. CALL statements.

B. External file access.

C. Use of a scratch pad.

D. COMMIT statements.

E. SQL control statements.

Which statement about application-period temporal tables is true?

A. Consists of explicitly-supplied timestamps and a separate associated history table.

B. Is based on explicitly-supplied timestamps that define the time periods during which data is valid.

C. Is useful when one wants to keep both user-based period information and system-based historical information.

D. Consists of a pair of columns with database-manager maintained values that indicate the period when a row is current.

Which SQL statement should be used to select the minimum and maximum salaries (SALARY), by job code (JOB), from a table EMPLOYEE?

A. SELECT job, MIN(salary), MAX(salary) FROM employee GROUP BY job;

B. SELECT job, MIN(salary), MAX(salary) FROM employee ORDER BY job;

C. SELECT job, MIN(salary), MAX(salary) FROM employee GROUP BY job, MIN(salary), MAX(salary);

D. SELECT JOB, MIN(salary), MAX(salary) FROM employee ORDER BY job, MIN(salary), MAX(salary);

Which privilege is required to invoke a user defined function?

A. CALL

B. USAGE

C. EXECUTE

D. REFERENCES

Given the following statement:

GRANT DELETE ON TABLE sales TO User1 WITH GRANT OPTION;

Which statement is correct?

A. USER1 can only remove the SALES table.

B. USER1 can only remove records from the SALES table.

C. USER1 can remove the SALES table and grant the privilege to remove the SALES table to other users.

D. USER1 can remove records from the SALES table and grant the privilege to remove records from the SALES table to other users.

Which object can be enabled for compression?

A. View

B. Buffer pool

C. Storage group

D. Temporary table

Which statement about bitemporal tables is valid?

A. Bitemporal tables are system tables and can only be queried by the schema owner.

B. Creating a bitemporal table is similar to creating a regular table except users must specify a system time period column.

C. When data in a bitemporal table is updated, a row is added to it's associated history table.

D. Querying a bitemporal table will produce results for a complete timeline; a view must be created to obtain results for a specific time period.

Which DB2 product is a database cluster solution for non-mainframe platforms and is best suited for Online Transaction Processing (OLTP) workloads?

A. DB2 Connect

B. DB2 pureScale

C. Workload Manager

D. High Availability Disaster Recovery

If no isolation level is specified, what is the default isolation level used?

A. Cursor Stability (CS)

B. Repeatable Read (RR)

C. Read Stability (RS) with Currently Committed semantics

D. Cursor Stability (CS) with Currently Committed semantics

What isolation level prevents dirty reads, nonrepeatable reads, and phantoms?

A. Read stability (RS)

B. Cursor stability (CS)

C. Repeatable read (RR)

D. Uncommitted read (UR)