DB2 11.1 Fundamentals for LUW (C2090-616) Free Practice Test

Question 1

Which optional NPS compatibility features will be activated by executing the following? (Choose two.) SET SQL_COMPAT='NPS'

A. YEARSBETWEEN

B. OFFSET x ROWS FETCH FIRST y ROWS ONLY

C. TRANSLATE (char-string-exp, from-string-exp, to-string-exp)

D. BINARY and VARBINARY data types

E. Double-dot notation to specify a database object

Correct Answer: C,E

Question 2

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

A. Query the SYSCAT.TABLES view

B. db2look with the -x option

C. db2pd with the -auth option

D. Query the SYSCAT.DBAUTH view

E. Query the SYSCAT.TABAUTH view

Correct Answer: D,E

Question 3

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 with a warning since CREATETAB cannot be totally revoked. DB2INST3 will retain both roles

B. This statement will succeed and DB2 INST3 will still be able to create in 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 and DB2 INST3 only retains DATAACCESS privileges on the database

Correct Answer: A

Question 4

Which of the following statements will successfully create a table that scores index data in a different table space than the table data?

A. CREATE TABLE t1 (c1 INT, c2 INT) IN TS1 INDEX IN TS2;

B. CREATE TABLE t1 (c1 INT, c2 INT) DATA IN TS1 INDEX IN TS2;

C. CREATE TABLE t1 (c1 INT, c2 INT) IN TS1 INDEX IN TS1;

D. CREATE TABLE t1 (c1 INT, c2 INT);

Correct Answer: A

Question 5

Which of the following isolation levels most reduces concurrency and is most likely to cause lock escalations?

A. Repeatable Read

B. Uncommitted Read

C. Read Stability

D. Cursor Stability

Correct Answer: A

Question 6

Which three facilities are used to control authorization in DB2?

A. privileges, authority levels, LBAC credentials

B. privileges, authority levels, certificates

C. db2ssh, trusted contexts, authority levels

D. privileges, db2ssh, LBAC credentials

Correct Answer: A

Question 7

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

A. Prompts you for the database name or alias

B. Prompts you for the authentication information

C. Returns an error, because you provided no database or alias

D. Returns information about the current server

Correct Answer: D

Welcome to TestSimulate

IBM DB2 11.1 Fundamentals for LUW (C2090-616) Free Practice Test