IBM C2090-730 Online Practice Questions and Exam Preparation

IBM C2090-730 Online Questions & Answers

• Question 251:

  Which of the following constraint types can be used to ensure the value of an INTEGER column references only positive values?

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

• Question 252:

  Which of the following objects contains control structures that are considered the bound form of SQL statements?

  A. UDT
  B. Trigger
  C. Package
  D. Access plan
  C. Package

• Question 253:

  Which of the following products is used to shred extensible markup language documents?

  A. DB2 AVI Extender
  B. DB2 Text Extender
  C. DB2 XML Extender
  D. DB2 Spatial Extender
  C. DB2 XML Extender

• Question 254:

  Which of the following deletion rules on CREATE TABLE will allow parent table rows to be deleted if a dependent row exists?

  A. ON DELETE RESTRICT
  B. ON DELETE NO ACTION
  C. ON DELETE SET NO VALUE
  D. ON DELETE CASCADE
  D. ON DELETE CASCADE

• Question 255:

  On which two of the following database objects may the SELECT privilege be controlled?

  A. Sequence
  B. Nickname
  C. Schema
  D. View
  E. Index
  B. Nickname
  D. View

• Question 256:

  If the following statement is executed:

  CREATE TABLE tab1 (col1 INTEGER NOT NULL,

  col2 INTEGER,

  CONSTRAINT const1 FOREIGN KEY (col2)

  How many unique indexes are defined for table TAB1?

  B. 1
  C. 2
  D. 3
  A

• Question 257:

  Which tool must be used to analyze all of the database operations performed by an application against a DB2 for i5/OS database?

  A. Visual Explain
  B. Activity Monitor
  C. SQL Performance Monitor
  D. DB2 Performance Monitor
  C. SQL Performance Monitor

• Question 258:

  A user invoking a user-defined function requires which DB2 privilege?

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

• Question 259:

  User USER1 has the privileges needed to invoke a stored procedure named GEN_RESUME. User USER2 needs to be able to call the procedure - user USER1 and all members of the group PUBLIC should no longer be allowed to call the procedure.

  Which of the following statement(s) can be used to accomplish this?

  A. GRANT EXECUTE ON ROUTINEgen_resume TO user2 EXCLUDE user1, PUBLIC
  B. GRANT EXECUTE ON PROCEDUREgen_resume TO user2; REVOKE EXECUTE ON PROCEDURE gen_resume FROM user1, PUBLIC;
  C. GRANT CALL ON ROUTINEgen_resume TO user2 EXCLUDE user1 PUBLIC
  D. GRANT CALL ON PROCEDUREgen_resume TO user2; REVOKE CALL ON PROCEDURE gen_resume FROM user1, PUBLIC;
  B. GRANT EXECUTE ON PROCEDUREgen_resume TO user2; REVOKE EXECUTE ON PROCEDURE gen_resume FROM user1, PUBLIC;

• Question 260:

  Given the following table definition:

  STOCK:

  item VARCHAR(30)

  status CHAR(1) quantity INT price DEC(7,2)

  If items are indicated to be out of stock by setting STATUS to NULL and QUANTITY and PRICE to zero, which of the following statements would be used to update the STOCK table to indicate that all the items whose description begins with the letter "S" are out of stock?

  A. UPDATE stock SET (status = NULL; quantity, price = 0) WHERE item LIKE S%
  B. UPDATE stock SET (status, quantity,price) = (NULL, 0, 0) WHERE item LIKE S%
  C. UPDATE stock SET status = NULL, SET quantity = 0, SET price = 0 WHERE item LIKE 'S%'
  D. UPDATE stock SET (status = NULL), (quantity = 0), (price = 0) WHERE item LIKE S%
  B. UPDATE stock SET (status, quantity,price) = (NULL, 0, 0) WHERE item LIKE S%