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

Which of the following events will NOT cause a trigger to be activated?

  1. A select operation

  2. An insert operation

  3. An update operation

  4. A delete operation

Answer: A

Question No: 102

An application hasacquired a Share lock on a row in a table and now wishes to update the row. Which of the following statements is true?

  1. The application must release the row-level Share lock it holds and acquire an Update lock on the row

  2. The application must releasethe row-level Share lock it holds and acquire an Update lock on the table

  3. The row-level Share lock will automatically be converted to a row-level Update lock

  4. The row-level Share lock will automatically be escalated to a table-level Update lock

Answer: C

Question No: 103

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

Given the requirements to store employee names, employee numbers, and when employees were hired, which of the following built-in data types CANNOT be used to store the day an employee was hired?

  1. Character Large Object

  2. Time

  3. Varying-Length Character String

  4. Timestamp

Answer: B

Question No: 105

Which of the following is the best statement to use to create a user-defined data type that can be used to store currency values?

  1. CREATE DISTINCT TYPE currency AS NUMERIC(7,2)

  2. CREATE DISTINCT TYPEcurrency AS SMALLINT

  3. CREATE DISTINCT TYPE currency AS BIGINT

  4. CREATE DISTINCT TYPE currency AS DOUBLE

Answer: A

Question No: 106

A sequence was created with the DDL statement shown below: CREATE SEQUENCE my_sequence CACHE 10 ORDER

The following statements are successfully executed in sequence through separate database connections:

CONNECTION1 – VALUES NEXT VALUE FOR my_sequence INTO :con1hvar CONNECTION2 – VALUES NEXT VALUE FOR my_sequence INTO :con2hvar CONNECTION1 – VALUES NEXT VALUE FOR my_sequence INTO :con1hvar

What is the current value of the :con1hvar host variable?

  1. 2

  2. 3

  3. 11

  4. 30

Answer: B

Question No: 107

Which of thefollowing supports the XML data type?

  1. A unique index

  2. A composite index

  3. A check constraint

  4. A generated column

Answer: A

Question No: 108

Which of the following DB2 products are required on an iSeries or System I server toenable an application running on that server to retrieve data from a DB2 database on a Linux server?

  1. DB2 for i5/OS

  2. DB2 Runtime Client

  3. DB2 Connect Enterprise Edition

  4. DB2 for i5/OS SQL Development Kit

Answer: A

Question No: 109

If thefollowing SQL statements are executed in the order shown:

CREATE TABLE orders (order_num INTEGER NOT NULL, buyer_name VARCHAR(35), amount NUMERIC(5,2));

CREATE UNIQUE INDEX idx_orderno ON orders (order_num); Which ofthe following describes the resulting behavior?

  1. Every ORDER_NUM value entered must be unique; whenever the ORDERS table is queried rows should be displayed in order of increasing ORDER_NUM values

  2. Every ORDER_NUM value entered must be unique; whenever the ORDERS table is queried rows will be displayed in no particular order

  3. Duplicate ORDER_NUM values are allowed; no other index can be created for the ORDERS table that reference the ORDER_NUM column

  4. Every ORDER_NUM value entered must be unique; no other index can be created for the ORDERS table that reference the ORDER_NUM column

Answer: A

Question No: 110

Application A is running under the Repeatable Read isolation level and holds an Update lock ontable TAB1. Application B wants to query table TAB1 and cannot wait for Application A to release its lock. Which isolation level should Application B run under to achieve this objective?

  1. Repeatable Read

  2. Read Stability

  3. Cursor Stability

  4. Uncommitted Read

Answer: D

100% Ensurepass Free Download!
Download Free Demo:C2090-730 Demo PDF
100% Ensurepass Free Guaranteed!
Download 2017 EnsurePass C2090-730 Full Exam PDF and VCE

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