Black Friday Special Sale - 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: spcl70

Note! C2090-616 has been withdrawn.

Practice Free C2090-616 DB2 11.1 Fundamentals for LUW Exam Questions Answers With Explanation

We at Crack4sure are committed to giving students who are preparing for the IBM C2090-616 Exam the most current and reliable questions . To help people study, we've made some of our DB2 11.1 Fundamentals for LUW exam materials available for free to everyone. You can take the Free C2090-616 Practice Test as many times as you want. The answers to the practice questions are given, and each answer is explained.

Get Full 63 Questions Search Other IBM Exam
Question # 6

How can you tell what privileges on a table or view have been granted to a user? (Choose two.)

A.

db2look with the –x option

B.

db2pd with the –auth option

C.

Query the SYSCAT.DBAUTH view

D.

Query the SYSCAT.TABLES view

E.

Query the SYSCAT.TABAUTH view

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

A.

An error is returned

B.

An entry is mane in SYSCAT.TABAUTH

C.

The REVOKE statement succeeds with no effect

D.

All privileges are granted to user MYUSER on MYTABLE

Question # 8

Which three facilities are used to control authorization in DB2?

A.

privileges, db2ssh, LBAC credentials

B.

privileges, authority levels, certificates

C.

db2ssh, trusted contexts, authority levels

D.

privileges, authority levels, LBAC credentials

Question # 9

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