IBM C2090-730 Online Practice Questions and Exam Preparation

IBM C2090-730 Online Questions & Answers

• Question 31:

  Which of the following DB2 data types CANNOT be used to create an identity column?

  A. SMALLINT
  B. INTEGER
  C. NUMERIC
  D. DOUBLE
  D. DOUBLE

• Question 32:

  Given the following stored procedure:

  CREATE PROCEDURE increase_salary ( IN p_workdept CHAR(6), OUT p_sum DECIMAL(9,2) )

  SET p_sum = (SELECT SUM(salary) FROM employee WHERE workdept=p_workdept);

  How can this stored procedure be called from the Command Line Processor?

  A. CALLincrease_salary('A00')
  B. VALUESincrease_salary('A00')
  C. CALLincrease_salary('A00', ?)
  D. VALUESincrease_salary('A00', ?)
  A. CALLincrease_salary('A00')

• Question 33:

  Which of the following is the lowest cost DB2 product that can be legally installed on an HP-UX server?

  A. DB2 Express-C
  B. DB2 Express
  C. DB2 Personal Edition
  D. DB2Enterprise Server Edition
  D. DB2Enterprise Server Edition

• Question 34:

  Given the following table definition:

  SALES

  INVOICE_NO CHAR(20) NOT NULL SALES_DATE DATE SALES_PERSON CHAR(20) REGION CHAR(20) SALES INTEGER

  If the following SELECT statement is executed, which of the following describes the order of the rows in the result data set produced? SELECT * FROM sales

  A. The rows are sorted by INVOICE_NO in ascending order.
  B. The rows are sorted by INVOICE_NO in descending order.
  C. The rows are ordered based on when they were inserted into the table.
  D. The rows are not sorted in any particular order.
  D. The rows are not sorted in any particular order.

• Question 35:

  Which of the following is an accurate statement about packages?

  A. Packages provide a logical grouping of database objects.
  B. Packages contain control structures that are considered the bound form for SQL statements
  C. Packages describe the objects in a DB2 database and their relationship to each other
  D. Packages may be used during query optimization to improve the performance for a subset of SELECT queries
  B. Packages contain control structures that are considered the bound form for SQL statements

• Question 36:

  Which of the following statements allows USER1 to take away read access on the table ORG.TAB1 from USER2?

  A. REVOKE SELECT FROM user2 ON TABLE org.tab1
  B. REVOKE SELECT ON TABLE org.tab1 FROM user2
  C. REVOKE READ ACCESS FROM user2 ON TABLE org.tab1
  D. REVOKE READ ACCESS ON TABLE org.tab1 FROM user2
  B. REVOKE SELECT ON TABLE org.tab1 FROM user2

• Question 37:

  The following triggers were defined for a table named SALES in the order shown:

  CREATE TRIGGER trigger_a NO CASCADE BEFORE UPDATE ON sales REFERENCING NEW AS new FOR EACH ROW SET new.commission = sale_amt * .05 WHERE invoice = n.invoice;

  CREATE TRIGGER trigger_b AFTER INSERT ON sales REFERENCING NEW AS new FOR EACH ROW UPDATE sales SET bill_date = CURRENT DATE + 30 DAYS WHERE invoice = n.invoice;

  CREATE TRIGGER trigger_c NO CASCADE BEFORE DELETE ON sales FOR EACH ROW SIGNAL SQLSTATE '75005' SET MESSAGE_TEXT = 'Deletes not allowed!';

  Which of the following statements is NOT true?

  A. Once a row has been added to the SALES table, it cannot be removed
  B. Whenever a row is inserted into the SALES table, the value in the BILL_DATE column is automatically set to 30 days from today
  C. Each time a row is inserted into the SALES table, trigger TRIGGER_A is fired first, followed by trigger TRIGGER_B
  D. Whenever a row in the SALES table is updated, all three triggers are fired but nothing happens because none of the triggers have been coded to trap update operations
  D. Whenever a row in the SALES table is updated, all three triggers are fired but nothing happens because none of the triggers have been coded to trap update operations

• Question 38:

  Given the following two tables:

  NAMES

  NAME NUMBER

  Wayne Gretzky 99 Jaromir Jagr 68 Bobby Orr 4 Bobby Hull 23 Brett Hull 16 Mario Lemieux 66 Mark Messier 11

  POINTS

  NAME POINTS

  Wayne Gretzky 244 Jaromir Jagr 168 Bobby Orr 129 Brett Hull 121 Mario Lemieux 189 Joe Sakic 94

  Which of the following statements will display the player name, number, and points for all players that have scored points?

  A. SELECT p.name,n.number, p.points FROM names n INNER JOIN points p ON n.name = name
  B. SELECT p.name,n.number, p.points FROM names n LEFT OUTER JOIN points p ON n.name = p.name
  C. SELECT p.name,n.number, p.points FROM names n RIGHT OUTER JOIN points p ON n.name = p.name
  D. SELECT p.name,n.number, p.points FROM names n FULL OUTER JOIN points p ON n.name = p.name
  B. SELECT p.name,n.number, p.points FROM names n LEFT OUTER JOIN points p ON n.name = p.name

• Question 39:

  Application A holds an Exclusive lock on table TAB1 and needs to acquire an Exclusive lock on table TAB2.

  Application B holds an Exclusive lock on table TAB2 and needs to acquire an Stability isolation level, which of the following will occur?

  A. Applications A and B will cause a deadlock situation
  B. Application B will read the copy of table TAB1 that was loaded into memory when Application A first read it
  C. Application B will read the data in table TAB1 and see uncommitted changes made by Application A
  D. Application B will be placed in a lock-wait state until ApplicationA releases its lock
  A. Applications A and B will cause a deadlock situation

• Question 40:

  After the following SQL statement is executed:

  GRANT ALL PRIVILEGES ON TABLE employee TO USER user1

  Assuming user USER1 has no other authorities or privileges, which of the following actions is user USER1 allowed to perform?

  A. Drop an index on the EMPLOYEE table
  B. Grant all privileges on the EMPLOYEE table to other users
  C. Alter the table definition
  D. Drop the EMPLOYEE table
  C. Alter the table definition