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 41

In a client-server environment, which two of the following can be used to verify passwords?

 

A.

System Catalog

B.

User ID/password file

C.

Client Operating System

D.

Communications layer

E.

Application Server

 

Correct Answer: CE

 

 

QUESTION 42

A table named DEPARTMENT has the following columns:

 

DEPT_ID

 

DEPT_NAME

 

MANAGER

 

AVG_SALARY

 

Which of the following is the best way to prevent most users from viewing AVG_SALARY data?

 

A.

Encrypt the table’s data

B.

Create a view that does not contain the AVG_SALARY column

C.

Revoke SELECT access for the AVG_SALARY column from users who should not see AVG_SALARY data

D.

Store AVG_SALARY data in a separate table and grant SELECT privilege for that table to the appropriate users

 

Correct Answer: B

 

 

QUESTION 43

Which authority or privilege is granted by the DB2 Database Manager configuration file?

 

A.

CONNECT

B.

CONTROL

C.

SYSMAINT

D.

EXECUTE

 

Correct Answer: C

 

 

QUESTION 44

Which two of the following authorities allow a user to create a new database?

 

A.

SYSADMN

B.

SYSCTRL

C.

SYSMAINT

D.

DBADM

E.

CREATEDB

 

Correct Answer: AB

 

 

QUESTION 45

Assuming USER1 has no authorities or privileges, which of the following will allow USER1 to create a view named VIEW1 that references two tables named TAB1 and TAB2?

 

A.

CREATEIN privilege on the database

B.

REFERENCES privilege on TAB1 and TAB2

C.

CREATE_TAB privilege on the database

D.

SELECT privilege on TAB1 and TAB2

 

Correct Answer: D

 

 

QUESTION 46

Which of the following will allow user USER1 to change the comment associated with a table named TABLE1?

 

A.

GRANT UPDATE ON TABLE table1 TO user1

B.

GRANT CONTROL ON TABLE table1 TO user1

C.

GRANT ALTER ON TABLE table1 TO user1

D.

GRANT REFERENCES ON TABLE table1 TO user1

 

Correct Answer: C

 

 

QUESTION 47

A table called DEPARTMENT has the following columns:

 

DEPT_ID

 

DEPT_NAME

 

MANAGER

 

Which of the following statements will ONLY allow user USER1 to modify the DEPT_NAME column?

 

A.

GRANT ALTER ON TABLE department TO user1

B.

GRANT ALTER (dept_name) ON TABLE department TO user1

C.

GRANT UPDATE ON TABLE department TO user1

D.

GRANT UPDATE (dept_name) ON TABLE department TO user1

 

Correct Answer: D

 

 

QUESTION 48

An index named EMPID_X exists for a table named EMPLOYEE. Which of the following will allow user USER1 to drop the EMPID_X index?

 

A.

GRANT DROP ON INDEX empid_x TO user1

B.

GRANT DELETE ON INDEX empid_x TO user1

C.

GRANT INDEX ON TABLE employee TO user1

D.

GRANT CONTROL ON INDEX empid_x TO user1

 

Correct Answer: D

 

 

QUESTION 49

On which two of the following database objects may the SELECT privilege be controlled?

 

A.

Sequence

B.

Nickname

C.

Schema

D.

View

E.

Index

 

Correct Answer: BD

 

 

QUESTION 50

User USER1 wants to utilize an alias to remove rows from a table. Assuming USER1 has no authorities or privileges, which of the following privileges are needed?

 

A.

DELETE privilege on the table

B.

DELETE privilege on the alias

C.

DELETE privilege on the alias; REFERENCES privilege on the table

D.

REFERENCES privilege on the alias; DELETE privilege on the table

 

Correct Answer: A

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