IBM C2090-320 Online Practice Questions and Exam Preparation

IBM C2090-320 Online Questions & Answers

• Question 1:

  Which SQL statement supports an insert or an update in a single SQL statement?

  A. MERGE
  B. UPSERT
  C. UPDATE or INSERT INTO ...
  D. INSERT INTO table ... ON DUPLICATE KEY ...
  A. MERGE

• Question 2:

  Which statement about an application-period temporal table is TRUE?

  A. It has SYSTEM_TIME defined
  B. It has an end column defined using WITH DEFAULT NULL
  C. It must have the index clause BUSINESS_TIME WITHOUT OVERLAPS
  D. It has a begin column defined as TIMESTAMP(6) NOT NULL or DATE NOT NULL
  D. It has a begin column defined as TIMESTAMP(6) NOT NULL or DATE NOT NULL

• Question 3:

  Which of the following statements will create an application-period temporal table?

  

  A. Option A
  B. Option B
  C. Option C
  D. Option D
  D. Option D

• Question 4:

  Which catalog table contains the information about definition changes for an object that have not yet been applied by the REORG utility?

  A. SYSIBM.SYSCHECKDEP
  B. SYSIBM.SYSPENDINGDDL
  C. SYSIBM.SYSDEPENDENCIES
  D. SYSIBM.SYSPENDINGOBJECTS
  B. SYSIBM.SYSPENDINGDDL

• Question 5:

  Which type of constraint is NOT enforced by DB2 during SQL processing?

  A. Check
  B. Referential
  C. Primary key
  D. Informational referential
  D. Informational referential

• Question 6:

  Which SQL statement will retrieve the department number (WORKDEPT) and the highest salary (SALARY) for each department in a table named EMPLOYEE and arrange the result set in ascending order by department?

  A. SELECT workdept, salary FROM employee GROUP BY workdept ORDER BY workdept;
  B. SELECT workdept, MAX(salary) FROM employee ORDER BY workdept GROUP BY 2;
  C. SELECT workdept, MAX(salary) FROM employee ORDER BY workdept;
  D. SELECT workdept, MAX(salary) FROM employee GROUP BY workdept ORDER BY 1;
  B. SELECT workdept, MAX(salary) FROM employee ORDER BY workdept GROUP BY 2;

• Question 7:

  Which of the following automatically maintains historical versions of data over several years?

  A. A partitioned-by-range table
  B. A partitioned-by-growth table
  C. A system-period temporal table
  D. An application-period temporal table
  C. A system-period temporal table

• Question 8:

  Given the following sequence of events:

  1) COL1 in SCHEMA.TABLE has a value of 10 2)Update COL1 in SCHEMA.TABLE to 20 3) Set SAVEPOINT A 4) Update COL1 in SCHEMA.TABLE to 30 5) Set SAVEPOINT B

  After issuing the statement: ROLLBACK TO SAVEPOINT

  What will be the value in COL1 of the SCHEMA.TABLE?

  A. 10
  B. 20
  C. 30
  D. An -880 SQLCODE will be issued when the statement is executed
  C. 30

• Question 9:

  When the following SQL statement is executed, user smith will NOT be able to do which of the following? REVOKE USE OF STOGROUP stogr1 FROM smith;

  A. CREATE TRIGGER ...;
  B. CREATE TABLE ... IN db1.ts1;
  C. CREATE DATABASE ... STOGROUP stogr1;
  D. CREATE TABLESPACE ... USING STOGROUP stogr1;
  D. CREATE TABLESPACE ... USING STOGROUP stogr1;

• Question 10:

  Which type of lock is obtained when using a `WITH UR' clause on an SQL SELECT statement in a data-sharing environment?

  A. U-lock
  B. S-lock
  C. P-lock
  D. No lock is obtained
  D. No lock is obtained