C2090-610 Online Practice Questions and Answers

If the following command is executed: CREATE DATABASE test What is the page size (in kilobytes) of the database?

A. 4

B. 8

C. 16

D. 32

If the following result set is desired:

Which SQL statement must be executed?

A. SELECT lastname, firstnme, salary, job FROM employee ORDER BY 3 FETCH FIRST 5 ROWS ONLY

B. SELECT lastname, firstnme, salary, job FROM employee ORDER BY 3 DESC FETCH FIRST 5 ROWS ONLY

C. SELECT lastname, firstnme, salary, job FROM employee ORDER BY 3 FETCH FIRST 5 ROWS

D. SELECT lastname, firstnme, salary, job FROM employee ORDER BY 3 DESC FETCH FIRST 5 ROWS

User USER1 holds both DBADM and SECADM authority and you want to separate database administration activities from security administration tasks. What authority must you have in order to revoke SECADM authority from user USER1 and assign it to someone else?

A. DBADM

B. DBCTRL

C. SECADM

D. DBMAINT

By default, where is the data stored for a column defined with an XML data type?

A. In an XML index.

B. In line with the rest of the data for the table.

C. In an XML storage object that is separate from the table.

D. In line with the rest of the data for the table, for XML columns less than 32KB.

Which case will require a sequence to be dropped and recreated instead of being modified by the ALTER SEQUENCE statement?

A. Change the data type of the sequence.

B. Reset the sequence to its starting value.

C. Establish new minimum or maximum values.

D. Change the increment between future values.

Which method for restricting data access relies on a SQL search condition that describes what set of rows a user has access to?

A. Authentication

B. Authorities and privileges

C. Label-based access control

D. Row and column access control

Which object can be enabled for compression?

A. View

B. Buffer pool

C. Storage group

D. Temporary table

Which type of table is best suited for recording results from application data manipulation that is not required to be persistent?

A. Base Table

B. Temporal Table

C. Transition Table

D. Temporary Table

What mechanism is typically used to automatically update other tables, generate or transform values for inserted or updated rows, and perform tasks such as issuing alerts?

A. Trigger

B. Procedure

C. Table function

D. Scalar function

Which statement about a deadlock is true?

A. The victim will be rolled back.

B. The victim will read through the lock.

C. Both victim and holder are rolled back.

D. The victim must wait until the holder releases the lock.