EnsurePass
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: 211

Which two ofthe 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: 212

Which of the following is a valid DB2 data type?

  1. NUMBER

  2. INTERVAL

  3. BYTE

  4. NUM

Answer: D

Question No: 213

Which of the following is a characteristic of a schema?

  1. Foreign key references cannot cross schema boundaries.

  2. A DB2 user must be created before a schema with the same namecan be created.

  3. If no schema is specified when an object is created, the default schema PUBLIC is used.

  4. A schema enables the creation of multiple objects in a database without encountering namespace collisions.

Answer: D

Question No: 214

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

  1. Sequence

  2. Nickname

  3. Schema

  4. View

  5. Index

Answer: B,D

Question No: 215

The following triggers were defined for a table named SALES in the order shown:

CREATE TRIGGER trigger_a

NO CASCADE BEFORE UPDATE ON sales REFERENCING NEW AS new

FOR EACH ROW

SET new.commission = sale_amt * .05

WHERE invoice = n.invoice;

CREATETRIGGER trigger_b AFTER INSERT ON sales REFERENCING NEW AS new FOR EACH ROW

UPDATE sales SET bill_date = CURRENT DATE 30 DAYS WHERE invoice = n.invoice;

CREATE TRIGGER trigger_c

NO CASCADE BEFORE DELETE ON sales FOR EACH ROW

SIGNAL SQLSTATE #39;75005#39;

SET MESSAGE_TEXT = #39;Deletes not allowed!#39;; Which of the following statements is NOT true?

  1. Once a row has been added to the SALES table, it cannot be removed

  2. Whenever a row is inserted into the SALES table, the value in the BILL_DATE column isautomatically set to 30 days from today

  3. Each time a row is inserted into the SALES table, trigger TRIGGER_A is fired first, followed by trigger TRIGGER_B

  4. Whenever a row in the SALES table is updated, all three triggers are fired but nothing happens because none of the triggers have been coded to trap update operations

Answer: D

Question No: 216

Given the following statements:

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

CREATE VIEW view1 AS SELECT c1, c2 FROM tab1 WHERE c1 lt; 100; CREATE VIEW view2 AS SELECT c1, c2 FROM view1

WITH CASCADED CHECK OPTION;

Which of the following INSERT statements will fail to execute?

  1. INSERT INTO view2 VALUES(50, #39;abc#39;)

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

  3. INSERT INTO view2 VALUES(150, #39;abc#39;)

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

Answer: C

Question No: 217

Which of the following best describes the lock protection provided by DB2for the current row of a cursor?

  1. The cursor is only protected from updates and deletes by concurrent applications.

  2. The row is only protected from positioned updates and deletes that reference another cursor of the same application.

  3. The cursor isprotected from positioned updates and deletes that reference another cursor of a different application.

  4. The row is protected from updates and deletes by the current application and from positioned updates and deletes that reference another cursor of thesame application

Answer: A

Question No: 218

Which of the following is NOT a difference between a unique index and a primary key?

  1. A primary key is a special form of a uniqueconstraint; both use a unique index.

  2. Unique indexes can be defined over one or more columns; primary keys can only be defined on a single column.

  3. A table can have many unique indexes but only one primary key.

  4. Unique indexes can be defined over one or more columns that allow null values; primary keys cannot contain null values.

Answer: B

Question No: 219

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

  1. Table spaces

  2. Buffer pools

  3. Tables

  4. Rows

Answer: B

Question No: 220

Given the following queries:

SELECT c1 FROM tab1; SELECT c1 FROM tab2;

Which of the following set operators can be usedto produce a result data set that contains only records that are not found in the result data set produced by each query after duplicate rows have been eliminated?

  1. UNION

  2. INTERSECT

  3. EXCEPT

  4. MERGE

Answer: D

100% Free Download!
Download Free Demo:C2090-730 Demo PDF
100% Pass 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