IBM C2090-730 Online Practice Questions and Exam Preparation

IBM C2090-730 Online Questions & Answers

• Question 21:

  Which of the following tools can NOT be used to catalog a database?

  A. Control Center
  B. SQL Assist
  C. Configuration Assistant
  D. Command Line Processor
  B. SQL Assist

• Question 22:

  Given the following table:

  CURRENT_EMPLOYEES

  EMPID INTEGER NOT NULL

  NAME CHAR(20)

  SALARY DECIMAL(10,2)

  PAST_EMPLOYEES

  EMPID INTEGER NOT NULL

  NAME CHAR(20)

  SALARY DECIMAL(10,2)

  Assuming both tables contain data, which of the following statements will NOT successfully add data to table CURRENT_EMPLOYEES?

  A. INSERT INTOcurrent_employees (empid) VALUES (10)
  B. INSERT INTOcurrent_employees VALUES (10, 'JAGGER', 85000.00)
  C. INSERT INTOcurrent_employees SELECT empid, name, salary FROM past_employees WHERE empid =
  D. INSERT INTOcurrent_employees (name, salary) VALUES (SELECT name, salary FROM past_employees WHERE empid = 20)
  D. INSERT INTOcurrent_employees (name, salary) VALUES (SELECT name, salary FROM past_employees WHERE empid = 20)

• Question 23:

  Which of the following statements is used to prevent user TOM from adding and deleting data in table TAB1?

  A. REVOKE ADD, DELETE FROM USER tom ON TABLE tab1
  B. REVOKE ADD, DELETE ON TABLE tab1 FROM USER tom
  C. REVOKE INSERT, DELETE FROM USER tom ON TABLE tab1
  D. REVOKE INSERT, DELETE ON TABLE tab1 FROM USER tom
  D. REVOKE INSERT, DELETE ON TABLE tab1 FROM USER tom

• Question 24:

  What is the lowest privilege and/or authority required to execute the following SQL statement?

  CREATE VIEW view1 AS SELECT * FROM table1 WHERE STATE = 'TX'

  A. DBADM authority
  B. SYSADM authority
  C. SELECT privilege on TABLE1
  D. REFERENCES privilege on TABLE1
  C. SELECT privilege on TABLE1

• Question 25:

  Given the following table definition:

  EMPLOYESS

  EMP ID INTEGER

  NAME CHAR(20)

  DEPT CHAR(10)

  SALARY DECIMAL (10, 2)

  COMMISSION DECIMAL (8, 2)

  Assuming the DEPT column contains the values 'ADMIN', 'PRODUCTION', and 'SALES', which of the following statements will produce a result data set in which all ADMIN department employees are grouped together, all PRODUCTION

  department employees are grouped together, and all SALES department employees are grouped together?

  A. SELECT name, dept FROM employees ORDER BY dept
  B. SELECT name, dept FROM employees GROUP BY dept
  C. SELECT name, dept FROM employees GROUP BY ROLLUP (dept)
  D. SELECT name, dept FROM employees GROUP BY CUBE (dept)
  A. SELECT name, dept FROM employees ORDER BY dept

• Question 26:

  A user needs to create a trigger that will update table T2 whenever a row is added to table T1. Assuming the user has all appropriate privileges for table T2, which privilege is required on table T1 to create the trigger?

  A. REFERENCES
  B. SELECT
  C. UPDATE
  D. ALTER
  D. ALTER

• Question 27:

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

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

• Question 28:

  Given that tables T1 and T2 contain the following rows:

  Table T1:

  C1 C2

  1 4

  1 3

  1 2

  Table T2:

  C1 C2

  1 1

  1 2

  1 3

  Which of the following queries will return only those rows that exist in both T1 and T2?

  A. SELECT * FROM t1 UNION SELECT * FROM t2
  B. SELECT * FROM t1 UNION DISTINCT SELECT * FROM t2
  C. SELECT * FROM t1 INTERSECT SELECT * FROM t2
  D. SELECT * FROM t1 WHERE (c1,c2)= (SELECT c1,c2 FROM t2)
  C. SELECT * FROM t1 INTERSECT SELECT * FROM t2

• Question 29:

  Which of the following DB2 data types can be used to store 1000 MB of single-byte character data?

  A. BLOB
  B. CLOB
  C. DBCLOB
  D. GRAPHIC
  B. CLOB

• Question 30:

  Which of the following tools can be used to automate table reorganization operations?

  A. Control Center
  B. Command Center
  C. Command Line Processor
  D. Task Center
  D. Task Center