C2090-616 Online Practice Questions and Answers

Which edition of DB2 LUW has been discontinued in v11.1?

A. DB2 Developer Edition

B. DB2 Express Server Edition

C. DB2 Enterprise Server Edition

D. DB2 Connect Enterprise Server Edition

Which of the following statements about triggers are TRUE? (Choose two.)

A. There is a limit of 8 for the maximum number of cascading trigger activations

B. Triggers can be activated as a result of changes due to referential constraint enforcement

C. Multiple INSTEAD OF triggers are allowed for each kind of operation on a given subject view

D. Constraints associated with a subject table are applied between execution of BEFORE and AFTER triggers

E. The activation of the triggers for a particular table, event and activation time are conducted in descending order of trigger creation time

Which of the following SQL statements will remove all rows from the table T1? (Choose two.)

A. DELETE FROM t1

B. DELETE* FROM t1

C. DELETE* TABLE t1

D. TRUNCATE TABLE t1 IMMEDIATE

E. TRUNCATE TABLE t1

What is the purpose of a role?

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

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

C. To group a collection of privileges together so that they can be simultaneously granted to and revoked from multiple users, groups, or other roles.

D. To assign one or more users that need to run local DB2 applications and tools on a particular server to the DB2ADMNS or the DB2USERS group.

A portion of your database tables are used for OLTP-type processing and another portion are used for more analytical queries. There is a small subset of tables that are used in both of these usage patterns. What could you use to derive the analytic improvements offered by BLU technology in such an environment?

A. Shadow tables

B. Range-partitioned tables

C. Materialized query tables

D. Multidimensional clustering tables

DB2 offers compatibility features through the DB2_COMPATIBILITY_VECTOR registry variable or the SQL_COMPAT global variable that improve application compatibility with which of the following? (Choose two.)

A. Oracle

B. Sybase

C. Netezza

D. MongoDB

E. Microsoft SQL Server

Your manager has asked you to review cloud service offering for hosting a DB2 database. As the DBA, you still want to maintain control over all maintenance and patching operations. Which of the following Cloud offerings best suits your needs?

A. Cloudant

B. DB2 on Cloud

C. dashDB for analytics

D. dashDB for transactions

A user executes the following statements:

REATE TABLE t1 (c1 INT, c2 INT);

CREATE ALIAS a1 FOR t1;

What will be the result if the user executes the following statement?

DROP ALIAS a1;

A. The alias A1 will be dropped

B. The table T1 will be dropped

C. Both T1 and A1 will be dropped

D. Nothing, the statement will result in an error

Which of the following isolation levels most reduces concurrency and is most likely to cause lock escalations?

A. Read Stability

B. Cursor Stability

C. Repeatable Read

D. Uncommitted Read

Which of the following authorities is sufficient for connecting to a database?

A. SQLADM

B. CONNECT

C. DATAACESS

D. ACCESSCTRL