IBM C2090-730 Online Practice Questions and Exam Preparation

IBM C2090-730 Online Questions & Answers

• Question 41:

  Given the following function:

  CREATE FUNCTION emplist () RETURNS TABLE ( id CHAR(6) , firstname VARCHAR(12) , lastname VARCHAR(15) ) LANGUAGE SQL BEGIN ATOMIC RETURN SELECT EMPNO, FIRSTNME, LASTNAME FROM EMPLOYEE WHERE WORKDEPT IN ('A00', 'B00'); END

  How can this function be used in an SQL statement?

  A. SELECTTABLE(EMPLIST()) FROM EMPLOYEE
  B. SELECTTABLE(EMPLIST()) AS t FROM EMPLOYEE
  C. SELECTEMPLIST(id, firstname, lastname) FROM EMPLOYEE
  D. SELECT id,firstname, lastname FROM TABLE(EMPLIST()) AS t
  D. SELECT id,firstname, lastname FROM TABLE(EMPLIST()) AS t

• Question 42:

  Application A holds an Update lock on a single row and application B is trying to read that row. If both applications are using isolation level UR, which of the following will occur?

  A. Application B will read the row.
  B. Applications A and B will cause a deadlock situation.
  C. Application B will wait until applicationA releases the Update lock.
  D. Application A will be terminated so that application B can read the row.
  A. Application B will read the row.

• Question 43:

  Which of the following statements allows user USER1 to take the ability to create packages in a database named SAMPLE away from user USER2?

  A. REVOKE CONNECT ON DATABASE FROM user2
  B. REVOKE CREATETAB ON DATABASE FROM user2
  C. REVOKE BIND ON DATABASE FROM user2
  D. REVOKE BINDADD ON DATABASE FROM user2
  D. REVOKE BINDADD ON DATABASE FROM user2

• Question 44:

  Which of the following events will NOT cause a trigger to be activated?

  A. A select operation
  B. An insert operation
  C. An update operation
  D. A delete operation
  A. A select operation

• Question 45:

  Which authority or privilege is granted by the DB2 Database Manager configuration file?

  A. CONNECT
  B. CONTROL
  C. SYSMAINT
  D. EXECUTE
  C. SYSMAINT

• Question 46:

  Which of the following supports the XML data type?

  A. A unique index
  B. A composite index
  C. A check constraint
  D. A generated column
  A. A unique index

• Question 47:

  Given the following query:

  SELECT last_name, first_name, age, hire_date FROM employee WHERE age > 40

  Which of the following clauses must be added to return the rows sorted by AGE, oldest first, and by LAST_NAME, from A to Z?

  A. SORT BY age ASC,last_name
  B. SORT BY age DESC,last_name
  C. ORDER BY age DESC,last_name
  D. ORDER BY age ASC,last_name
  C. ORDER BY age DESC,last_name

• Question 48:

  CREATE TABLE customer (cid BIGINT NOT NULL PRIMARY KEY, info XML)

  

  How many names will be returned for this XQuery?

  B. 1
  C. 2
  D. 3
  C. 2

• Question 49:

  Given the following two tables: TAB1 C1 C2

  A 11 B 12 C 13 TAB2 CX CY

  A 21 C 22 D 23

  The following results are desired:

  C1 C2 CX CY

  A 11 A 21 C 13 C 22 -- -- D 23

  Which of the following queries will yield the desired results?

  A. SELECT * FROM tab1 INNER JOIN tab2 ON c1=cx
  B. SELECT * FROM tab1 LEFT OUTER JOIN tab2 ON c1=cx
  C. SELECT * FROM tab1 FULL OUTER JOIN tab2 ON c1=cx
  D. SELECT * FROM tab1 RIGHT OUTER JOIN tab2 ON c1=cx
  D. SELECT * FROM tab1 RIGHT OUTER JOIN tab2 ON c1=cx

• Question 50:

  User USER1 wants to utilize an alias to remove rows from a table. Assuming USER1 has no authorities or privileges, which of the following privileges are needed?

  A. DELETE privilege on the table
  B. DELETE privilege on the alias
  C. DELETE privilege on the alias; REFERENCES privilege on the table
  D. REFERENCES privilege on the alias; DELETE privilege on the table
  A. DELETE privilege on the table