IBM C2090-616 Exam Practice Test Instant Access

Question 1

What happens when you run the following statement if MYUSER holds no privileges on table MYTABLE?

REVOKE SELECT ON TABLE mytable FROM USER myuser

AAn error is returned

BAn entry is mane in SYSCAT.TABAUTH

CThe REVOKE statement succeeds with no effect

DAll privileges are granted to user MYUSER on MYTABLE

Answer : C

Question 2

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 3

You are asked to provide a recommendation for the appropriate DB2 edition for a new application. The application is characterized by long, complex queries that select a subset of columns and often perform grouping and aggregation. The initial database size is estimated at 5 TB, with growth of about 100 GB per year. Keep data size on disk to a minimum is a priority?

Which of the following editions would be best meet the described needs?

ADB2 Express-C

BDB2 Enterprise Server Edition

CDB2 Workgroup Server Edition

DDB2 Advanced Enterprise Server Edition

Answer : D

Question 4

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 5

Which locking event occurs when two applications lock rows that are needed by the other, such that neither application can continue executing?

ADeadlock

BLock timeout

CLock escalation

DLock conversion

Answer : A

Question 6

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

ASQLADM

BCONNECT

CDATAACESS

DACCESSCTRL

Answer : B

Question 7

If you are already connected to a database, what does running the following statement do?

Db2 CONNECT

APrompts you for the database name or alias

BReturns information about the current server

CPrompts you for the authentication information

DReturns an error, because you provided no database or alias

Answer : B

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