IBM DB2 10.1 Fundamentals - C2090-610 Exam Practice Test

A. ALTER

B. COMMENT

C. UPDATE

D. USAGE

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

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

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

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

A. Label-based access control

B. Authentication

C. Authorities and privileges

D. Row and column access control

A. Multiple primary keys can be defined for a table.

B. A primary key can be referenced by only one foreign key.

C. A foreign key can reference multiple primary keys.

D. Primary keys and foreign keys are used to define relationships.

A. GRANT SELECT ON TABLE employee TO user1

B. GRANT CREATEVIEW ON DATABASE TO user1

C. GRANT REFERENCES ON TABLE employee TO user1

D. GRANT CREATETAB ON DATABASE TO user1

A. REVOKE UPDATE OF TABLESPACE mytbsp FROM user1

B. REVOKE CREATETAB ON TABLESPACE mytbsp FROM user1

C. REVOKE ALTER ON TABLESPACE mytbsp FROM user1

D. REVOKE USE OF TABLESPACE mytbsp FROM user1