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 11

What is the SQL Performance Monitor used for?

 

A.

To examine the health of a DB2 Database Manager instance

B.

To visually construct complex DML statements and examine the results of their execution

C.

To schedule tasks, run tasks, and send notifications about completed tasks to other users

D.

To analyze database operations performed against a DB2 for i5/OS database

 

Correct Answer: D

 

 


QUESTION 12

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

 

A.

Control Center

B.

Journal

C.

Command Line Processor

D.

Task Center

E.

Health Center

 

Correct Answer: AC

 

 

QUESTION 13

Which of the following tasks can NOT be performed using the Developer Workbench?

 

A.

Develop and debug an SQL stored procedure

B.

Develop and debug a user-defined data type

C.

Develop and debug a user-defined function

D.

Develop and run XML queries

 

Correct Answer: B

 

 

QUESTION 14

Which of the following tools can be used to automate table reorganization operations?

 

A.

Control Center

B.

Command Center

C.

Command Line Processor

D.

Task Center

Correct Answer: D

 

 

QUESTION 15

Which of the following can be viewed with the Journal?

 

A.

Historical information about tasks, database changes, messages, and notifications

B.

Information about licenses associated with each DB2 9 product installed on a particular system

C.

Graphical representations of data access plans chosen for SQL statements

D.

Warning and alarm thresholds for database indicators

 

Correct Answer: A

 

 

QUESTION 16

Which of the following is NOT a characteristic of a data warehouse?

 

A.

Summarized queries that perform aggregations and joins

B.

Heterogeneous data sources

C.

Voluminous historical data

D.

Sub-second response time

 

Correct Answer: D

 

 

QUESTION 17

Which of the following is NOT a characteristic of an OLTP database?

 

A.

Granular transactions

B.

Current data

C.

Optimized for queries

D.

Frequent updates

 

Correct Answer: C

 

 

QUESTION 18

Which of the following is true about XML columns?

 

A.

XML columns are used to store XML documents as a hierarchical set of entities

B.

Only XQuery can be used to retrieve an XML document from an XML column

C.

XML columns must be altered to accommodate additional parent/child relationships if they are used in referential constraints

D.

In order to access any portion of an XML document stored in an XML column, the entire document must be retrieved

 

Correct Answer: A

 

 

QUESTION 19

Which of the following products is used to shred extensible markup language documents?

 

A.

DB2 AVI Extender

B.

DB2 Text Extender

C.

DB2 XML Extender

D.

DB2 Spatial Extender

 

Correct Answer: C

 

 

QUESTION 20

Which of the following best describes the difference between the DB2 Spatial Extender and the DB2 Geodetic Extender?

 

A.

The DB2 Spatial Extender uses a latitude-longitude coordinate system; the DB2 Geodetic Extender uses a planar, x- and y-coordinate system

B.

The DB2 Geodetic Extender is used to describe points, lines, and polygons; the DB2 Spatial Extender is used to find area, endpoints, and intersects

C.

The DB2 Spatial Extender treats the world as a flat map; the DB2 Geodetic Extender treats the world as a roun
d globe

D.

The DB2 Geodetic Extender can be used to manage information like the locations of office buildings or the size of a flood zone; the DB2 Spatial Extender can be used for calculations and visualizations in disciplines like military command/control and asset management, meteorology and oceanography

 

Correct Answer: C

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