IBM IBM Certified Database Associate C2090-730 Questions & Answers

• Question 251:

  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 252:

  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 253:

  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

• Question 254:

  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 255:

  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 256:

  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 INDEXempid_x TO user1

  B. GRANT DELETE ON INDEXempid_x TO user1

  C. GRANT INDEX ON TABLE employee TO user1

  D. GRANT CONTROL ON INDEXempid_x TO user1

  Correct Answer: D

• Question 257:

  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 258:

  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 259:

  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 260:

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

  A. CONNECT

  B. CONTROL

  C. SYSMAINT

  D. EXECUTE

  Correct Answer: C