Year End Sale - Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: dpt65

C2090-616 Questions and Answers

Question # 6

The following statements are executed:

GRANT CREATETAB, DATAACCESS, ON DATABASE TO ROLE role A;

GRANT CREATETAB, BINDADD ON DATABASE TO ROLE role B;

GRANT ROLE role A to USER db2inst3;

GRANT ROLE role B to USER db2inst3;

Which of the following is TRUE if this statement is executed later?

REVOKE ROLE roleB FROM USER db2inst3;

A.

This statement will succeed and DB2 INST3 will still be able to create in the database

B.

This statement will succeed and DB2 INST3 only retains DATAACCESS privileges on the database

C.

This statement will fail as CREATETAB is granted to two different roles and must be revoked at the same time

D.

This statement will succeed with a warning since CREATETAB cannot be totally revoked. DB2INST3 will retain both roles

Full Access
Question # 7

Which database object can be locked explicitly?

A.

Row

B.

View

C.

Index

D.

Table

Full Access
Question # 8

Which of the following statements about stored procedures is TRUE?

A.

Stored procedures can be written in SQL PL, but not in the PL/SQL dialect

B.

The CREATE SOURCED PROCEDURE statement defines a procedure that is based on another procedure in a federated database

C.

There are three types of stored procedures which can be deployed: SQL procedures, external procedures, and sourced procedures

D.

Two identically-named procedures within a schema are permitted to have exactly the same number of parameters, but the parameters must have different data types assigned

Full Access
Question # 9

The current user wants to produce a list of all user privileges she has been granted. Which table or view can be queried to produce the desired result?

A.

SYSCAT.DBAUTH

B.

SYSIBMADM.GRANTS

C.

SYSIBMADM.PRIVILEGES

D.

SYSCAT.USER_TAB_PRIVS

Full Access