Latest Certified Success Dumps Download

CISCO, MICROSOFT, COMPTIA, HP, IBM, ORACLE, VMWARE
000-730 Real Tests (May 2017)

[Free] 2017(May) Ensurepass Pass4sure IBM 000-730 Real Tests 51-60

May 4, 2017

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 51

A user utilizing an alias to update a subset of columns in a table must have UPDATE privileges on which of the following DB2 objects?

 

A.

Table

B.

Columns

C.

Table and Alias

D.

Columns and Alias

 

Correct Answer: A

 

 

QUESTION 52

Assuming PUBLIC has been granted all privileges on table T1, which of the following statements would continue to permit any user to add rows to table T1, but not remove them?

 

A.

REVOKE DROP ON t1 FROM PUBLIC

B.

REVOKE UPDATE ON t1 FROM PUBLIC

C.

REVOKE DELETE ON t1 FROM PUBLIC

D.

REVOKE CONTROL ON t1 FROM PUBLIC

 

Correct Answer: C

QUESTION 53

Which of the following statements is used to grant user TOM and Application team APPGRP the ability to add data to table TAB1?

 

A.

GRANT ADD DATA ON TABLE tab1 TO GROUP tom appgrp

B.

GRANT INSERT TO USER tom, GROUP appgrp ON TABLE tab1

C.

GRANT INSERT ON TABLE tab1 TO USER tom, GROUP appgrp

D.

GRANT ADD DATA ON TABLE tab1 TO USER appgrp, GROUP tom

 

Correct Answer: C

 

 

QUESTION 54

A “trusted” client needs to communicate with a server that has been configured to use CLIENT authentication. Which of the following will be used to verify passwords?

 

A.

User ID/password file

B.

Communications layer

C.

Client applications

D.

Operating system

 

Correct Answer: D

 

 

QUESTION 55

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

 

A.

Sequence

B.

Schema

C.

Group

D.

View

 

Correct Answer: D

 

 

QUESTION 56

A user needs to create a trigger that will update table T2 whenever a row is added to table T1. Assuming the user has all appropriate privileges for table T2, which privilege is required on table T1 to create the trigger?

 

A.

REFERENCES

B.

SELECT

C.

UPDATE

D.

ALTER

 

Correct Answer: D

 

 

QUESTION 57

User USER1 holds CONTROL privilege on table TABLE1. Which two of the following statements is user USER1 allowed to execute?

 

A.

GRANT CONTROL ON table1 TO user2

B.

GRANT LOAD ON table1 TO user2

C.

GRANT INSERT, UPDATE ON table1 TO user2 WITH GRANT OPTION

D.

GRANT BINDADD ON table1 TO PUBLIC

E.

GRANT ALL PRIVILEGES ON table1 TO PUBLIC

 

Correct Answer: CE

 

 

QUESTION 58

A user wishing to invoke an SQL stored procedure that queries a table must have which of the following privileges?

 

A.

CALL privilege on the procedure; SELECT privilege on the table

B.

CALL privilege on the procedure; REFERENCES privilege on the table

C.

EXECUTE privilege on the procedure; SELECT privilege on the table

D.

EXECUTE privilege on the procedure; REFERENCES privilege on the table

 

Correct Answer: C

 

 

QUESTION 59

After the following SQL statement is executed:

 

GRANT ALL PRIVILEGES ON TABLE employee TO USER user1

 

Assuming user USER1 has no other authorities or privileges, which of the following actions is user USER1 allowed to perform?

 

A.

Drop an index on the EMPLOYEE table

B.

Grant all privileges on the EMPLOYEE table to other users

C.

Alter the table definition

D.

Drop the EMPLOYEE table

 

Correct Answer: C

 

 

QUESTION 60

Which two of the following privileges is required in order to use a package?

 

A.

BINDADD

B.

BIND

C.

CONNECT

D.

EXECUTE

E.

USE

 

Correct Answer: CD

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