IBM C2090-610 Online Practice Questions and Exam Preparation

IBM C2090-610 Online Questions & Answers

• Question 41:

  Which two DB2 objects can a view be derived from? (Choose two.)

  A. View
  B. Index
  C. Table
  D. Trigger
  E. Procedure
  A. View
  C. Table

• Question 42:

  Which DB2 object can be used to improve the execution performance of qualified SELECT statements?

  A. Trigger
  B. SQL Procedure
  C. Sequence Object
  D. Materialized Query Table
  D. Materialized Query Table

• Question 43:

  A table named DEPARTMENT contains the following data:

  

  What will happen?

  A. The statement will fail because a subquery cannot be used in an UPDATE statement.
  B. The statement will fail because the result set produced by the subquery will contain more than one row.
  C. The statement will succeed; the last record retrieved by the subquery will be used to provide a WORKDEPT value for the update operation.
  D. The statement will succeed; the first record retrieved by the subquery will be used to provide a WORKDEPT value for the update operation.
  B. The statement will fail because the result set produced by the subquery will contain more than one row.

• Question 44:

  Which two statements are true about foreign key constraints? (Choose two.)

  A. The foreign key constraint columns must be supported by an index.
  B. The foreign key constraint columns must be defined as NOT NULL.
  C. The number and data types of foreign key constraint columns must match the parent key.
  D. The columns of one foreign key constraint cannot be used in another foreign key constraint.
  E. To define a foreign key constraint there must be an associated primary key or unique key in the same or different table.
  C. The number and data types of foreign key constraint columns must match the parent key.
  E. To define a foreign key constraint there must be an associated primary key or unique key in the same or different table.

• Question 45:

  When is an INTENT EXCLUSIVE (IX) lock required?

  A. When a transaction intends to read or change data.
  B. When a transaction intends to change but not read data.
  C. When a transaction intends to read but not change data.
  D. When a transaction intends to change the system catalog.
  A. When a transaction intends to read or change data.

• Question 46:

  Which SQL statement would be used to retrieve only salaries that are greater than $100,000.00 from a table named EMPLOYEE?

  A. SELECT * FROM employee WHERE salary < 100000
  B. SELECT salary FROM employee WHERE salary > 100000
  C. SELECT salary FROM employee WHERE salary > 100,000.00
  D. SELECT * FROM employee WHERE salary GREATER THAN 100000
  B. SELECT salary FROM employee WHERE salary > 100000

• Question 47:

  By default, a column defined as a TIMESTAMP includes which attributes?

  A. No fractional digits or time zone.
  B. 6 fractional digits and no time zone.
  C. 12 fractional digits plus a time zone.
  D. 12 fractional digits and no time zone.
  B. 6 fractional digits and no time zone.

• Question 48:

  Which event will NOT cause a trigger to be fired?

  A. Execution of an INSERT statement.
  B. Execution of LOAD REPLACE operation.
  C. Execution of an INSERT operation of a MERGE statement.
  D. Execution of an UPDATE operation of a MERGE statement.
  B. Execution of LOAD REPLACE operation.

• Question 49:

  Which SQL statement will give a user named USER1 the ability to run an embedded SQL application named BENEFITS that calls a package named CORPDATA.PKGA?

  A. GRANT EXECUTE ON APPLICATION benefits TO user1
  B. GRANT EXECUTE ON PACKAGE corpdata.pkga TO user1
  C. GRANT EXECUTE ON APPLICATION PACKAGE corpdata.pkga TO user1
  D. GRANT EXECUTE ON APPLICATION benefits USING PACKAGE corpdata.pkga TO user1
  B. GRANT EXECUTE ON PACKAGE corpdata.pkga TO user1

• Question 50:

  When is a mask used to limit access to data in a table?

  A. When mandatory access control (MAC) is used to protect the table.
  B. When discretionary access control (DAC) is used to protect the table.
  C. When label-based access control (LBAC) is used to protect the table.
  D. When row and column access control (RCAC) is used to protect the table.
  D. When row and column access control (RCAC) is used to protect the table.