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 81

If the following SQL statements are executed in the order shown:

 

CREATE TABLE orders

 

(order_num INTEGER NOT NULL,

 

buyer_name VARCHAR(35),

 

amount NUMERIC(5,2));

 

CREATE UNIQUE INDEX idx_orderno ON orders (order_num);

 

Which of the following describes the resulting behavior?

 

A.

Every ORDER_NUM value entered must be unique; whenever the ORDERS table is queried rows should be displayed in order of increasing ORDER_NUM values

B.

Every ORDER_NUM value entered must be unique; whenever the ORDERS table is queried rows will be displayed in no particular
order

C.

Duplicate ORDER_NUM values are allowed; no other index can be created for the ORDERS table that reference the ORDER_NUM column

D.

Every ORDER_NUM value entered must be unique; no other index can be created for the ORDERS table that reference the ORDER_NUM column

 

Correct Answer: A

 

 

QUESTION 82

An alias can be an alternate name for which two of the following DB2 objects?

 

A.

Sequence

B.

Trigger

C.

View

D.

Schema

E.

Table

 

Correct Answer: CE

 

QUESTION 83

Which of the following events will NOT cause a trigger to be activated?

 

A.

A select operation

B.

An insert operation

C.

An update operation

D.

A delete operation

 

Correct Answer: A

 

 

QUESTION 84

If a view named V1 is created in such a way that it references every column in a table named EMPLOYEE except a column named SALARY, which of the following is NOT an accurate statement?

 

A.

View V1 can be used in the same context as the EMPLOYEE table for all data retrieval operations that do not acquire SALARY information

B.

View V1 can be used as a data source for other views

C.

View V1 does not have to reside in the same schema as the EMPLOYEE table

D.

All data, except SALARY data that is stored in the EMPLOYEE table is copied to the physical location associated with view V1

 

Correct Answer: D

 

 

QUESTION 85

Which of the following would NOT provide access to data stored in table TABLE1 using the name T1?

 

A.

An alias named T1 that references table TABLE1

B.

A view named T1 that references table TABLE1

C.

A schema named T1 that references table TABLE1

D.

An alias named T1 that references a view named V1 that references table TABLE1

 

Correct Answer: C

 

 

QUESTION 86

Which of the following DB2 objects can be referenced by an INSERT statement to generate values for a column?

 

A.

Sequence

B.

Identity column

C.

Trigger

D.

Table function

 

Correct Answer: A

 

 

 

 

 

QUESTION 87

A sequence was created with the DDL statement shown below:

 

CREATE SEQUENCE my_seq START WITH 10 INCREMENT BY 10 CACHE 10

 

User USER1 successfully executes the following statements in the order shown:

 

VALUES NEXT VALUE FOR my_seq INTO :hvar;

 

VALUES NEXT VALUE FOR my_seq INTO :hvar;

 

User USER2 successfully executes the following statements in the order shown:

 

ALTER SEQUENCE my_seq RESTART WITH 5 INCREMENT BY 5 CACHE 5;

 

VALUES NEXT VALUE FOR my_seq INTO :hvar;

 

After users USER1 and USER2 are finished, user USER3 executes the following query:

 

SELECT NEXT VALUE FOR my_seq FROM sysibm.sysdummy1

 

What value will be returned by the query?

 

A.

5

B.

10

C.

20

D.

30

 

Correct Answer: D

 

 

QUESTION 88

Given the following statements:

 

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

 

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

 

CREATE VIEW view2 AS SELECT c1, c2 FROM view1

 

WITH CASCADED CHECK OPTION;

 

Which of the following INSERT statements will fail to execute?

 

A.

INSERT INTO view2 VALUES(50, ‘abc’)

B.

INSERT INTO view1 VALUES (100, ‘abc’)

C.

INSERT INTO view2 VALUES(150, ‘abc’)

D.

INSERT INTO view1 VALUES(100, ‘abc’)

 

Correct Answer: C

 

 

 

 

 

QUESTION 89

Given the following statements:

 

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

 

CREATE TABLE t1audit (user VARCHAR(20), date DATE, action

 

VARCHAR(20));

 

CREATE TRIGGER trig1 AFTER INSERT ON t1

 

FOR EACH ROW

 

MODE DB2SQL

 

INSERT INTO t1audit VALUES (CURRENT USER, CURRENT DATE,

 

‘Insert’);

 

If user USER1 executes the following statements:

 

INSERT INTO t1 VALUES (1, ‘abc’);

 

INSERT INTO t1 (c1) VALUES (2);

 

UPDATE t1 SET c2 = ‘ghi’ WHERE c1 = 1;

 

How many new records will be written to the database?

 

A.

0

B.

2

C.

3

D.

4

 

Correct Answer: D

 

 

QUESTION 90

Which of the following is NOT an attribute of Declared Global Temporary Tables (DGTTs)?

 

A.

Each application that defines a DGTT has its own instance of the DGTT

B.

Two different applications cannot create DGTTs that have the same name

C.

DGTTs can only be used by the application that creates them, and only for the life of the application

D.

Data stored in a DGTT can exist across transaction boundaries

 

Correct Answer: 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