IBM C2090-730 Online Practice Questions and Exam Preparation

IBM C2090-730 Online Questions & Answers

• Question 281:

  An Alias can be an alternate name for which DB2 object?

  A. Sequence
  B. Trigger
  C. Schema
  D. View
  D. View

• Question 282:

  When a client using the SERVER_ENCRYPT authentication type connects to a server using the SERVER authentication type, what happens?

  A. An error will occur.
  B. Data passed between the client and the server is encrypted.
  C. User IDs and passwords are passed to the server unencrypted.
  D. User IDs and passwords are encrypted before they are passed to the server.
  A. An error will occur.

• Question 283:

  Which of the following is NOT an accurate statement about views?

  A. Views are publicly referenced names and no special authority or privilege is needed to use them.
  B. Views can be used to restrict access to columns in a base table that contain sensitive data
  C. Views can be used to store queries that multiple applications execute on a regular basis in a database
  D. Views support INSTEAD OF triggers
  A. Views are publicly referenced names and no special authority or privilege is needed to use them.

• Question 284:

  Which kind of non-sourced UDF can be created so that it only returns a single value?

  A. Row
  B. Table
  C. Scalar
  D. Column
  C. Scalar

• Question 285:

  If the following SQL statement is executed:

  CREATE TABLE sales

  (invoice_no NOT NULL PRIMARY KEY,

  sales_date DATE,

  sales_amt NUMERIC(7,2))

  IN tbsp0, tbsp1, tbsp2, tbsp3

  PARTITION BY RANGE (sales_date NULLS FIRST)

  (STARTING '1/1/2007' ENDING '12/31/2007'

  EVERY 3 MONTHS)

  Which of the following statements is true?

  A. Administrative tasks such as backing up, restoring, and reorganizing data stored in the SALES table must be done at the table level; not at the partition level
  B. Data can be quickly rolled in and out of the SALES table by using the ATTACH PARTITION and DETACH PARTITION clauses of the ALTER TABLE statement
  C. If an index is created for the SALES table, its data must be stored in table space TBSP0
  D. When resolving queries against the SALES table, each partition used is scanned asynchronously and the results of each partition scan are merged to produce the result data set returned
  B. Data can be quickly rolled in and out of the SALES table by using the ATTACH PARTITION and DETACH PARTITION clauses of the ALTER TABLE statement

• Question 286:

  Which of the following DB2 objects can be referenced by an INSERT statement to generate values for a column?

  A. Sequence
  B. Identity column
  C. Trigger
  D. Table function
  A. Sequence

• Question 287:

  Which of the following is NOT true about schemas?

  A. If a schema name is not specified, either by qualifying a database object name or by executing the SET CURRENT SCHEMA statement, the authorization ID of the current session user is used as the schema name by default
  B. The value assigned to the CURRENT SCHEMA special register is persistent across database restarts
  C. A schema enables the creation of multiple objects in a database without encountering namespace collisions
  D. When most database objects are created, they are either implicitly or explicitly assigned to a schema
  B. The value assigned to the CURRENT SCHEMA special register is persistent across database restarts

• Question 288:

  Which of the following tools is used to view historical information about tasks, database changes, messages, and notifications?

  A. Journal
  B. Task Center
  C. Control Center
  D. Activity Monitor
  A. Journal

• Question 289:

  To which of the following resources can a lock be applied?

  A. Row
  B. Alias
  C. Bitmap
  D. Column
  A. Row

• Question 290:

  Assuming USER1 has no authorities or privileges, which of the following will allow USER1 to create a view named VIEW1 that references two tables named TAB1 and TAB2?

  A. CREATEIN privilege on the database
  B. REFERENCES privilege on TAB1 and TAB2
  C. CREATE_TAB privilege on the database
  D. SELECT privilege on TAB1 and TAB2
  D. SELECT privilege on TAB1 and TAB2