Ensurepass.com : Ensure you pass the IT Exams
2017 Nov IBM Official New Released C2090-730
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/C2090-730.html

DB2 9 Family Fundamentals

Question No: 51

Given the following table:

CURRENT_EMPLOYEES

——————- EMPIDINTEGER NOT NULL NAME CHAR(20)

SALARY DECIMAL(10,2) PAST_EMPLOYEES

——————- EMPID INTEGER NOT NULL NAME CHAR(20)

SALARY DECIMAL(10,2)

Assuming both tables contain data, which of the following statements will NOT successfullyadd data to table CURRENT_EMPLOYEES?

  1. INSERT INTO current_employees (empid) VALUES (10)

  2. INSERT INTO current_employees VALUES (10, ‘JAGGER’, 85000.00)

  3. INSERT INTO current_employees SELECT empid, name, salary FROM past_employees WHERE empid = 20

  4. INSERT INTO current_employees (name, salary) VALUES (SELECT name, salary FROM past_employees WHERE empid = 20)

Answer: D

Question No: 52

Which type of key is defined on the child table to implement a referential constraint?

  1. Unique key

  2. Primary key

  3. Foreign key

  4. Composite key

Answer: B

Question No: 53

Which of the following tools can be used to automate table reorganization operations?

  1. Control Center

  2. Command Center

  3. Command Line Processor

  4. Task Center

Answer: D

Question No: 54

A user wishing to invoke an SQL stored procedure thatqueries a table must have which of the following privileges?

  1. CALL privilege on the procedure; SELECT privilege on the table

  2. CALL privilege on the procedure; REFERENCES privilege on the table

  3. EXECUTE privilege on the procedure; SELECT privilege onthe table

  4. EXECUTE privilege on the procedure; REFERENCES privilege on the table

Answer: C

Question No: 55

Given the following table definition:

SALES

————-

SALES_DATE DATE SALES_PERSON CHAR(20) REGION CHAR(20)

SALES INTEGER

Which of the following SQL statements will remove all rows that had a SALES_DATE in the year 1995?

  1. DELETE * FROM sales WHEREYEAR(sales_date) = 1995

  2. DELETE FROM sales WHERE YEAR(sales_date) = 1995

  3. DROP * FROM sales WHERE YEAR(sales_date) = 1995

  4. DROP FROM sales WHERE YEAR(sales_date) = 1995

Answer: B

Question No: 56

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

  1. View

  2. Catalog Table

  3. Stored Procedure

  4. Global Temporary Table

Answer: A

Question No: 57

Given the following statement:

SELECT hyear, AVG(salary)

FROM (SELECT YEAR(hiredate) AS hyear, salary FROM employee WHERE salary gt; 30000)

GROUP BY hyear

Which of the following describes the result if thisstatement is executed?

  1. The statement will return the year and average salary for all employees that have a salary greater than $30,000, sorted by year.

  2. The statement will return the year and average salary for all employees hired within a given yearthat have a salary greater than $30,000.

  3. The statement will return the year and average salary for all years that every employee hired had a salary greater than $30,000.

  4. The statement will return the year and average salary for all years that any employee had a salary greater than $30,000.

Answer: B

Question No: 58

Given the followingtwo tables:

NAMES

————— NAME NUMBER

—– —-

Wayne Gretzky 99

Jaromir Jagr 68

Bobby Orr 4

Bobby Hull 23

Mario Lemieux 66

POINTS

————— NAME POINTS

—– —

Wayne Gretzky 244

Bobby Orr 129

Brett Hull 121

Mario Lemieux 189

Joe Sakic 94

How many rows would be returned using the following statement? SELECT name FROM names, points

  1. 0

  2. 5

  3. 10

  4. 25

Answer: D

Question No: 59

Which of the following best describes the lock protection provided by DB2 for the current row of a cursor?

  1. The cursor is only protected from updates and deletes by concurrent applications.

  2. Therow is only protected from positioned updates and deletes that reference another cursor of the same application.

  3. The cursor is protected from positioned updates and deletes that reference another cursor of a different application.

  4. The row is protected from updates and deletes by the current application and from positioned updates and deletes that reference another cursor of the same application.

Answer: A

Question No: 60

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?

  1. DELETE ALL FROM tab01 FOR CURRENT OF csr01

  2. DELETE FROM tab01 FOR CURRENT csr01 WITH RS

  3. DELETE * FROM tab01 WHERE CURRENT csr01 WITH CS

  4. DELETE FROM tab01 WHERE CURRENT OF csr01 WITH RR

Answer: D

100% Ensurepass Free Download!
Download Free Demo:C2090-730 Demo PDF
100% Ensurepass Free Guaranteed!
Download 2017 EnsurePass C2090-730 Dumps

EnsurePass ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

2017 EnsurePass IT Certification PDF and VCE