C2090-610 Online Practice Questions and Answers

What are two valid objects that can be created in DB2? (Choose two.)

A. Tree

B. Node

C. Trigger

D. Contexts

E. Sequence

Which statement will prevent concurrent application processes from performing anything other than read- only operations against a table named TAB1?

A. LOCK TABLE tab1 IN READ MODE

B. LOCK TABLE tab1 IN SHARE MODE

C. LOCK TABLE tab1 IN EXCLUSIVE MODE

D. LOCK TABLE tab1 IN READ-ONLY MODE

If a user has been granted SYSCTRL authority, which activities can they perform?

A. Load operations

B. Backup/copy table spaces

C. Create and drop databases

D. Monitor database performance

What is the purpose of a role?

A. To define exactly what a specific user can do within a particular database once they have been authenticated.

B. To group a collection of privileges together so that they can be simultaneously granted to and revoked from multiple users.

C. To establish a credible relationship between DB2 and an external entity, such as a database administrator or a middleware server.

D. To group a collection of users together so that they can be simultaneously granted and revoked specific authorities and privileges.

A table named EMPLOYEE was created as follows:

Which action will prevent unauthorized users from accessing SSN data?

A. Assign the SSN column to a restricted role that only authorized users can access.

B. Only grant ACCESSCTRL authority for the SSN column to users who need to access SSN data.

C. Alter the table definition so that SSN data is stored in a separate schema that only authorized users can access.

D. Create a view for the EMPLOYEE table that does not contain the SSN column and require unauthorized users to use the view.

Which privilege is required to invoke a user defined function?

A. CALL

B. USAGE

C. EXECUTE

D. REFERENCES

Which object can be enabled for compression?

A. View

B. Buffer pool

C. Storage group

D. Temporary table

What needs to be defined in order to track changes made to a system-period temporal table over time?

A. Once the row-begin, row-end, and transaction-start-id columns are created, all changes are tracked.

B. A history table must be created with identical columns to the base table and a unique index must be defined on the transaction-start-id column.

C. A history table must be created as a clone table of the base table after the row-begin, row-end, and transaction-start-id columns have beendefined.

D. A history table must be created with identical columns to the base table and then the base table altered with the ADD VERSIONING clause torelate it to the history table.

Which statement about foreign keys is true?

A. A table can have only one foreign key.

B. Foreign keys can only be defined when a table is created.

C. A foreign key can be defined on a column or a set of columns in a table.

D. Foreign keys are enforced only during the execution of INSERT statements.

Which database object provides an alternative way of describing data that exists in one or more base tables?

A. Alias

B. View

C. ndex

D. Sequence