IBM C2090-616 Exam Practice Test Instant Access

Question 1

Which operation typically requires a Share (S) lock?

AINSERT

BSELECT

CDELETE

DUPDATE

Answer : B

Question 2

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

ARead Stability

BCursor Stability

CRepeatable Read

DUncommitted Read

Answer : C

Question 3

Which of the following authorities are sufficient for creating a database? (Choose two.)

ADBADM

BSYSADM

CSECADM

DSYSCTRL

ESYSMAINT

Answer : B, D

Question 4

What is the purpose of a role?

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

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

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

DTo 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

Answer : A

Question 5

Which DB2 product required to allow connections from DB2 LUW to DB2 on z/OS?

ADB2 Connect

BDB2 Runtime Client

CDB2 Data Server Client

DDB2 Enterprise Server Edition

Answer : A

Question 6

Which three facilities are used to control authorization in DB2?

Aprivileges, db2ssh, LBAC credentials

Bprivileges, authority levels, certificates

Cdb2ssh, trusted contexts, authority levels

Dprivileges, authority levels, LBAC credentials

Answer : D

Question 7

Which of the following statements describe super exclusive (Z) locks for a table? (Choose two.)

ANo other applications can access the table

BOnly uncommitted read (UR) applications can access the table

CThe lock owner and other applications can read, but not update, the locked table

DThe lock owner can both read and update data. Other applications can read the table

EThis lock is acquired under certain conditions, such as when the table is altered or dropped or an index on the table is dropped

Answer : A, E

IBM DB2 11.1 Fundamentals for LUW C2090-616 Exam Practice Test