IBM IBM Certified Database Associate C2090-730 Questions & Answers

• Question 241:

  What does the following statement do?

  GRANT REFERENCES (col1, col2) ON TABLE table1 TO user1 WITH GRANT OPTION

  A. Gives user USER1 the ability to refer to COL1 and COL2 of table TABLE1 in queries, along with the ability to give this authority to other users and groups.

  B. Gives user USER1 the ability to refer to COL1 and COL2 of table TABLE1 in views, along with the ability to give this authority to other users and groups.

  C. Gives user USER1 the ability to define a referential constraint on table TABLE1 using columns COL1 and COL2 as the parent key of the constraint.

  D. Gives user USER1 the ability to define a referential constraint on table TABLE1 using columns COL1 and COL2 as the foreign key of the constraint.

  Correct Answer: C

• Question 242:

  Which of the following statements allows user USER1 to take the ability to create packages in a database named SAMPLE away from user USER2?

  A. REVOKE CONNECT ON DATABASE FROM user2

  B. REVOKE CREATETAB ON DATABASE FROM user2

  C. REVOKE BIND ON DATABASE FROM user2

  D. REVOKE BINDADD ON DATABASE FROM user2

  Correct Answer: D

• Question 243:

  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

• Question 244:

  Which of the following statements allows USER1 to take away read access on the table ORG.TAB1 from USER2?

  A. REVOKE SELECT FROM user2 ON TABLE org.tab1

  B. REVOKE SELECT ON TABLE org.tab1 FROM user2

  C. REVOKE READ ACCESS FROM user2 ON TABLE org.tab1

  D. REVOKE READ ACCESS ON TABLE org.tab1 FROM user2

  Correct Answer: B

• Question 245:

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

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

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

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

  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 tomappgrp

  B. GRANT INSERT TO USER tom, GROUPappgrp ON TABLE tab1

  C. GRANT INSERT ON TABLE tab1 TO USER tom, GROUPappgrp

  D. GRANT ADD DATA ON TABLE tab1 TO USERappgrp, GROUP tom

  Correct Answer: C

• Question 250:

  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