IBM C2090-610 Online Practice Questions and Exam Preparation

IBM C2090-610 Online Questions & Answers

• Question 21:

  Which statement about foreign keys is true?

  A. A table can have only one foreign key.
  B. Foreign keys can only be defined when a table is created.
  C. A foreign key can be defined on a column or a set of columns in a table.
  D. Foreign keys are enforced only during the execution of INSERT statements.
  C. A foreign key can be defined on a column or a set of columns in a table.

• Question 22:

  What functionality allows users to perform a UNION operation between a DB2 table and an Oracle view?

  A. Oracle connect
  B. Trusted context
  C. Oracle federation
  D. Distributed request
  D. Distributed request

• Question 23:

  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
  A. XMLTABLE

• Question 24:

  Which type of constraint can be used to ensure that an INTEGER column in a table will never be assigned more than one record that contains a NULL value?

  A. Unique constraint
  B. Primary key constraint
  C. Informational constraint
  D. Column default constraint
  A. Unique constraint

• Question 25:

  You have a business need to query DB2 10 and DB2 9 databases and you want to write an application that can run on most platforms unchanged. Which interface would you use to achieve your goal?

  A. CLI
  B. XML
  C. JDBC
  D. RUBY
  C. JDBC

• Question 26:

  Which SQL statement will retrieve the department number (WORKDEPT) and average departmental salary (SALARY) for all departments in a table named EMPLOYEE and arrange the result set in ascending order by average departmental salary?

  A. SELECT workdept, AVG(salary) FROM employee ORDER BY workdept GROUP BY 2
  B. SELECT workdept, AVG(salary) FROM employee ORDER BY workdept ARRANGE BY 2
  C. SELECT workdept, AVERAGE(salary) FROM employee GROUP BY workdept ORDER BY 2
  D. SELECT workdept, AVG(salary) FROM employee GROUP BY workdept ORDER BY 2
  D. SELECT workdept, AVG(salary) FROM employee GROUP BY workdept ORDER BY 2

• Question 27:

  Which statement about roll back operations is correct?

  A. When a ROLLBACK statement is executed, all locks held by the terminating transaction are released.
  B. When a ROLLBACK TO SAVEPOINT statement is executed, all locks acquired up to the savepoint are released.
  C. When a ROLLBACK TO SAVEPOINT statement is executed, all locks acquired after the savepoint are released.
  D. When a ROLLBACK statement is executed, all locks acquired for open cursors that were declared WITH HOLD, are held.
  A. When a ROLLBACK statement is executed, all locks held by the terminating transaction are released.

• Question 28:

  Which product is used to customize execution environments for the purpose of controlling system resources so that one department or service class does not overwhelm the system?

  A. pureScale
  B. Workload manager
  C. Data partitioning feature
  D. Self-tuning memory manager
  B. Workload manager

• Question 29:

  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
  C. Create and drop databases

• Question 30:

  What is the act of exchanging one lock an application holds on a resource for a more restrictive lock on the same resource known as?

  A. Lock escalation
  B. Lock substitution
  C. Lock switch/exchange
  D. Lock conversion/promotion
  D. Lock conversion/promotion