IBM C2090-730 Online Practice Questions and Exam Preparation

IBM C2090-730 Online Questions & Answers

• Question 181:

  Which of the following are all valid DB2 data types?

  A. LONG VARCHAR, SMALLINT, NUMBER, BLOB
  B. DECIMAL, DATE, DBCLOB, INTERVAL
  C. NUMERIC, TIMESTAMP, BYTE, FLOAT
  D. NUM, TIME, XML, DOUBLE
  D. NUM, TIME, XML, DOUBLE

• Question 182:

  Which of the following describes how DB2 9 stores an XML document if the XML Extender is not used?

  A. CLOB
  B. BLOB
  C. Hierarchically
  D. Rows and columns
  C. Hierarchically

• Question 183:

  Which of the following is the lowest cost DB2 product that can be legally installed on an AIX server?

  A. DB2 Express Edition
  B. DB2 Personal Edition
  C. DB2 Workgroup Server Edition
  D. DB2Enterprise Server Edition
  C. DB2 Workgroup Server Edition

• Question 184:

  A transaction using the Read Stability isolation level scans the same table multiple times before it terminates. Which of the following can occur within this transaction's processing?

  A. Uncommitted changes made by other transactions can be seen from one scan to the next.
  B. Rows removed by other transactions that appeared in one scan will no longer appear in subsequent scans.
  C. Rows added by other transactions that did not appear in one scan can be seen in subsequent scans.
  D. Rows that have been updated can be changed by other transactions from one scan to the next.
  C. Rows added by other transactions that did not appear in one scan can be seen in subsequent scans.

• Question 185:

  Which of the following is a valid DB2 data type?

  A. NUMBER
  B. INTERVAL
  C. BYTE
  D. NUM
  D. NUM

• Question 186:

  Which of the following SQL statements can be used to create a DB2 object to store numerical data as EURO data?

  A. CREATE NICKNAME euro FOR DECIMAL (9,3)
  B. CREATE ALIAS euro FOR DECIMAL (9,3)
  C. CREATE DISTINCT TYPE euro AS DECIMAL (9,3)
  D. CREATE DATA TYPE euro AS DECIMAL (9,3)
  C. CREATE DISTINCT TYPE euro AS DECIMAL (9,3)

• Question 187:

  Given the following table definitions:

  EMPLOYEE ID NAME DEPTID

  01 Smith 10 02 Bossy 20 03 Peterson 20 04 Goss 30 05 Pape 40 06 Avery 50 07 O'Neal 60 08 Carter 50 DEPARTMENT ID DEPTNAME

  05 Hardware 10 Kitchen 20 Shoes 30 Toys 40 Electronics 50 Automotive and the following query:

  SELECT e.id, d.deptname FROM employee e, department d WHERE e.deptid = d.id AND e.id > 4

  Which of the following queries will produce the same result set as the query above?

  A. SELECT e.id,d.deptname FROM employee e, department d WHERE e.id > 4
  B. SELECT e.id,d.deptname FROM employee e INNER JOIN department d ON e.deptid = d.id WHERE e.id > 4
  C. SELECT e.id,d.deptname FROM employee e FULL OUTER JOIN department d ON e.id = d.id WHERE e.id > 4
  D. SELECT e.id,d.deptname FROM employee e LEFT OUTER JOIN department d ON e.deptid = d.id WHERE e.id > 4 UNION ALL SELECT e.id, d.deptname FROM employee e RIGHT OUTER JOIN department d ON e.deptid = d.id WHERE e.id > 4
  B. SELECT e.id,d.deptname FROM employee e INNER JOIN department d ON e.deptid = d.id WHERE e.id > 4

• Question 188:

  What does the following statement do?

  GRANT REFERENCES (col1, col2) ON TABLE table1 TO user1 WITH GRANT OPTION

  A. Gives user USER1 the ability to refer to COL1 and COL2 of table TABLE1 in queries, along with the ability to give this authority to other users and groups.
  B. Gives user USER1 the ability to refer to COL1 and COL2 of table TABLE1 in views, along with the ability to give this authority to other users and groups.
  C. Gives user USER1 the ability to define a referential constraint on table TABLE1 using columns COL1 and COL2 as the parent key of the constraint.
  D. Gives user USER1 the ability to define a referential constraint on table TABLE1 using columns COL1 and COL2 as the foreign key of the constraint.
  C. Gives user USER1 the ability to define a referential constraint on table TABLE1 using columns COL1 and COL2 as the parent key of the constraint.

• Question 189:

  Given the requirements to store employee names, employee numbers, and when employees were hired, which of the following built-in data types CANNOT be used to store the day an employee was hired?

  A. Character Large Object
  B. Time
  C. Varying-Length Character String
  D. Timestamp
  B. Time

• Question 190:

  If a unique constraint is defined on column COL1 of table TAB1, what are the characteristics of COL1?

  A. COL1 will accept NULL values and can be referenced in another table's foreign key specification.
  B. COL1 will not accept NULL values and cannot be referenced in anothertables foreign key specification.
  C. COL1 will not accept NULL values and can be referenced in anothertables foreign key specification.
  D. COL1 will accept NULL values and cannot be referenced in anothertables foreign key specification.
  C. COL1 will not accept NULL values and can be referenced in anothertables foreign key specification.