IBM C2090-616 Exam Practice Test Instant Access

Question 1

Which of the following features can provide significant benefits in storage savings, performance of analytic workloads, and time to value?

ApureScale

Bauto reorg

CBLU acceleration

DSelf tuning memory manager

Answer : C

Question 2

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;

AThe alias A1 will be dropped

BThe table T1 will be dropped

CBoth T1 and A1 will be dropped

DNothing, the statement will result in an error

Answer : A

Question 3

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?

ACloudant

BDB2 on Cloud

CdashDB for analytics

DdashDB for transactions

Answer : B

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

What of the following is TRUE about triggers?

ATriggers are activated by INSERT, UPDATE, DELETE and SELECT statements

BTriggers can be used to perform data manipulation operations against complex views

CTriggers can only be used to execute logic before or after appropriate SQL statements

DOnly one trigger for a particular event and activation time can be created for a particular table

Answer : A

Question 6

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

ADELETE FROM t1

BDELETE* FROM t1

CDELETE* TABLE t1

DTRUNCATE TABLE t1 IMMEDIATE

ETRUNCATE TABLE t1

Answer : A, D

Question 7

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

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