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

A user utilizing an alias to update a subset of columns in a table must have UPDATE privileges on which of the following DB2 objects?

  1. Table

  2. Columns

  3. Table and Alias

  4. Columns and Alias

Answer: A

Question No: 92

Given the following DDL and INSERT statements:

CREATE VIEW v1 AS SELECT col1 FROM t1 WHERE col1 gt; 10;

CREATE VIEW v2 AS SELECT col1 FROM v1 WITH CASCADED CHECK OPTION; CREATE VIEW v3 AS SELECT col1 FROM v2 WHERE col1 lt; 100;

INSERT INTO v1 VALUES(5); INSERT INTO v2 VALUES(5); INSERT INTO v3 VALUES(20); INSERT INTO v3 VALUES(100);

How many of these INSERT statements will besuccessful?

  1. 0

  2. 1

  3. 2

  4. 3

Answer: C

Question No: 93

Which of the following tasks can NOT be performed using the Developer Workbench?

  1. Develop and debug an SQL stored procedure

  2. Develop and debug a user-defined data type

  3. Develop and debug a user-defined function

  4. Develop and run XML queries

Answer: B

Question No: 94

Which of the following DB2 products can only be installed on a System i server?

  1. DB2 for z/OS

  2. DB2 for i5/OS

  3. DB2 Data Warehouse Edition

  4. DB2 Enterprise Server Edition

Answer: B

Question No: 95

Which of the following actions may cause a trigger to be fired?

  1. DROP

  2. ALTER

  3. DELETE

  4. ROLLBACK

Answer: C

Question No: 96

Which of the following is a feature of a unit of work?

  1. It applies to a single data server.

  2. It is a recoverable sequence of operations.

  3. Its value can be queried from the system catalog tables.

  4. It begins when the application connects to the data server.

Answer: B

Question No: 97

On which of the following database objects may the SELECT privilege be controlled?

  1. Sequence

  2. Schema

  3. Group

  4. View

Answer: D

Question No: 98

Given the following statements:

CREATE TABLE table1 (col1 INTEGER,col2 CHAR(3)); CREATE VIEW view1 AS

SELECT col1, col2 FROM table1 WHERE col1 lt; 100

WITH LOCAL CHECK OPTION;

Which of the following INSERT statements will execute successfully?

  1. INSERT INTO view1 VALUES (50, abc)

  2. INSERT INTO view1 VALUES(100, abc)

  3. INSERT INTO view1 VALUES(50, #39;abc#39;)

  4. INSERT INTO view1 VALUES(100, #39;abc#39;)

Answer: C

Question No: 99

A programmer wants to generate values for a numeric ID column in their EXPENSE table. The ID column values need to be incremented by 1000 for each new expense report added to the EXPENSE table. Which DB2 object can be referenced by an INSERT statement to meet this requirement?

  1. Sequence

  2. Table Function

  3. Identity Column

  4. INSTEAD OF Trigger

Answer: A

Question No: 100

Assuming USER1 has no authorities or privileges, which of the following will allow USER1 to create a view named VIEW1 that references two tables named TAB1 and TAB2?

  1. CREATEIN privilege on the database

  2. REFERENCES privilege on TAB1 and TAB2

  3. CREATE_TAB privilege on the database

  4. SELECT privilege on TAB1 and TAB2

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