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
100-105 Dumps VCE PDF
200-105 Dumps VCE PDF
300-101 Dumps VCE PDF
300-115 Dumps VCE PDF
300-135 Dumps VCE PDF
300-320 Dumps VCE PDF
400-101 Dumps VCE PDF
640-911 Dumps VCE PDF
640-916 Dumps VCE PDF
70-410 Dumps VCE PDF
70-411 Dumps VCE PDF
70-412 Dumps VCE PDF
70-413 Dumps VCE PDF
70-414 Dumps VCE PDF
70-417 Dumps VCE PDF
70-461 Dumps VCE PDF
70-462 Dumps VCE PDF
70-463 Dumps VCE PDF
70-464 Dumps VCE PDF
70-465 Dumps VCE PDF
70-480 Dumps VCE PDF
70-483 Dumps VCE PDF
70-486 Dumps VCE PDF
70-487 Dumps VCE PDF
220-901 Dumps VCE PDF
220-902 Dumps VCE PDF
N10-006 Dumps VCE PDF
SY0-401 Dumps VCE PDF