IBM C2090-730 Online Practice Questions and Exam Preparation

IBM C2090-730 Online Questions & Answers

• Question 51:

  A client application on z/OS must access a DB2 database on a Solaris Server. At a minimum, which of the following products must be installed on the Solaris workstation?

  A. DB2 ConnectEnterprise Edition
  B. DB2 Workgroup Server Edition
  C. DB2 Workgroup Server Edition and DB2 ConnectEnterprise Edition
  D. DB2Enterprise Server Edition and DB2 Connect Enterprise Edition
  D. DB2Enterprise Server Edition and DB2 Connect Enterprise Edition

• Question 52:

  When defining a referential constraint between the parent table T2 and the dependent table T1, which of the following is true?

  A. The list of column names in the FOREIGN KEY clause can be a subset of the list of column names in the primary key of T2 or a UNIQUE constraint that exists on T2.
  B. The list of column names in the FOREIGN KEY clause can be a subset of the list of column names in the primary key of T1 or a UNIQUE constraint that exists on T1.
  C. The list of column names in the FOREIGN KEY clause must be identical to the list of column names in the primary key of T2 or a UNIQUE constraint that exists on T2.
  D. The list of column names in the FOREIGN KEY clause must be identical to the list of column names in the primary key of T1 or a UNIQUE constraint that exists on T1.
  C. The list of column names in the FOREIGN KEY clause must be identical to the list of column names in the primary key of T2 or a UNIQUE constraint that exists on T2.

• Question 53:

  Given the following scenario:

  Table TABLE1 needs to hold specific numeric values up to 9999999.999 in column COL1. Once TABLE1 is populated, arithmetic operations will be performed on data stored in column COL1. Which of the following would be the most appropriate DB2 data type to use for column COL1?

  A. INTEGER
  B. REAL
  C. NUMERIC(7, 3)
  D. DECIMAL(10, 3)
  D. DECIMAL(10, 3)

• Question 54:

  Which of the following will be a consequence of defining the column IDCOL2 in TABLE2 as a foreign key referencing the primary key (IDCOL1) of TABLE1?

  A. DB2 will no longer allow updating the value of IDCOL1 in TABLE1.
  B. When inserting a row in TABLE2, the only values that DB2 will allow for IDCOL2 are the existing values of IDCOL1.
  C. When inserting a row in TABLE2, DB2 will only allow foreign values forIDCOL2, that is values which do not exist in IDCOL1.
  D. When a SELECT statement joins TABLE1 with TABLE2, DB2 will automatically add the condition TABLE1.IDCOL1=TABLE2. IDCOL2 if not specified in the statement.
  B. When inserting a row in TABLE2, the only values that DB2 will allow for IDCOL2 are the existing values of IDCOL1.

• Question 55:

  Which of the following is true about XML columns?

  A. XML columns are used to store XML documents as a hierarchical set of entities
  B. OnlyXQuery can be used to retrieve an XML document from an XML column
  C. XML columns must be altered to accommodate additional parent/child relationships if they are used in referential constraints
  D. In order to access any portion of an XML document stored in an XML column, the entire document must be retrieved
  A. XML columns are used to store XML documents as a hierarchical set of entities

• Question 56:

  Which of the following strings can NOT be inserted into an XML column using XMLPARSE()?

  A. ""
  B. "John Doe"
  C. ""
  D. ""
  C. ""

• Question 57:

  User USER1 holds CONTROL privilege on table TABLE1. Which two of the following statements is user USER1 allowed to execute?

  A. GRANT CONTROL ON table1 TO user2
  B. GRANT LOAD ON table1 TO user2
  C. GRANT INSERT,UPDATE ON table1 TO user2 WITH GRANT OPTION
  D. GRANT BINDADD ON table1 TO PUBLIC
  E. GRANT ALL PRIVILEGES ON table1 TO PUBLIC
  C. GRANT INSERT,UPDATE ON table1 TO user2 WITH GRANT OPTION
  E. GRANT ALL PRIVILEGES ON table1 TO PUBLIC

• Question 58:

  Which of the following actions will NOT cause a trigger to be fired?

  A. INSERT
  B. DELETE
  C. ALTER
  D. UPDATE
  C. ALTER

• Question 59:

  A programmer wants to generate values for a numeric ID column in their EXPENSE table. The ID column values need to be incremented by 1000 for each new expense report added to the EXPENSE table. Which DB2 object can be referenced by an INSERT statement to meet this requirement?

  A. Sequence
  B. Table Function
  C. Identity Column
  D. INSTEAD OF Trigger
  A. Sequence

• Question 60:

  Assuming PUBLIC has been granted all privileges on table T1, which of the following statements would continue to permit any user to add rows to table T1, but not remove them?

  A. REVOKE DROP ON t1 FROM PUBLIC
  B. REVOKE UPDATE ON t1 FROM PUBLIC
  C. REVOKE DELETE ON t1 FROM PUBLIC
  D. REVOKE CONTROL ON t1 FROM PUBLIC
  C. REVOKE DELETE ON t1 FROM PUBLIC