IBM C2090-730 Online Practice Questions and Exam Preparation

IBM C2090-730 Online Questions & Answers

• Question 211:

  An application needs a table for each connection that tracks the ID and Name of all items previously ordered and committed within the connection. The table also needs to be cleaned up and automatically removed each time a connection is ended. Assuming the ITEMS table was created with the following SQL statement:

  CREATE TABLE items item_no INT, item_name CHAR(5), item_qty INT)

  Which of the following SQL statements will provide the table definition that meets the specified requirements?

  A. DECLARE GLOBAL TEMPORARY TABLE tracker AS (SELECT item_no, item_name FROM items) WITH NO DATA ON COMMIT PRESERVE ROWS ON DISCONNECT DROP TABLE
  B. DECLARE GLOBAL TEMPORARY TABLE tracker AS (SELECT item_no, item_name FROM items) WITH NO DATA ON COMMIT PRESERVE ROWS
  C. CREATE TABLEsystmp.tracker AS (SELECT item_num, item_name FROM items) WITH NO DATA ON COMMIT PRESERVE ROWS
  D. CREATE TABLE tracker AS (SELECT item_num, item_name FROM items) ON COMMIT PRESERVE ROWS ON DISCONNECT DROP TABLE
  B. DECLARE GLOBAL TEMPORARY TABLE tracker AS (SELECT item_no, item_name FROM items) WITH NO DATA ON COMMIT PRESERVE ROWS

• Question 212:

  Which of the following products is allowed to access other DB2 servers, but cannot accept requests from other remote clients?

  A. DB2 Personal Edition
  B. DB2 Workgroup Server Edition
  C. DB2Enterprise Server Edition
  D. DB2 Data Warehouse Edition
  A. DB2 Personal Edition

• Question 213:

  Which of the following best describes a unit of work?

  A. It is a recoverable sequence of operations whose point of consistency is established when a connection to a database has been established or when a mechanism known as asavepoint is created.
  B. It is a recoverable sequence of operations whose current point of consistency can be determined by querying the system catalog tables.
  C. It is a recoverable sequence of operations whose point of consistency is established when an executable SQL statement is processed after a connection to a database has been established or a previous transaction has been terminated.
  D. It is a recoverable sequence of operations whose point of consistency is only established if a mechanism known as asavepoint is created.
  C. It is a recoverable sequence of operations whose point of consistency is established when an executable SQL statement is processed after a connection to a database has been established or a previous transaction has been terminated.

• Question 214:

  Which of the following is used to indicate a column will not accept NULL values and can be referenced in another table's foreign key specification?

  A. Check constraint
  B. Unique constraint
  C. Default constraint
  D. Informational constraint
  B. Unique constraint

• Question 215:

  Which of the following is a typical data warehouse query?

  A. What is this customer's address?
  B. Does this customer have any unpaid bills?
  C. What is the balance in this customers account?
  D. What are the total sales for each of the last 6 months?
  D. What are the total sales for each of the last 6 months?

• Question 216:

  Which of the following is the best statement to use to create a user-defined data type that can be used to store currency values?

  A. CREATE DISTINCT TYPE currency ASNUMERIC(7,2)
  B. CREATE DISTINCT TYPE currency AS SMALLINT
  C. CREATE DISTINCT TYPE currency AS BIGINT
  D. CREATE DISTINCT TYPE currency AS DOUBLE
  A. CREATE DISTINCT TYPE currency ASNUMERIC(7,2)

• Question 217:

  Consider the following table called EMPLOYEES:

  ID FIRSTNAME LASTNAME JOB LEVEL ------------------------------------------------------------ 1 Paul Jones DBA 2 2 George Baker MGR 1 3 Roger Melvin CLERK 3 4 Jim Smith MGR 1 5 Kevin Street CLERK 3 6 Chris Eaton MGR 1

  If the following SQL statement is executed, how many rows will be deleted? DELETE FROM employees WHERE 1 = 1

  B. 1
  C. 3
  D. 6
  D. 6

• Question 218:

  Which of the following is a valid wildcard character in a LIKE clause of a SELECT statement?

  A. %
  B. *
  C. ?
  D. \
  A. %

• Question 219:

  Which of the following is a feature of a unit of work?

  A. It applies to a single data server.
  B. It is a recoverable sequence of operations.
  C. Its value can be queried from the system catalog tables.
  D. It begins when the application connects to the data server.
  B. It is a recoverable sequence of operations.

• Question 220:

  Which of the following DB2 products can only be installed on a System i server?

  A. DB2 for z/OS
  B. DB2 for i5/OS
  C. DB2 Data Warehouse Edition
  D. DB2Enterprise Server Edition
  B. DB2 for i5/OS