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

Given the following ALTER SEQUENCE statement:

ALTER SEQUENCE myseq RESTART WITH 0INCREMENT BY 1 NO MAXVALUE CACHE 5 ORDER

Assuming that the sequence had reached a value of 100 prior to the RESTART, which of the following is true?

  1. The next value will be 0 and the sequence will never use the values 101 to 105.

  2. The next value willbe 101 to ensure uniqueness between existing and newly generated sequence values.

  3. Previously cached values are retained by DB2, and after the restart, will be used for values 101 to 105.

  4. The next value will be 0 and DB2 will not ensure uniqueness between existing and newly generated values.

Answer: D

Question No: 122

Given the following table definition:

EMPLOYEES

———– EMPID INTEGER NAME CHAR(20)

SALARY DECIMAL(10,2)

If the following SQL statement is executed:

CREATE UNIQUE INDEXempid_ui ON employees (empid) Which two of the following statements are true?

  1. Multiple null values are allowed in the EMPID column of the EMPLOYEES table.

  2. No null values are allowed in the EMPID column of the EMPLOYEES table.

  3. One (and only one)null value is allowed in the EMPID column of the EMPLOYEES table.

  4. No other unique indexes can be created on the EMPLOYEES table.

  5. Every value found in the EMPID column of the EMPLOYEES table will be different.

Answer: C,E

Question No: 123

Which of the following can be used to ensure that once a row has been inserted in table TABLEX, the column MAINID in that row cannot be updated?

  1. Define the column MAINID as NOT UPDATABLE.

  2. Define the column MAINID as a PRIMARY KEY.

  3. Define the column MAINID as a FOREIGN KEY.

  4. Define an UPDATE trigger on table TABLEX.

Answer: D

Question No: 124

60 Which of the following best describes how locks are used in DB2?

  1. To maintain control of updated rows forcommit processing

  2. To ensure only committed changes are altered by another application

  3. To allow two applications to update the same row of data simultaneously

  4. To prevent multiple applications from accessing the same data simultaneously

Answer: B

Question No: 125

Given the following insert statement:

INSERT INTO product ( pid, description ) VALUES ( #39;100-100-01#39;, XMLPARSE ( DOCUMENT

#39;lt;productxmlns=quot;http://posample.orgquot; pid=#39;#39;100-100-01#39;#39; gt; lt;descriptiongt; lt;namegt;Snow Shovel,

Basic 22inlt;/namegt; lt;detailsgt;Basic Snow Shovel, 22in wide, straight handle with D- Griplt;/detailsgt;

lt;pricegt;9.99lt;/pricegt; lt;weightgt;1 kglt;/weightgt; lt;/descriptiongt; lt;/productgt;#39; PRESERVE WHITESPACE ) );

Which of the following table definitions will support the insert statement above?

  1. CREATE TABLE product

    ( pid XML NOT NULL PRIMARY KEY, name VARCHAR(128),

    price DECIMAL(30,2),

    promoprice DECIMAL(30,2), promostart DATE, promoend DATE, description XML);

  2. CREATE TABLE product

    ( pid VARCHAR(10) NOT NULL PRIMARY KEY, name VARCHAR(128),

    price DECIMAL(30,2),

    promoprice DECIMAL(30,2), promostart DATE, promoend DATE, description XML);

  3. CREATE TABLE product

    ( pid XML NOT NULL PRIMARY KEY, nameVARCHAR(128),

    price DECIMAL(30,2),

    promoprice DECIMAL(30,2), promostart DATE, promoend DATE,

    description VARCHAR(1000));

  4. CREATE TABLE product

( pid VARCHAR(10) NOT NULL PRIMARY KEY, name VARCHAR(128),

price DECIMAL(30,2),

promoprice DECIMAL(30,2), promostart DATE, promoend DATE,

description VARCHAR(1000));

Answer: B

Question No: 126

What does the following statement do?

GRANT ALTER ON SEQUENCE gen_empid TO user1 WITH GRANT OPTION

  1. Gives USER1 the ability to change the comment associated with a sequence named GEN_EMPID, along with the ability to give this CONTROL authority for the sequence to other users and groups.

  2. Gives USER1 the ability to change the values returned by the PREVIOUS_VALUE and NEXT_VALUE expressions associated with a sequence named GEN_EMPID, along with the ability togive CONTROL authority for the sequence to other users and groups.

  3. Gives USER1 the ability to change the comment associated with a sequence named GEN_EMPID, along with the ability to give this authority to other users and groups.

  4. Gives USER1 the ability to change the values returned by the PREVIOUS_VALUE and NEXT_VALUE expressions associated with a sequence named GEN_EMPID, along with the ability to give this authority to other users and groups.

Answer: C

Question No: 127

If DB2 detects a deadlock between application A and application B (each waiting for a lock held by the other one), what action will DB2 take?

  1. Rollback the transaction in both applications.

  2. Rollback the transaction in one of the two applications.

  3. Decrease the lock timeout value for both applications, thereby causing a lock timeout situation.

  4. Send a message to let the administrator know of the situation and decide which application or applications should be terminated.

Answer: B

Question No: 128

Ifthe following SQL statements are executed:

CREATE TABLE make (makeid SMALLINT NOT NULL PRIMARY KEY, make VARCHAR(25));

CREATE TABLE model (modelid SMALLINT,

model VARCHAR(25),

makeid SMALLINT,

CONSTRAINT const1 FOREIGN KEY (makeid) REFERENCES make(makeid) ON DELETE RESTRICT);

And each table created is populated as follows: MAKE

MAKEID MAKE

— —-

  1. Ford

  2. Chevrolet

  3. Toyota MODEL

MODELID MODELMAKEID

—- —- —-

  1. Mustang 1

  2. Escort 1

  3. Malibu 2

  4. Camry 3

If the following SQL statement is executed: DELETE FROM make WHERE makeid = 1

What is the total number of rowsthat will be deleted?

  1. 0

  2. 1

  3. 2

  4. 3

Answer: A

Question No: 129

Given the following CREATE TABLE statement: CREATE TABLE table2 LIKE table1

Which two of the following will NOT occur when the statementis executed?

  1. TABLE2 will have the same column names and column data types as TABLE1

  2. TABLE2 will have the same column defaults as TABLE1

  3. TABLE2 will have the same nullability characteristics as TABLE1

  4. TABLE2 will have the same indexes as TABLE1.

  5. TABLE2 will have the same referential constraints as TABLE1

Answer: D,E

Question No: 130

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

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