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

DB2 10.1 DBA for Linux, UNIX, and Windows

QUESTION 41

Which two conditions must be met before Automatic Dictionary Creation (ADC) can be used to generate a compression dictionary for a table? (Choose two.)

 

A.

The table is not a system temporary table.

B.

The table contains a sufficient amount of data.

C.

A table-level compression dictionary does not already exist for the table.

D.

A page-level compression dictionary does not already exist for the table.

E.

The table does not have any indexes defined on it that have not been enabled for compression.

 

Correct Answer: BC

 

QUESTION 42

A partitioned table named SALES was created as follows:

 

clip_image002

 

Which statement about the PARTS_IDX index is true?

 

A.

The index PARTS_IDX will be a nonpartitioned index and it will be stored in table space TBSP3.

B.

The index PARTS_IDX will be a nonpartitioned index and it will be stored in table space TBSP0.

C.

The index PARTS_IDX will contain 3 partitions and all three partitions will be stored in table space TBSP3.

D.

The index PARTS_IDX will contain 3 partitions; the first partition will be stored in table space TBSP0, the second in TBSP1, and the third inTBSP2.

 

Correct Answer: D

 

 

QUESTION 43

An existing non-automatic storage database named MYDB has been successfully converted to an automatic storage database. What must be done to convert any existing DMS table spaces to automatic storage table spaces?

 

A.

Execute the statement ALTER DATABASE mydb CONVERT TO AUTOMATIC STORAGE IMMEDIATE.

B.

Execute the statement ALTER DATABASE mydb CONVERT TABLESPACES TO AUTOMATIC STORAGE.

C.

Execute the ALTER TABLESPACE statement with the MANAGED BY STOGROUP clause specified for each DMS table space that is to beconverted.

D.

Execute the ALTER TABLESPACE statement with the MANAGED BY AUTOMATIC STORAGE clause specified for each DMS table space that isto be converted.

 

Correct Answer: D

 

 

 

 

 

QUESTION 44

Which statement about BEFORE triggers is FALSE?

 

A.

A BEFORE trigger’s action is executed for each row in the set of affected rows before the trigger event executes.

B.

A BEFORE trigger’s action is executed for each row in the set of affected rows instead of executing the trigger event.

C.

A BEFORE trigger is used to perform validation of input data and to automatically generate values for newly inserted rows.

D.

A BEFORE trigger cannot be used to modify data in a database because they are activated before the trigger event is applied to the database.

 

Correct Answer: B

 

 

QUESTION 45

What are two purposes of the SET INTEGRITY statement? (Choose two.)

 

A.

To bring a table out of “Set Integrity Pending” state by performing the required integrity processing on the table.

B.

To bring a table out of “Set Integrity Pending” state by performing only check constraint processing on the table.

C.

To bring a table out of “Set Integrity Pending” state without performing the required integrity processing on the table.

D.

To bring a table out of “Set Integrity Pending” state by performing only referential integrity constraint processing on the table.

E.

To bring a table out of “Set Integrity Pending” state by performing only referential integrity and check constraint processing on the table.

 

Correct Answer: AC

 

 

QUESTION 46

You want to modify an existing view so that any rows that are inserted or updated with the view will not violate the SELECT statement that was used to create the view. What should you do?

 

A.

Alter the view and add the ENFORCE SELECT clause to the view definition.

B.

Drop and recreate the view with the WITH CHECK OPTION clause specified.

C.

Alter the view and add the WITH CHECK OPTION clause to the view definition.

D.

Create a new view with the same name and the ENFORCE SELECT clause specified.

 

Correct Answer: B

 

 

QUESTION 47

What is an informational constraint?

 

A.

A constraint that defines a relationship to a federated object.

B.

A constraint that is used by the optimizer but is not enforced.

C.

A constraint that provides Information to the RUNSTATS utility.

D.

A constraint that is created from information supplied to the design advisor.

 

Correct Answer: B

QUESTION 48

Given the following statement:

 

clip_image004

 

How many constraints are present in the DEPARTMENT table?

 

A.

1

B.

2

C.

3

D.

4

 

Correct Answer: D

 

 

QUESTION 49

Which two server authentication methods are supported by transparent Lightweight Directory Access Protocol (LDAP)? (Choose two.)

 

A.

CLIENT

B.

SERVER

C.

LDAP_PLUGIN

D.

DATA_ENCRYPT

E.

KERBEROS_PLUGIN

 

Correct Answer: BD

 

 

QUESTION 50

Which command is used to export connectivity configuration information from a file known as a configuration profile?

 

A.

db2ca

B.

db2cfexp

C.

db2cfimp

D.

db2cfgexp

 

Correct Answer: B

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