IBM C2090-610 Online Practice Questions and Exam Preparation

IBM C2090-610 Online Questions & Answers

• Question 51:

  What are INSTEAD OF triggers used for?

  A. To update data in other tables.
  B. To perform insert, update, and delete operations against complex views.
  C. To check or modify values before they are actually stored in a database.
  D. To run non-database operations that are coded in user-defined functions.
  B. To perform insert, update, and delete operations against complex views.

• Question 52:

  What is a function of a table check constraint?

  A. To provide a method of avoiding duplicate entries for a column.
  B. To provide a method of ensuring a column's values are within a specific range.
  C. To ensure that XML columns are properly populated in an associated XML table space.
  D. To enforce relationships between tables by checking the existence of rows in one table against another.
  B. To provide a method of ensuring a column's values are within a specific range.

• Question 53:

  A table named EMPLOYEE was created as follows:

  

  Which action will prevent unauthorized users from accessing SSN data?

  A. Assign the SSN column to a restricted role that only authorized users can access.
  B. Only grant ACCESSCTRL authority for the SSN column to users who need to access SSN data.
  C. Alter the table definition so that SSN data is stored in a separate schema that only authorized users can access.
  D. Create a view for the EMPLOYEE table that does not contain the SSN column and require unauthorized users to use the view.
  D. Create a view for the EMPLOYEE table that does not contain the SSN column and require unauthorized users to use the view.

• Question 54:

  By default, where is the data stored for a column defined with an XML data type?

  A. In an XML index.
  B. In line with the rest of the data for the table.
  C. In an XML storage object that is separate from the table.
  D. In line with the rest of the data for the table, for XML columns less than 32KB.
  C. In an XML storage object that is separate from the table.

• Question 55:

  Which SQL statement will allow user USER1 to create a view on a table named EMPLOYEE?

  A. GRANT CREATETAB ON DATABASE TO user1
  B. GRANT SELECT ON TABLE employee TO user1
  C. GRANT CREATEVIEW ON DATABASE TO user1
  D. GRANT REFERENCES ON TABLE employee TO user1
  B. GRANT SELECT ON TABLE employee TO user1

• Question 56:

  What mechanism is typically used to automatically update other tables, generate or transform values for inserted or updated rows, and perform tasks such as issuing alerts?

  A. Trigger
  B. Procedure
  C. Table function
  D. Scalar function
  A. Trigger

• Question 57:

  Which statement about BEFORE triggers is FALSE?

  A. A BEFORE trigger can be used to perform validation of input data.
  B. A BEFORE trigger can be used to automatically generate values for newly inserted rows.
  C. A BEFORE trigger is fired for each row in the set of affected rows before the trigger event executes.
  D. A BEFORE trigger is fired for each row in the set of affected rows instead of executing the trigger event.
  D. A BEFORE trigger is fired for each row in the set of affected rows instead of executing the trigger event.

• Question 58:

  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 59:

  What type of large object (LOB) is used to store LOB data together with the formatted rows on data pages, instead of in a separate LOB storage object?

  A. inline
  B. binary
  C. internal
  D. partitioned
  A. inline

• Question 60:

  Which two activities indicate the need for a data warehouse? (Choose two.)

  A. Confirm product inventory.
  B. Monitor product availability.
  C. Summarize sales by region.
  D. Identify patterns for products sold in the last five years.
  E. Associate one or more products with a purchase order.
  C. Summarize sales by region.
  D. Identify patterns for products sold in the last five years.