C2090-610 Online Practice Questions and Answers

Which clause should be included in a ALTER TABLE statement to update a table definition with a new column?

A. ADD COLUMN

B. ALTER COLUMN

C. APPEND COLUMN

D. RENAME COLUMN

What type of mechanism is a simple token value that is used to refer to a much bigger large object (LOB)?

A. locator

B. pointer

C. address

D. reference

Which command will delete all rows from a table without generating log records?

A. TRIM

B. DROP

C. DELETE

D. TRUNCATE

Which SQL statement will give user USER1 the ability to assign a comment to a sequence named MYSEQ?

A. GRANT ALTER ON SEQUENCE myseq TO user1

B. GRANT USAGE ON SEQUENCE myseq TO user1

C. GRANT SELECT ON SEQUENCE myseq TO user1

D. GRANT COMMENT ON SEQUENCE myseq TO user1

What is used in conjunction with a foreign key to define a relationship between two tables?

A. Primary key

B. Partitioning key

C. Check constraint

D. Unique constraint

Which object can be enabled for compression?

A. View

B. Buffer pool

C. Storage group

D. Temporary table

Which DB2 object is associated with PREVIOUS VALUE and NEXT VALUE expressions?

A. View

B. Table

C. Sequence

D. Identity Column

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

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 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)