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

The following statements:

CREATE TABLE t1 (col1 INT NOT NULL, PRIMARY KEY (col1));

CREATE TABLE t2 (col1 INT NOT NULL, col2 CHAR(1) NOT NULL, PRIMARY KEY (col1,

col2),

FOREIGN KEY (col1) REFERENCES t1 (col1)

ON DELETE CASCADE ON UPDATE RESTRICT);

CREATE TABLE t3 (col1 INT NOT NULL, col2 INT NOT NULL, PRIMARY KEY (col1,

col2),

FOREIGN KEY (col1) REFERENCES t1 (col1)

ON DELETE NO ACTION ON UPDATE RESTRICT); INSERT INTO t1 VALUES (1), (2);

INSERT INTO t2 VALUES (1,#39;a#39;), (1, #39;b#39;), (2,#39;c#39;); INSERT INTO t3 VALUES (1, 100), (2, 200), (2,300);

How many rows will be deleted by the following DELETE statement? DELETE FROM t1 WHERE col1 = 1;

  1. 4

  2. 3

  3. 1

  4. 0

Answer: D

Question No: 232

To which of the following resources can a lock be applied?

  1. Row

  2. Alias

  3. Bitmap

  4. Column

Answer: A

Question No: 233

Which of the following will allow user USER1 to change the comment associated with a table named TABLE1?

  1. GRANT UPDATE ON TABLE table1TO user1

  2. GRANT CONTROL ON TABLE table1 TO user1

  3. GRANT ALTER ON TABLE table1 TO user1

  4. GRANT REFERENCES ON TABLE table1 TO user1

Answer: C

Question No: 234

Which two of the following are optional and do not have to be specified when creating a table?

  1. Table name

  2. Column name

  3. Default constraint

  4. Column data type

  5. NOT NULL constraint

Answer: C,E

Question No: 235

Which two of the following allow you to perform administrative tasks against database objects?

  1. Control Center

  2. Journal

  3. Command Line Processor

  4. Task Center

  5. Health Center

Answer: A,C

Question No: 236

What is the maximum size that can be specified when creating an XML column in a DB2 table?

  1. No size is specified

  2. The buffer pool size

  3. The page sizefor the table space

  4. The extent size for the table space

Answer: A

Question No: 237

In which of the following situations should correlation names be used?

  1. A table referenced in the FROM clause has no indexedcolumn.

  2. The table referenced in the FROM clause has more than 200 columns.

  3. Two or more tables in the FROM clause have identical column names.

  4. The FROM clause contains two or more tables in the SELECT statement.

Answer: C

Question No: 238

Application A holds a lock on a row in table TAB1. If lock timeout is set to 20, what will happen when Application B attempts to acquire a compatible lock on the same row?

  1. Application B will acquire the lock it needs

  2. Application A will be rolled back if it still holds its lock after 20 seconds have elapsed

  3. Application B will be rolled back if Application A still holds its lock after 20 seconds have elapsed

  4. Both applications will be rolled back if Application A still holds its lock after 20 seconds have elapsed

Answer: A

Question No: 239

Which of the following DB2 data types CANNOT be used to create an identity column?

  1. SMALLINT

  2. INTEGER

  3. NUMERIC

  4. DOUBLE

Answer: D

Question No: 240

Assuming PUBLIC has been granted all privileges on table T1, which of the following statements wouldcontinue to permit any user to add rows to table T1, but not remove them?

  1. REVOKE DROP ON t1 FROM PUBLIC

  2. REVOKE UPDATE ON t1 FROM PUBLIC

  3. REVOKE DELETE ON t1 FROM PUBLIC

  4. REVOKE CONTROL ON t1 FROM PUBLIC

Answer: C

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