C2090-610 Online Practice Questions and Answers

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

In a trusted context environment, if a switch request is made with an authorization ID that is not allowed on a trusted connection, what state is the connection placed in?

A. Locked

B. Waiting

C. Pending

D. Unconnected

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.

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

A table named SALES contains a record for every sales transaction a company processes. A user wishes to see the number of transactions that are made by each salesman. Which SQL statement will produce the desired results?

A. SELECT name, COUNT(*) AS transactions FROM sales

B. SELECT name, COUNT(DISTINCT name) AS transactions FROM sales

C. SELECT name, COUNT(*) AS transactions FROM sales GROUP BY name

D. SELECT DISTINCT name, COUNT(*) AS transactions FROM sales GROUP BY transactions

Which statement about roll back operations is correct?

A. When a ROLLBACK statement is executed, all locks held by the terminating transaction are released.

B. When a ROLLBACK TO SAVEPOINT statement is executed, all locks acquired up to the savepoint are released.

C. When a ROLLBACK TO SAVEPOINT statement is executed, all locks acquired after the savepoint are released.

D. When a ROLLBACK statement is executed, all locks acquired for open cursors that were declared WITH HOLD, are held.

When a COMMIT statement is executed, what happens?

A. All locks held on the database are automatically released.

B. Data stored in global temporary tables is automatically deleted.

C. Open cursors defined WITH HOLD are closed, but their data is retained.

D. The current transaction is terminated and a new transaction boundary is started.

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.

What is the act of releasing a large number of row-level locks that an application holds on a single table to acquire a table-level lock known as?

A. Lock exchange

B. Lock promotion

C. Lock escalation

D. Lock conversion