IBM C2090-320 Online Practice Questions and Exam Preparation

IBM C2090-320 Online Questions & Answers

• Question 61:

  In which address space would a native SQL stored procedure run?

  A. WLM
  B. DIST
  C. DBM1
  D. The address space of the calling program
  C. DBM1

• Question 62:

  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 63:

  Which two of the following functions are synonyms of one another? (Choose two.)

  A. CLOB
  B. VALUE
  C. IFNULL
  D. DBCLOB
  E. COALESCE
  B. VALUE
  E. COALESCE

• Question 64:

  Which of the following table space types does NOT support the use of REORG TABLESPACE SHRLEVEL(NONE)?

  A. LOB
  B. Simple
  C. Partition-by-range
  D. Partition-by-growth
  C. Partition-by-range

• Question 65:

  In the parent table of a referential constraint, a parent key must be which of the following? (Choose two.)

  A. A unique key
  B. A foreign key
  C. A primary key
  D. A duplicate key
  E. A secondary key
  A. A unique key
  C. A primary key

• Question 66:

  When you add an XML column to a table by using an ALTER TABLE statement, which of the following are TRUE? (Choose two.)

  A. DB2 implicitly creates an XML table space
  B. DB2 implicitly creates an AUX table to store the XML data
  C. If this is the first XML column you created for the table, DB2 implicitly creates a unique index on the XML column
  D. If this is the first XML column you created for the table, DB2 implicitly creates a ROWID column on the base table
  E. If this is the first XML column you created for the table, DB2 implicitly creates a BIGINT node ID column on the base table
  A. DB2 implicitly creates an XML table space
  E. If this is the first XML column you created for the table, DB2 implicitly creates a BIGINT node ID column on the base table

• Question 67:

  Select the SQL statement which will list the employee(empno) and the project numbers(projno) from the EMPACT table that has an employee(empno) whose salary(salary) is in the top three salaries for all employees from the EMP table.

  A. SELECT empno, projno FROM empact ep WHERE ep.empno IN (SELECT em.empno FROM emp em ORDER BY salary DESC) FETCH FIRST 3 ROWS ONLY;
  B. SELECT empno, projno FROM empact WHERE empno IN (SELECT empno FROM emp FETCH FIRST 3 ROWS ONLY);
  C. SELECT ep.empno, projno FROM empact ep WHERE ep.empno IN (SELECT em.empno FROM emp em ORDER BY salary FETCH FIRST 3 ROWS ONLY);
  D. SELECT ep.empno, projno FROM empact ep WHERE ep.empno IN (SELECT em.empno FROM emp em ORDER BY salary DESC FETCH FIRST 3 ROWS ONLY);
  A. SELECT empno, projno FROM empact ep WHERE ep.empno IN (SELECT em.empno FROM emp em ORDER BY salary DESC) FETCH FIRST 3 ROWS ONLY;

• Question 68:

  Consider the following scenario:

  User1 creates table USER1.TABLE1 in DATABASE1 User1 grants ALL PRIVILEGES on TABLE1 to User2 User2 grants ALL PRIVILEGES on TABLE1 to User3 User1 revokes ALL PRIVILEGES on TABLE1 to User2 User3 has DBCTRL authority on DATABASE1

  Is User3 able to retrieve rows from TABLE1?

  A. No
  B. Yes
  C. No, if the revoke used INCLUDING DEPENDENT PRIVILEGES
  D. Yes, if User3 was granted DBCTRL prior to the creation of table USER1.TABLE1
  B. Yes

• Question 69:

  What is the result XQuery FLWOR expression when running the following scenario?

  

  A. Joe Smith
  B. Joe Smith
  C. Joe Smith
  D. Joe Smith DB2
  A. Joe Smith

• Question 70:

  An external stored procedure is invoked using a CALL :hv (host variable). Which special register identifies the location of the procedure?

  A. CURRENT PATH
  B. CURRENT SCHEMA
  C. CURRENT PACKAGESET
  D. CURRENT ROUTINE VERSION
  A. CURRENT PATH