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 191

Which type of key is defined on the child table to implement a referential constraint?

 

A.

Unique key

B.

Primary key

C.

Foreign key

D.

Composite key

 

Correct Answer: B

 

 

QUESTION 192

Which of the following is NOT true about schemas?

 

A.

If a schema name is not specified, either by qualifying a database object name or by executing the SET CURRENT SCHEMA statement, the authorization ID of the current session user is used as the schema name by default

B.

The value assigned to the CURRENT SCHEMA special register is persistent across database restarts

C.

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

D.

When most database objects are created, they are either implicitly or explicitly assigned to a schema

 

Correct Answer: B

 

 

QUESTION 193

When does a view get populated?


 

A.

When it is created

B.

When it is referenced in an INSERT statement

C.

The first time any executable SQL statement references it

D.

Any time an executable SQL statement references it

 

Correct Answer: D

 

 

QUESTION 194

Given the following statements:

 

CREATE TABLE table1 (col1 INTEGER, col2 CHAR(3));

 

CREATE VIEW view1 AS

 

SELECT col1, col2 FROM table1

 

WHERE col1 < 100

 

WITH LOCAL CHECK OPTION;

 

Which of the following INSERT statements will execute successfully?

 

A.

INSERT INTO view1 VALUES (50, abc)

B.

INSERT INTO view1 VALUES(100, abc)

C.

INSERT INTO view1 VALUES(50, ‘abc’)

D.

INSERT INTO view1 VALUES(100, ‘abc’)

Correct Answer: C

 

 

QUESTION 195

Which of the following actions will NOT cause a trigger to be fired?

 

A.

INSERT

B.

DELETE

C.

ALTER

D.

UPDATE

 

Correct Answer: C

 

 

QUESTION 196

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;

 

CREATE TRIGGER 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 ‘75005’

 

SET MESSAGE_TEXT = ‘Deletes not allowed!’;

 

Which of the following statements is NOT true?

 

A.

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

B.

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

C.

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

D.

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

 

Correct Answer: D

 

 

QUESTION 197

Which of the following CREATE TABLE statements will NOT be successful?

 

A.

CREATE TABLE t1 (c1 XML NOT NULL UNIQUE, c2 INT)

B.

CREATE TABLE t1 (c1 XML NOT NULL, c2 CHAR(20))

C.

CREATE TABLE t1 (c1 XML CHECK (c1 IS VALIDATED), c2 INT)

D.

CREATE TABLE t1 (c1 XML, c2 XML)

 

Correct Answer: A

 

 

QUESTION 198

If the following SQL statement is executed:

 

CREATE TABLE sales

 

(invoice_no NOT NULL PRIMARY KEY,

 

sales_date DATE,

 

sales_amt NUMERIC(7,2))

 

IN tbsp0, tbsp1, tbsp2, tbsp3

 

PARTITION BY RANGE (sales_date NULLS FIRST)

 

(STARTING ‘1/1/2007′ ENDING ’12/31/2007’

 

EVERY 3 MONTHS)

 

Which of the following statements is true?

 

A.

Administrative tasks such as backing up, restoring, and reorganizing data stored in the SALES table must be done at the table level; not at the partition level

B.

Data can be quickly rolled in and out of the SALES table by using the ATTACH PARTITION and DETACH PARTITION clauses of the ALTER TABLE statement

C.

If an index is created for the SALES table, its data must be stored in table space TBSP0

D.

When resolving queries against the SALES table, each partition used is scanned asynchronously and the results of each partition scan are merged to produce the result data set returned

 

Correct Answer: B

 

 

 

 

QUESTION 199

Which of the following is NOT a characteristic of a declared temporary table?

 

A.

Declared temporary tables are not persistent and can only be used by the application that creates them

B.

It is possible for many applications to create declared temporary tables that have the same name

C.

Declared temporary tables are created by executing a CREATE TABLE statement with the DECLARED GLOBAL TEMPORARY clause specified

D.

Once the application that created a global temporary table is terminated, any records in the table are deleted and the table is automatically destroyed

 

Correct Answer: C

 

 

QUESTION 200

Which of the following will be a consequence of defining the column IDCOL2 in TABLE2 as a foreign key referencing the primary key (IDCOL1) of TABLE1?

 

A.

DB2 will no longer allow updating the value of IDCOL1 in TABLE1.

B.

When inserting a row in TABLE2, the only values that DB2 will allow for IDCOL2 are the existing values of IDCOL1.

C.

When inserting a row in TABLE2, DB2 will only allow foreign values for IDCOL2,that is values which do not exist in IDCOL1.

D.

When a SELECT statement joins TABLE1 with TABLE2, DB2 will automatically add the condition TABLE1.IDCOL1=TABLE2.IDCOL2 if not specified in the statement.

 

Correct An
swer:
B

 

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