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 51

Which SQL statement will allow user USER1 to create a view on a table named EMPLOYEE?

 

A.

GRANT CREATETAB ON DATABASE TO user1

B.

GRANT SELECT ON TABLE employee TO user1

C.

GRANT CREATEVIEW ON DATABASE TO user1

D.

GRANT REFERENCES ON TABLE employee TO user1

 

Correct Answer: B

 

 

QUESTION 52

A new user named USER1 needs to retrieve information from a database named MYDB. What authority must be granted to user USER1?

 

A.

DBCTRL authority

B.

SQLADM authority

C.

DATAACCESS authority

D.

ACCESSCTRL authority

 

Correct Answer: C

 

 

QUESTION 53

Which privilege is required to invoke a user defined function?

 

A.

CALL

B.

USAGE

C.

EXECUTE

D.

REFERENCES

 

Correct Answer: C

 

 

QUESTION 54

Which statement is true about an index that is used to support a UNIQUE constraint?

 

A.

It must not contain more than one column.

B.

It cannot be used in a referential constraint.

C.

It must be defined with the UNIQUE attribute.

D.

It must be defined as UNIQUE WHERE NOT NULL.

 

Correct Answer: C

QUESTION 55

Which statement regarding triggers is true?

 

A.

Only one INSERT, UPDATE, or DELETE trigger can be defined per table.

B.

Triggers cannot be modified, they must be dropped and recreated with new definitions.

C.

Adding a trigger to a table that already has rows in it will cause triggered actions to be fired.

D.

Triggers can only be fired one time per statement irrespective of the number of rows affected.

 

Correct Answer: B

 

 

QUESTION 56

A table named STATES was created as follows:

 

clip_image001

 

What will happen?

 

A.

An error will be returned and the operation will fail.

B.

A warning will be returned and the unique index INDX1 will become the index for the primary key.

C.

The primary key will be successfully added and the unique index INDX1 will be dropped and recreated as the primary key index.

D.

The primary key will be successfully added, the unique index INDX1 will be dropped, and a new index will be created for the primary key.

 

Correct Answer: B

 

 

QUESTION 57

When an application using a temporary table terminates or disconnects from the database unexpectedly, what happens to the temporary table and any data stored in it?

 

A.

The data in the table is deleted and the table persists.

B.

The data in the table is deleted and the table is implicitly dropped.

C.

The temporary table is converted to a base table and the data is deleted.

D.

The temporary table is converted to a base table and the data is persistent.

 

Correct Answer: B

 

 

QUESTION 58

When a user-defined function (UDF) is created and no schema is specified, what schema is used to store the UDF?

 

A.

The SYSIBM schema.

B.

The SYSFUN schema.

C.

A schema with the name of the UDF.

D.

A schema with the userid of the UDF definer.

 

Correct Answer: D

 

 

QUESTION 59

Which statement about triggers is true?

 

A.

A trigger is designed to return specific types of values and contains executable code.

B.

A trigger is designed to return specific types of values but contains no executable code.

C.

A trigger performs actions to capture details about an activity like a join operation against multiple tables.

D.

A trigger performs actions in response to an event like an INSERT, UPDATE or DELETE operation on a table.

 

Correct Answer: D

 

 

QUESTION 60

Which two statements are true about foreign key constraints? (Choose two.)

 

A.

The foreign key constraint columns must be supported by an index.

B.

The foreign key constraint columns must be defined as NOT NULL.

C.

The number and data types of foreign key constraint columns must match the parent key.

D.

The columns of one foreign key constraint cannot be used in another foreign key constraint.

E.

To define a foreign key constraint there must be an associated primary key or unique key in the same or different table.

 

Correct Answer: CE

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