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

DB2 10.1 Fundamentals

QUESTION 81

Which SQL statement will create a DB2 object that can be used to store numerical data as Canadian currency?

 

A.

CREATE DISTINCT ALIAS canadian_dollar AS DECIMAL (9,3) WITH COMPARISONS

B.

CREATE DISTINCT TYPE canadian_dollar AS DECIMAL (9,3) WITH COMPARISONS

C.

CREATE DISTINCT PROCEDURE canadian_dollar AS DECIMAL (9,3) WITH COMPARISONS

D.

CREATE DISTINCT FUNCTION canadian_dollar AS DECIMAL (9,3) WITH COMPARISONS

 

Correct Answer: B

 

 

QUESTION 82

Which object can be enabled for compression?

 

A.

View

B.

Buffer pool

C.

Storage group

D.

Temporary table

 

Correct Answer: D

 

 

QUESTION 83

What is the minimum product required for DB2 connectivity across all platforms?

 

A.

DB2 Personal Edition

B.

DB2 Development Edition

C.

DB2 Connect Personal Edition

D.

DB2 Development Unlimited Edition

 

Correct Answer: C

 

 

QUESTION 84

Given the SQL statement: CREATE ALIAS total_sales FOR sales Which statement is valid?

 

A.

SALES can be the name of a schema.

B.

SALES can be the name of a package.

C.

SALES can be the name of an existing alias.

D.

SALES can be the name of a declared global temporary table.

 

Correct Answer: C

 

 

QUESTION 85

Which DB2 object limits the user’s ability to retrieve data from a table by defining a SQL statement in the object?

 

A.

View

B.

Index

C.

Trigger

D.

Check constraint

 

Correct Answer: A

 

 

QUESTION 86

A table named EMPLOYEES was created as follows:

 

clip_image001

 

What will be the results?

 

A.

0

B.

1

C.

2

D.

3

 

Correct Answer: C

 

 

QUESTION 87

Which two DB2 objects can a view be derived from? (Choose two.)

 

B.

A.

View

Index

C.

Table

D.

Trigger

E.

Procedure

 

Correct Answer: AC

 

 

QUESTION 88

Which protocol provides applications the ability to connect to and update multiple DB2 databases within the same transaction?

 

A.

< p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: normal; text-autospace: ; mso-layout-grid-align: none" align="left">Type-1 connect

B.

Type-2 connect

C.

Type-3 connect

D.

Type-4 connect

 

Correct Answer: B

 

 

QUESTION 89

Which statement about bitemporal tables is valid?

 

A.

Bitemporal tables are system tables and can only be queried by the schema owner.

B.

Creating a bitemporal table is similar to creating a regular table except users must specify a system time period column.

C.

When data in a bitemporal table is updated, a row is added to it’s associated history table.

D.

Querying a bitemporal table will produce results for a complete timeline; a view must be created to obtain results for a specific time period.

 

Correct Answer: C

 

 

QUESTION 90

Which object can a buffer pool be assigned to?

 

A.

Schema

B.

Table space

C.

Storage group

D.

Stored procedure

 

Correct Answer: B

100% Free Download!
—Download Free Demo:000-610 Demo PDF
100% Pass Guaranteed!
Download 2017 Ensurepass 000-610 Full Exam PDF and VCE Q&As:138
—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