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

What type of constraint is used to ensure that each row inserted into the EMPLOYEE table with a value in the WORKDEPT column has a row with a corresponding value in the DEPTNO column of the DEPARTMENT table?

  1. A check constraint on the EMPLOYEE table

  2. A unique constraint on the EMPLOYEE table WORKDEPT column

  3. A foreign key reference from the DEPARTMENT tables DEPTNO column to the WORKDEPT column of the EMPLOYEE table

  4. A foreign key reference from the EMPLOYEE tables WORKDEPT column to the DEPTNO column of the DEPARTMENT table

Answer: D

Question No: 42

Which of the following is TRUE for the DB2 isolation level Cursor Stability (CS)?

  1. An application process acquires at least a share lock on the current row of every cursor.

  2. Any row that is read during aunit of work cannot be changed by other application processes until the unit of work is complete.

  3. Any row changed by another application process can be read, even if the change has not been committed by that application process.

  4. An application process that issues the same query more than once in a unit of work will not see additional rows caused by other application processes appending new information to the database.

Answer: A

Question No: 43

If the following SQL statement is executed:

CREATE TABLE sales

(invoice_no NOT NULL PRIMARYKEY, sales_date DATE,

sales_amt NUMERIC(7,2)) IN tbsp0, tbsp1, tbsp2, tbsp3

PARTITION BY RANGE (sales_date NULLS FIRST) (STARTING ‘1/1/2007#39; ENDING #39;12/31/2007#39; EVERY 3 MONTHS)

Which of the following statements is true?

  1. Administrative tasks such as backing up, restoring, and reorganizing data stored in the SALES table must be done at the table level; not at the partition level

  2. Data can be quickly rolled in and out of the SALES table by using the ATTACH PARTITION and DETACH PARTITION clauses of the ALTER TABLE statement

  3. If an index is created for the SALES table, its data must be stored in table space TBSP0

  4. When resolving queries against the SALES table, each partition used is scanned asynchronously and the results of each partition scan are merged to produce the result data set returned

Answer: B

Question No: 44

Which of the following is a characteristic of a sequence?

  1. A sequence will never generate duplicate values.

  2. The MAXVALUE of a sequence can be equal to the MINVALUE.

  3. It is not possible to create a sequence that generates a constant since the INCREMENT value must be greater than zero.

  4. When a sequence cycles back to either the MAXVALUE or MINVALUE, it will always be equal to the specified value of either of these two boundaries.

Answer: B

Question No: 45

Given the following table definition:

EMPLOYESS

————- EMP ID INTEGER NAME CHAR(20) DEPT CHAR(10)

SALARY DECIMAL (10, 2)

COMMISSION DECIMAL (8, 2)

Assuming the DEPT column contains the values ‘ADMIN’, ‘PRODUCTION’, and ‘SALES’, which of the following statements will produce a result data set in which all ADMIN department employees are grouped together, all PRODUCTION department employees are grouped together, and all SALES department employees are grouped together?

  1. SELECT name, deptFROM employees ORDER BY dept

  2. SELECT name, dept FROM employees GROUP BY dept

  3. SELECT name, dept FROM employees GROUP BY ROLLUP (dept)

  4. SELECT name, dept FROM employees GROUP BY CUBE (dept)

Answer: A

Question No: 46

Which two of the following authorities allow a user to create a new database?

  1. SYSADMN

  2. SYSCTRL

  3. SYSMAINT

  4. DBADM

  5. CREATEDB

Answer: A,B

Question No: 47

Which of the following isolationlevels will lock all rows scanned to build a result data set?

  1. Uncommitted Read

  2. Cursor Stability

  3. Read Stability

  4. Repeatable Read

Answer: D

Question No: 48

Which two of the following statements are true about the HAVING clause?

  1. The HAVING clause is used in place of the WHERE clause.

  2. The HAVING clause uses the same syntax as theWHERE clause.

  3. The HAVING clause can only be used with the GROUP BY clause.

  4. The HAVING clause accepts wildcards.

  5. The HAVING clause uses the same syntax as the IN clause.

Answer: B,C

Question No: 49

If an application issues the same query more than once in the same Unit of Work, which isolation level will not permit this application to see additional rows inserted by other applications?

  1. Read Stability (RS)

  2. Repeatable Read (RR)

  3. Uncommitted Read (UR)

  4. Cursor Stability (CS)

Answer: B

Question No: 50

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

  1. REVOKE ALL PRIVILEGES FROM USER tom

  2. REVOKEALL ON EMPLOYEE FROM USER tom

  3. REVOKE EXECUTE ON EMPLOYEE FROM USER tom

  4. REVOKE PRIVILEGES ON EMPLOYEE FROM USER tom

Answer: B

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