IBM IBM Certified Advanced Database Administrator C2090-610 Questions & Answers

• Question 91:

  A table named STATES was created as follows:

  

  What will happen?

  A. An error will be returned and the operation will fail.

  B. A warning will be returned and the unique index INDX1 will become the index for the primary key.

  C. The primary key will be successfully added and the unique index INDX1 will be dropped and recreated as the primary key index.

  D. The primary key will be successfully added, the unique index INDX1 will be dropped, and a new index will be created for the primary key.

  Correct Answer: B

• Question 92:

  Which SQL statement will give user USER1 the ability to assign a comment to a sequence named MYSEQ?

  A. GRANT ALTER ON SEQUENCE myseq TO user1

  B. GRANT USAGE ON SEQUENCE myseq TO user1

  C. GRANT SELECT ON SEQUENCE myseq TO user1

  D. GRANT COMMENT ON SEQUENCE myseq TO user1

  Correct Answer: A

• Question 93:

  In a trusted context environment, if a switch request is made with an authorization ID that is not allowed on a trusted connection, what state is the connection placed in?

  A. Locked

  B. Waiting

  C. Pending

  D. Unconnected

  Correct Answer: D

• Question 94:

  If a user has been granted SYSCTRL authority, which activities can they perform?

  A. Load operations

  B. Backup/copy table spaces

  C. Create and drop databases

  D. Monitor database performance

  Correct Answer: C

• Question 95:

  What is the purpose of a role?

  A. To define exactly what a specific user can do within a particular database once they have been authenticated.

  B. To group a collection of privileges together so that they can be simultaneously granted to and revoked from multiple users.

  C. To establish a credible relationship between DB2 and an external entity, such as a database administrator or a middleware server.

  D. To group a collection of users together so that they can be simultaneously granted and revoked specific authorities and privileges.

  Correct Answer: B

• Question 96:

  If the following result set is desired:

  

  Which SQL statement must be executed?

  A. SELECT lastname, firstnme, salary, job FROM employee ORDER BY 3 FETCH FIRST 5 ROWS ONLY

  B. SELECT lastname, firstnme, salary, job FROM employee ORDER BY 3 DESC FETCH FIRST 5 ROWS ONLY

  C. SELECT lastname, firstnme, salary, job FROM employee ORDER BY 3 FETCH FIRST 5 ROWS

  D. SELECT lastname, firstnme, salary, job FROM employee ORDER BY 3 DESC FETCH FIRST 5 ROWS

  Correct Answer: B

• Question 97:

  Which statement about INSERT operations is true?

  A. The INSERT statement is used to insert rows into a table, view, or table function.

  B. Inserted values must satisfy the conditions of any check constraints defined on the table.

  C. If an INSERT statement omits any column from the inserted row that is defined as NULL or NOT NULL WITH DEFAULT, the statement will fail.

  D. If the underlying table of a view being referenced by an INSERT statement has one or more unique indexes, each row inserted does not have to conform to the constraints imposed by those indexes.

  Correct Answer: B

• Question 98:

  Which statement about application-period temporal tables is true?

  A. Consists of explicitly-supplied timestamps and a separate associated history table.

  B. Is based on explicitly-supplied timestamps that define the time periods during which data is valid.

  C. Is useful when one wants to keep both user-based period information and system-based historical information.

  D. Consists of a pair of columns with database-manager maintained values that indicate the period when a row is current.

  Correct Answer: B

• Question 99:

  Which SQL statement should be used to select the minimum and maximum salaries (SALARY), by job code (JOB), from a table EMPLOYEE?

  A. SELECT job, MIN(salary), MAX(salary) FROM employee GROUP BY job;

  B. SELECT job, MIN(salary), MAX(salary) FROM employee ORDER BY job;

  C. SELECT job, MIN(salary), MAX(salary) FROM employee GROUP BY job, MIN(salary), MAX(salary);

  D. SELECT JOB, MIN(salary), MAX(salary) FROM employee ORDER BY job, MIN(salary), MAX(salary);

  Correct Answer: A

• Question 100:

  Which function can be used to obtain values from XML documents that are to be inserted into one or more tables?

  A. XMLTABLE

  B. XMLPARSE

  C. XMLEXISTS

  D. XMLATTRIBUTES

  Correct Answer: A