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

Which of the following is true of an index used to support a UNIQUEconstraint?

  1. It must have the UNIQUE attribute.

  2. It cannot be created explicitly by the user.

  3. It must have the UNIQUE and CLUSTER attributes.

  4. It must have the UNIQUE WHERE NOT NULL attribute.

Answer: A

Question No: 112

How does DB2 protect the integrity of indexes when data is updated?

  1. Locks are acquired on the data.

  2. Locks are acquired on index keys.

  3. Locks are acquired on indexpages.

  4. Locks are acquired on index pointers.

Answer: A

Question No: 113

A number of applications issuethe following SQL statement:

SELECT d.deptno, e.empno, e.salary FROM department d INNER JOIN employee e ON d.deptno = e.deptno

A database administrator wishes to store this query within the database. Which of the following database objects can be used to accomplish this?

  1. Alias

  2. View

  3. Schema

  4. Trigger

Answer: B

Question No: 114

What does the following statement do?

GRANT REFERENCES (col1, col2) ON TABLE table1 TO user1 WITH GRANT OPTION

  1. Gives user USER1 the ability to refer to COL1 and COL2 of table TABLE1 in queries, along with the ability to give this authority to other users and groups.

  2. Gives user USER1 the ability to refer to COL1 and COL2 of table TABLE1 in views, along with the ability to give this authority to other users and groups.

  3. Gives user USER1 theability to define a referential constraint on table TABLE1 using columns COL1 and COL2 as the parent key of the constraint.

  4. Gives user USER1 the ability to define a referential constraint on table TABLE1 using columns COL1 and COL2 as the foreign key of the constraint.

Answer: C

Question No: 115

Which of the following is NOT true about XML columns?

  1. Data can be retrieved by SQL.

  2. Data can be retrieved by XQuery.

  3. XML columns must be altered to accommodate additional parent and child relationships.

  4. Access to any portion of an XML document can be direct, without reading the whole document.

Answer: C

Question No: 116

A user needs to create a trigger that will update table T2 whenever a row is added to table

T1. Assuming the user has all appropriate privileges for table T2, which privilege is required on table T1 to create thetrigger?

  1. REFERENCES

  2. SELECT

  3. UPDATE

  4. ALTER

Answer: D

Question No: 117

Which of the following CREATE TABLE statements will NOT be successful?

  1. CREATE TABLE t1 (c1 XML NOT NULL UNIQUE, c2 INT)

  2. CREATE TABLE t1(c1 XML NOT NULL, c2 CHAR(20))

  3. CREATE TABLE t1 (c1 XML CHECK (c1 IS VALIDATED), c2 INT)

  4. CREATE TABLE t1 (c1 XML, c2 XML)

Answer: A

Question No: 118

Given the following statements:

CREATE TABLE t1 (c1 INTEGER, c2 CHAR(5));

CREATE TABLE t1audit (user VARCHAR(20), date DATE, action VARCHAR(20));

CREATE TRIGGER trig1 AFTER INSERT ON t1 FOR EACH ROW

MODE DB2SQL

INSERT INTO t1audit VALUES (CURRENT USER,CURRENT DATE,

#39;Insert#39;);

If user USER1 executes the following statements: INSERT INTO t1 VALUES (1, #39;abc#39;);

INSERT INTO t1 (c1) VALUES (2); UPDATE t1 SET c2 = #39;ghi#39; WHERE c1 = 1;

How many new records will be written to the database?

  1. 0

  2. 2

  3. 3

  4. 4

Answer: D

Question No: 119

Which of the following DB2 objects can be referenced by an INSERT statement to generate values for a column?

  1. Sequence

  2. Identity column

  3. Trigger

  4. Table function

Answer: A

Question No: 120

Given the following two tables: TAB1

C1 C2

Ensurepass 2017 PDF and VCE

  1. Antarctica

  2. Africa

  3. Asia

  4. Australia TAB2

    CX CY

    Ensurepass 2017 PDF and VCE

  5. Europe

  6. North America

  7. South America

Which of the following SQL statements will insert all rows found in table TAB2 into table TAB1?

  1. INSERT INTO tab1 SELECT cx, cy FROM tab2

  2. INSERT INTO tab1 VALUES (tab2.cx, tab2.cy)

  3. INSERT INTO tab1 VALUES (SELECT cx,cy FROM tab2)

  4. INSERT INTO tab1 (c1, c2) VALUES (SELECT cx, cy FROM tab2)

Answer: A

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