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: 11

Given the following table:

STOCK

————- CATEGORY CHAR(1) PARTNO CHAR(12) DESCRIPTION VARCHAR(40) QUANTITY INTEGER

PRICE DEC(7,2)

If items are indicated to be out of stock by setting DESCRIPTION to NULL and QUANTITY and PRICE to zero, which of the following statements updates the STOCK table to indicate that all items except those with CATEGORY of ‘S’ are temporarily out of stock?

  1. UPDATE stock SET description = ‘NULL’, quantity = 0, price = 0 WHERE category ‘S’

  2. UPDATE stock SET description = NULL, SET quantity = 0, SET price = 0 WHERE category ‘S’

  3. UPDATE stock SET (description, quantity, price) = (‘null’, 0, 0) WHERE category ‘S’

  4. UPDATE stock SET (description, quantity, price) = (NULL, 0, 0) WHERE category ‘S’

Answer: D

Question No: 12

Which of the following is NOT a valid method of authentication that can be used by DB2 9?

  1. SERVER

  2. SERVER_ENCRYPT

  3. CLIENT

  4. DCS

Answer: D

Question No: 13

Which of the following products must be installed on an AIX server in order to build an application for AIX that will access a DB2 for z/OS database?

  1. DB2 Enterprise Server Edition

  2. DB2 Personal Developer#39;s Edition

  3. DB2 UniversalDeveloper#39;s Edition

  4. DB2 Universal Database Enterprise Edition and DB2 Connect Enterprise Edition

Answer: C

Question No: 14

Which of the following tools can be used to schedule a backup operation that is to be run every Sunday evening?

  1. Journal

  2. Task Center

  3. Activity Monitor

  4. Command Line Processor

Answer: B

Question No: 15

A stored procedure object is created into which DB2 object?

  1. Alias

  2. Schema

  3. Package

  4. Routine Space

Answer: B

Question No: 16

A DBA has been askedto create a table which will contain a substantial amount of detailed sales information for each calendar month and maintain it to contain only the last 12 months. Which of the following methods will facilitate the online removal of the oldest month#39;s data?

  1. Create an MQT that selects the oldest month of data with the REFRESH IMMEDIATE option.

  2. Create 12 separate tables, create a view based on all 12, drop the table with the oldest month#39;s data then drop and re-create the view.

  3. Create a range partitioned table, partitioned by month, and use the ALTER TABLE statement to detach the oldest month and attach storage for new data.

  4. Create a single table, extract the data to be retained using UNLOAD with a SELECT

statement, drop and re-create the table then load only the data to be retained.

Answer: C

Question No: 17

Which of the following resources can be referenced in the LOCK statement?

  1. Row

  2. Table

  3. Column

  4. Table space

Answer: B Explanation:

281

If application A issues the following SQL statement, which of the following statements about concurrency is true?

SELECT deptno, deptname, mgrno FROM dept WHERE admrdept = #39;A00#39; FOR READ ONLY WITH RS

  1. Rows accessed by application A can be seenby other applications.

  2. Rows accessed by application A cannot be seen by other applications.

  3. Application A can see uncommitted changes made by other applications.

  4. Results produced by re-execution of the statement by application A will not be affected by other applications.

Answer:B

Question No: 18

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

  1. Check constraint

  2. Unique constraint

  3. Default constraint

  4. Informational constraint

Answer: B

Question No: 19

A table contains a list of all seats available at a football stadium. A seat consists of a section number, a seat number, and whether or not the seat has been assigned. A ticket agent working at the box office generates a list of all unassigned seats. When the agent refreshes the list, it should only change if another agent assigns one or more unassigned seats. Which of the following is the best isolation level to use for this application?

  1. Repeatable Read

  2. Read Stability

  3. Cursor Stability

  4. Uncommitted Read

Answer: C

Question No: 20

Which of the following queries will correctly return the manager information sorted by the manager#39;s last name, department and project name?

  1. SELECT lastname, dept, projname, manager, startdate

    FROM (SELECT name, dept, proj ASprojname, manager, startdate FROM employee, project

    WHERE empno = empno) AS empproj ORDER BY name, dept, projname

  2. SELECT lastname, dept, projname, manager, startdate

    FROM (SELECT name AS lastname, dept, proj AS projname, manager, startdate FROM employee, project

    WHERE empno = mgrno) AS empproj

    SORT BY lastname, firstname, dept, projname

  3. SELECT lastname, dept, projname, manager, startdate

    FROM (SELECT name AS lastname, dept, proj AS projname, manager, startdate FROM employee, project

    WHERE empno = mgrno) AS empproj ORDER BY lastname ASC

    SORT BY dept, projname DESC

  4. SELECT lastname, dept, projname, manager, startdate

FROM (SELECT name AS lastname, dept, proj AS projname, manager, startdate FROM employee, project

WHERE empno = mgrno) AS empproj ORDER BYlastname, dept, projname

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