IBM C2090-730 Online Practice Questions and Exam Preparation

IBM C2090-730 Online Questions & Answers

• Question 201:

  An index named EMPID_X exists for a table named EMPLOYEE.

  Which of the following will allow user USER1 to drop the EMPID_X index?

  A. GRANT DROP ON INDEXempid_x TO user1
  B. GRANT DELETE ON INDEXempid_x TO user1
  C. GRANT INDEX ON TABLE employee TO user1
  D. GRANT CONTROL ON INDEXempid_x TO user1
  D. GRANT CONTROL ON INDEXempid_x TO user1

• Question 202:

  Which of the following is NOT a characteristic of a declared temporary table?

  A. Declared temporary tables are not persistent and can only be used by the application that creates them
  B. It is possible for many applications to create declared temporary tables that have the same name
  C. Declared temporary tables are created by executing a CREATE TABLE statement with the DECLARED GLOBAL TEMPORARY clause specified
  D. Once the application that created a global temporary table is terminated, any records in the table are deleted and the table is automatically destroyed Data Concurrency
  C. Declared temporary tables are created by executing a CREATE TABLE statement with the DECLARED GLOBAL TEMPORARY clause specified

• Question 203:

  Which of the following are NOT stored in the system catalog tables?

  A. SQL statements used to create views
  B. SQL statements used to create triggers
  C. SQL statements used to create constraints
  D. Table names
  A. SQL statements used to create views

• Question 204:

  Which of the following database objects is considered executable using SQL?

  A. View
  B. Table
  C. Routine
  D. Package
  C. Routine

• Question 205:

  What type of constraint can be used to ensure that, in any given row in a table, the value of one column never exceeds the value of another column?

  A. Check
  B. Range
  C. Referential
  D. Informational
  A. Check

• Question 206:

  What is the SQL Performance Monitor used for?

  A. To examine the health of a DB2 Database Manager instance
  B. To visually construct complex DML statements and examine the results of their execution
  C. To schedule tasks, run tasks, and send notifications about completed tasks to other users
  D. To analyze database operations performed against a DB2 for i5/OS database
  D. To analyze database operations performed against a DB2 for i5/OS database

• Question 207:

  If DB2 detects a deadlock between application A and application B (each waiting for a lock held by the other one), what action will DB2 take?

  A. Rollback the transaction in both applications.
  B. Rollback the transaction in one of the two applications.
  C. Decrease the lock timeout value for both applications, thereby causing a lock timeout situation.
  D. Send a message to let the administrator know of the situation and decide which application or applications should be terminated.
  B. Rollback the transaction in one of the two applications.

• Question 208:

  Which of the following would NOT provide access to data stored in table TABLE1 using the name T1?

  A. An alias named T1 that references table TABLE1
  B. A view named T1 that references table TABLE1
  C. A schema named T1 that references table TABLE1
  D. An alias named T1 that references a view named V1 that references table TABLE1
  C. A schema named T1 that references table TABLE1

• Question 209:

  Which of the following is used to create and debug user-defined functions?

  A. SQL Assist
  B. Control Center
  C. Command Editor
  D. Developer Workbench
  D. Developer Workbench

• Question 210:

  A declared temporary table is used for which of the following purposes?

  A. Backup purposes
  B. Storing intermediate results
  C. Staging area for load operations
  D. Sharing result data sets between applications
  B. Storing intermediate results