IBM C2090-610 Online Practice Questions and Exam Preparation

IBM C2090-610 Online Questions & Answers

• Question 71:

  Application APP_A is performing updates to table TAB1 using the read stability (RS) isolation level. Which isolation level will allow application APP_B to retrieve all rows from table TAB1 immediately, rather than have to wait until application APP_A has finished making updates?

  A. Read Stability (RS)
  B. Cursor Stability (CS)
  C. Repeatable Read (RR)
  D. Uncommitted Read (UR)
  D. Uncommitted Read (UR)

• Question 72:

  If the following command is executed: CREATE DATABASE test What is the page size (in kilobytes) of the database?

  A. 4
  B. 8
  C. 16
  D. 32
  A. 4

• Question 73:

  Which privilege is required to invoke a user defined function?

  A. CALL
  B. USAGE
  C. EXECUTE
  D. REFERENCES
  C. EXECUTE

• Question 74:

  Which statement regarding triggers is true?

  A. Only one INSERT, UPDATE, or DELETE trigger can be defined per table.
  B. Triggers cannot be modified, they must be dropped and recreated with new definitions.
  C. Adding a trigger to a table that already has rows in it will cause triggered actions to be fired.
  D. Triggers can only be fired one time per statement irrespective of the number of rows affected.
  B. Triggers cannot be modified, they must be dropped and recreated with new definitions.

• Question 75:

  When is it appropriate to use a sequence?

  A. When you want to control the order in which triggers are fired.
  B. When you want to control the order in which stored procedures can be invoked.
  C. When you want to automatically generate a numeric value that is not tied to any specific column or table.
  D. When you want to automatically generate a numeric value for each row that is added to a specific table.
  C. When you want to automatically generate a numeric value that is not tied to any specific column or table.

• Question 76:

  An SQL function named DEPT_INFO was created as follows:

  

  What is the correct way to use this function in a query?

  A. SELECT dept_info(dept_id, dept_name)
  B. SELECT dept_id, dept_name FROM dept_info()
  C. SELECT TABLE dept_id, dept_name FROM dept_info()
  D. SELECT dept_id, dept_name FROM TABLE(dept_info()) AS results
  D. SELECT dept_id, dept_name FROM TABLE(dept_info()) AS results

• Question 77:

  Which SQL statement will retrieve the employee number (EMPNO), hire date (HIREDATE), and salary (SALARY) for each employee from a table named EMPLOYEE who was hired before 1998 and earns a salary of less than $35,000.00 per year?

  A. SELECT empno, hiredate, salary FROM employee FOR hiredate < '1998-01-01' AND salary < 35000
  B. SELECT empno, hiredate, salary FROM employee WHERE hiredate < '1998-01-01' AND salary < 35000
  C. SELECT empno, hiredate, salary FROM employee WHERE hiredate < '1998-01-01' OR salary < 35000
  D. SELECT empno, hiredate, salary FROM employee FOR hiredate < '1998-01-01' OR salary < 35000
  B. SELECT empno, hiredate, salary FROM employee WHERE hiredate < '1998-01-01' AND salary < 35000

• Question 78:

  What privilege is required to create a view on a table that you are not the owner of?

  A. INSERT
  B. SELECT
  C. CREATE
  D. TRIGGER
  B. SELECT

• Question 79:

  What needs to be defined in order to track changes made to a system-period temporal table over time?

  A. Once the row-begin, row-end, and transaction-start-id columns are created, all changes are tracked.
  B. A history table must be created with identical columns to the base table and a unique index must be defined on the transaction-start-id column.
  C. A history table must be created as a clone table of the base table after the row-begin, row-end, and transaction-start-id columns have beendefined.
  D. A history table must be created with identical columns to the base table and then the base table altered with the ADD VERSIONING clause torelate it to the history table.
  D. A history table must be created with identical columns to the base table and then the base table altered with the ADD VERSIONING clause torelate it to the history table.

• Question 80:

  Application APP_A is performing updates to table TAB1 using the cursor stability (CS) isolation level. If application APP_B wants to retrieve all rows from table TAB1 without waiting for application APP_A to finish making updates, what isolation level must application APP_B use?

  A. Read Stability (RS)
  B. Repeatable Read (RR)
  C. Uncommitted Read (UR)
  D. Cursor Stability (CS)
  C. Uncommitted Read (UR)