Pre-Winter Special - 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: c4sdisc65

Note! C2090-616 has been withdrawn.

C2090-616 Practice Exam Questions with Answers DB2 11.1 Fundamentals for LUW Certification

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

Full Access
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

Full Access
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

Full Access
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

Full Access