IBM C2090-730 Online Practice Questions and Exam Preparation

IBM C2090-730 Online Questions & Answers

• Question 261:

  The opening of cursor CSR01 produces the following result set:

  STUDENT LASTNM FIRSTNM CLASSNO 123 Brown John T100 213 Bailey James T100 312 Carter Arlene T210 465 Chas Devon T305 546 Davis Steven T405

  If this Fetch statement is executed:

  FETCH csr01 INTO :studnum, :firstname, :lastname, :class

  Which of the following DELETE statements will cause this row to be deleted?

  A. DELETE ALL FROM tab01 FOR CURRENT OF csr01
  B. DELETE FROM tab01 FOR CURRENT csr01 WITH RS
  C. DELETE * FROM tab01 WHERE CURRENT csr01 WITH CS
  D. DELETE FROM tab01 WHERE CURRENT OF csr01 WITH RR
  D. DELETE FROM tab01 WHERE CURRENT OF csr01 WITH RR

• Question 262:

  A trigger can be created on which of the following objects?

  A. View
  B. Catalog Table
  C. Stored Procedure
  D. Global Temporary Table
  A. View

• Question 263:

  Given the following expression:

  SELECT QUANTITY,

  CASE WHEN ITEMCODE = '099' THEN "SILVER"

  WHEN ITEMCODE = '788' THEN "GOLD"

  WHEN ITEMCODE = '899' THEN "PLATINUM"

  ELSE ERROR

  END

  FROM SUPPLIER

  What will be the result of the query if the following data is evaluated by the CASE expression?

  QUANTITY ITEMCODE

  3 099

  4 099

  1 788

  1 899

  5 009

  3 788

  1 899

  A. 3, SILVER 4, GOLD 1, SILVER 1, GOLD 5, PLATINUM 3, SILVER 1, GOLD
  B. 3, SILVER 4, SILVER 1, GOLD 1, PLATINUM 5, ERROR 3, GOLD 1, PLATINUM
  C. C. C. 3, SILVER 4, SILVER 1, PLATINUM 1, ERROR 5, SILVER 3, GOLD 1, PLATINUM
  D. 3, SILVER 4, SILVER 1, GOLD 1, GOLD 5, SILVER 1, PLATINUM
  B. 3, SILVER 4, SILVER 1, GOLD 1, PLATINUM 5, ERROR 3, GOLD 1, PLATINUM

• Question 264:

  Application A issues the following SQL statements within a single transaction using the Uncommitted Read isolation level:

  SELECT * FROM department WHERE deptno = 'A00';

  UPDATE department SET mgrno = '000100' WHERE deptno = 'A00';

  As long as the transaction is not committed, which of the following statements is FALSE?

  A. Other applications not running under the Uncommitted Read isolation level are prohibited from reading the updated row
  B. Application A is allowed to read data stored in another table, even if an Exclusive lock is held on that table
  C. Other applications running under the Uncommitted Read isolation level are allowed to read the updated row
  D. Application A is not allowed to insert new rows into the DEPARTMENT table as long as the current transaction remains active
  D. Application A is not allowed to insert new rows into the DEPARTMENT table as long as the current transaction remains active

• Question 265:

  Given the following CREATE TABLE statement:

  CREATE TABLE table2 LIKE table1

  Which two of the following will NOT occur when the statement is executed?

  A. TABLE2 will have the same column names and column data types as TABLE1
  B. TABLE2 will have the same column defaults as TABLE1
  C. TABLE2 will have the samenullability characteristics as TABLE1
  D. TABLE2 will have the same indexes as TABLE1. E. TABLE2 will have the same referential constraints as TABLE1
  D. TABLE2 will have the same indexes as TABLE1. E. TABLE2 will have the same referential constraints as TABLE1

• Question 266:

  Which of the following statements is used to revoke all DML privileges on table EMPLOYEE from user TOM?

  A. REVOKE ALL PRIVILEGES FROM USER tom
  B. REVOKE ALL ON EMPLOYEE FROM USER tom
  C. REVOKE EXECUTE ON EMPLOYEE FROM USER tom
  D. REVOKE PRIVILEGES ON EMPLOYEE FROM USER tom
  B. REVOKE ALL ON EMPLOYEE FROM USER tom

• Question 267:

  Which of the following will begin a new unit of work?

  A. The CONNECT statement
  B. The first FETCH of a cursor
  C. The BEGIN TRANSACTION statement
  D. The first executable SQL statement
  D. The first executable SQL statement

• Question 268:

  An application needs to store a 5 MB JPEG image in a DB2 table.

  Which data type should be specified for the column that will be used for storing the image?

  A. GRAPHIC
  B. BINARY
  C. IMAGE
  D. BLOB
  D. BLOB

• Question 269:

  Given the following table definition:

  SALES

  INVOICE_NO CHAR(20) NOT NULL

  SALES_DATE DATE

  SALES_PERSON VARCHAR(25)

  REGION CHAR(20)

  SALES_AMT DECIMAL(9,2)

  Which of the following queries will return SALES information, sorted by SALES_PERSON, from A to Z, and SALES_DATE, from most recent to earliest?

  A. SELECTinvoice_no, sales_person, sales_date, sales_amt FROM sales SORT BY sales_person, sales_date DESC
  B. SELECTinvoice_no, sales_person, sales_date, sales_amt FROM sales SORT BY sales_person DESC, sales_date
  C. SELECTinvoice_no, sales_person, sales_date, sales_amt FROM sales ORDER BY sales_person, sales_date DESC
  D. SELECTinvoice_no, sales_person, sales_date, sales_amt FROM sales ORDER BY sales_person DESC, sales_date
  D. SELECTinvoice_no, sales_person, sales_date, sales_amt FROM sales ORDER BY sales_person DESC, sales_date

• Question 270:

  Given the following insert statement:

  INSERT INTO product ( pid, description ) VALUES ( '100-100-01', XMLPARSE ( DOCUMENT ' Snow Shovel, Basic 22in

  Basic Snow Shovel, 22in wide, straight handle with D-Grip
  9.99 1 kg ' PRESERVE WHITESPACE ) );

  Which of the following table definitions will support the insert statement above?

  A. CREATE TABLE product ( pid XML NOT NULL PRIMARY KEY, name VARCHAR(128), price DECIMAL(30,2), promoprice DECIMAL(30,2), promostart DATE, promoend DATE, description XML);
  B. CREATE TABLE product ( pid VARCHAR(10) NOT NULL PRIMARY KEY, name VARCHAR(128), price DECIMAL(30,2), promoprice DECIMAL(30,2), promostart DATE, promoend DATE, description XML);
  C. CREATE TABLE product ( pid XML NOT NULL PRIMARY KEY, name VARCHAR(128), price DECIMAL(30,2), promoprice DECIMAL(30,2), promostart DATE, promoend DATE, description VARCHAR(1000));
  D. CREATE TABLE product ( pid VARCHAR(10) NOT NULL PRIMARY KEY, name VARCHAR(128), price DECIMAL(30,2), promoprice DECIMAL(30,2), promostart DATE, promoend DATE, description VARCHAR(1000));
  B. CREATE TABLE product ( pid VARCHAR(10) NOT NULL PRIMARY KEY, name VARCHAR(128), price DECIMAL(30,2), promoprice DECIMAL(30,2), promostart DATE, promoend DATE, description XML);