IBM IBM Certifications C2090-616 Questions & Answers

• Question 11:

  Which of the following is TRUE regarding user switching in a trusted context?

  A. You cannot switch user id in a trusted context.

  B. You can issue a switch-user request within a transaction.

  C. The new user must have the connect-privilege on the database for it to succeed.

  D. No password is ever required for the new user as an authentication is established in the trusted connection.

  Correct Answer: D

• Question 12:

  Which of the following authorities is sufficient for connecting to a database?

  A. SQLADM

  B. CONNECT

  C. DATAACESS

  D. ACCESSCTRL

  Correct Answer: D

• Question 13:

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

  A. YEARSBETWEEN

  B. BINARY and VARBINARY data types

  C. Double-dot notation to specify a database object

  D. OFFSET x ROWS FETCH FIRST y ROWS ONLY

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

  Correct Answer: CE

• Question 14:

  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);

  B. CREATE TABLE t1 (c1 INT, c2 INT) 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) DATA IN TS1 INDEX IN TS2;

  Correct Answer: B

• Question 15:

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

  A. Read Stability

  B. Cursor Stability

  C. Repeatable Read

  D. Uncommitted Read

  Correct Answer: C

• Question 16:

  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

  Correct Answer: CE

• Question 17:

  The application owners say they need to be able to query a table and previous versions of that table. Which type of table is appropriate to satisfy this requirement?

  A. Shadow Table

  B. Temporal Table

  C. Range-Partitioned Table

  D. Multidimensional Clustered Table

  Correct Answer: B

• Question 18:

  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. Returns information about the current server

  C. Prompts you for the authentication information

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

  Correct Answer: B

• Question 19:

  The DDL statement is used to create table T1: CREATE TABLEt1 (

  c1 INTEGER,

  c2 INTEGER NOT NULL,

  c1 DECIMAL(11,2),

  c4 TIMESTAMP WITH DEFAULT CURRENT TIMESTAMP

  )

  Which of the following INSERT statements will execute successfully?

  A. INSERT INTO t1 VALUES (100)

  B. INSERT INTO t1 (c1, c2) VALUES (100)

  C. INSERT INTO t1 (c1, c3) VALUES (`100', `100.00')

  D. INSERT INTO t1 (c2, c3) VALUES (100, 100.00), (101, 101)

  Correct Answer: B

• Question 20:

  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;

  A. The alias A1 will be dropped

  B. The table T1 will be dropped

  C. Both T1 and A1 will be dropped

  D. Nothing, the statement will result in an error

  Correct Answer: A