Ensurepass
2017 May IBM Official New Released 000-730 Q&As
100% Free Download! 100% Pass Guaranteed!
http://www.ensurepass.com/000-730.html

DB2 9 Family Fundamentals

QUESTION 181

Which of the following strings can NOT be inserted into an XML column using XMLPARSE()?

 

A.

“<employee />”

B.

“<name>John Doe</name>”

C.

“<?xml version=’1.0′ encoding=’UTF-8′ ?>”

D.

“<p></p>”

Correct Answer: C

 

 

QUESTION 182

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

 

A.

Table name

B.

Column name

C.

Default constraint

D.

Column data type

E.

NOT NULL constraint

 

Correct Answer: CE

 

 

QUESTION 183

Which of the following can NOT be used to restrict specific values from being inserted into a column in a particular table?

 

A.

Index

B.

Check constraint

C.

Referential constraint

D.

Default constraint

 

Correct Answer: D

 

 

QUESTION 184

Given the following CREATE TABLE statement:

 

CREATE TABLE table2 LIKE table1

 

Which two of the following will NOT occur when the statement is executed?

 

A.

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

B.

TABLE2 will have the same column defaults as TABLE1

C.

TABLE2 will have the same nullability characteristics as TABLE1

D.

TABLE2 will have the same indexes as TABLE1.

E.

TABLE2 will have the same referential constraints as TABLE1

 

Correct Answer: DE

 

 

QUESTION 185

If the following SQL statements are executed:

 

CREATE TABLE tab1 (id SMALLINT NOT NULL PRIMARY KEY,

 

name VARCHAR(25));

 

CREATE TABLE tab2 (empid SMALLINT,

 

weekno SMALLINT,

 

payamt DECIMAL(6,2),

 

CONSTRAINT const1 FOREIGN KEY (empid)

 

REFERENCES taba(id) ON UPDATE NO ACTION);

 

Which of the following statements is true?

 

A.

Only values that exist in the ID column of table TAB1 are allowed to be inserted in the EMPID column of table TAB2

B.

The updating of values in the ID column of table TAB1 is not allowed

C.

Only values that do not already exist in the ID column of table TAB1 are allowed to be inserted in the EMPID column of table TAB2

D.

When values that exist in the ID column of table TAB1 are updated, corresponding values in the EMPID column of table TAB2 are updated as well

 

Correct Answer: A

 

 

QUESTION 186

Which of the following is used to indicate a column will not accept NULL values and can be referenced in another table’s foreign key specification?

 

A.

Check constraint

B.

Unique constraint

C.

Default constraint

D.

Informational constraint

 

Correct Answer: B

 

 

QUESTION 187

If table TAB1 is created using the following statement:

 

CREATE TABLE tab1 (col1 INTEGER NOT NULL,

 

col2 CHAR(5),

 

CONSTRAINT cst1 CHECK (col1 in (1, 2, 3)))

 

Which of the following statements will successfully insert a record into table TAB1?

 

A.

INSERT INTO tab1 VALUES (0, ‘abc’)

B.

INSERT INTO tab1 VALUES (NULL, ‘abc’)

C.

INSERT INTO tab1 VALUES (ABS(2), ‘abc’)

D.

INSERT INTO tab1 VALUES (DEFAULT, ‘abc’)

 

Correct Answer: C

 

 

 

 

 

 

QUESTION 188

If the 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 MODEL MAKEID

 

—— ——- ——–

 

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 rows that will be deleted?

 

A.

0

B.

1

C.

2

D.

3

Correct Answer: A

 

 

QUESTION 189

Which of the following is NOT a characteristic of a unique index?

 

A.

Each column in a base table can only participate in one unique index, regardless of how the columns are grouped (the same column cannot be used in multiple uniqueindexes)

B.

In order for an index to be used to support a unique constraint, it must have been defined with the UNIQUE attribute

C.

A unique index cannot be created for a populated table if the key column specified contains more than one NULL value

D.

A unique index can only be created for a non-nullable column

 

Correct Answer: D

 

 

QUESTION 190

If the following statement is executed:

 

CREATE TABLE employee

 

(empid INT NOT NULL GENERATED BY DEFAULT

 

AS IDENTITY (START WITH 1, INCREMENT BY 5),

 

name VARCHAR(20),

 

dept INT CHECK (dept BETWEEN 1 AND 20),

 

hiredate DATE WITH DEFAULT CURRENT DATE,

 

salary DECIMAL(7,2),

 

PRIMARY KEY(empid),

 

CONSTRAINT cst1 CHECK (YEAR(hiredate) > 2006 OR

 

Salary > 60500));

 

Which of the following INSERT statements will fail?

 

A.

INSERT INTO employee VALUES (15, ‘Smith’, 5, ’01/22/2004′, 92500.00)

B.

INSERT INTO employee VALUES (DEFAULT, ‘Smith’, 2, ’10/07/2002′, 80250.00)

C.

INSERT INTO employee VALUES (20, ‘Smith’, 5, NULL, 65000.00)

D.

INSERT INTO employee VALUES (DEFAULT, ‘Smith’, 10, ’11/18/2004′, 60250.00)

 

Correct Answer: D

100% Free Download!
—Download Free Demo:000-730 Demo PDF
100% Pass Guaranteed!
Download 2017 Ensurepass 000-730 Full Exam PDF and VCE Q&As:303
—Get 10% off your purchase! Copy it:TJDN-947R-9CCD [2017.05.01-2017.05.31]

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