IBM IBM Certified Database Associate C2090-730 Questions & Answers

• Question 231:

  Which of the following statements is used to prevent user TOM from adding and deleting data in table TAB1?

  A. REVOKE ADD, DELETE FROM USER tom ON TABLE tab1

  B. REVOKE ADD, DELETE ON TABLE tab1 FROM USER tom

  C. REVOKE INSERT, DELETE FROM USER tom ON TABLE tab1

  D. REVOKE INSERT, DELETE ON TABLE tab1 FROM USER tom

  Correct Answer: D

• Question 232:

  Which of the following privileges permits a user to update the comment on a sequence?

  A. CONTROL

  B. UPDATE

  C. USAGE

  D. ALTER

  Correct Answer: D

• Question 233:

  Which of the following statements is used to revoke all DML privileges on table EMPLOYEE from user TOM?

  A. REVOKE ALL PRIVILEGES FROM USER tom

  B. REVOKE ALL ON EMPLOYEE FROM USER tom

  C. REVOKE EXECUTE ON EMPLOYEE FROM USER tom

  D. REVOKE PRIVILEGES ON EMPLOYEE FROM USER tom

  Correct Answer: B

• Question 234:

  What is the lowest privilege and/or authority required to execute the following SQL statement?

  CREATE VIEW view1 AS SELECT * FROM table1 WHERE STATE = 'TX'

  A. DBADM authority

  B. SYSADM authority

  C. SELECT privilege on TABLE1

  D. REFERENCES privilege on TABLE1

  Correct Answer: C

• Question 235:

  Which of the following statements allows BOB to revoke access to the SAMPLE database from user TOM?

  A. REVOKE ACCESS ON DATABASE FROM USER bob

  B. REVOKE CONNECT ON DATABASE FROM USER tom

  C. REVOKE tom FROM ACCESS ON DATABASE BY USER bob

  D. REVOKE tom FROM CONNECT ON DATABASE BY USER bob

  Correct Answer: B

• Question 236:

  While attempting to connect to a database stored on an iSeries server from a Windows client, the following

  message was displayed:

  SQL1013N The database alias name or database name "TEST_DB" could not be found. Which of the following

  actions can be used to help determine why this message was displayed?

  A. Execute the LIST REMOTE DATABASES command on the server; look for an entry for the TEST_DB database

  B. Execute the LIST DCS DIRECTORY command on the server; look for an entry for the TEST_DB database

  C. Execute the LIST REMOTE DATABASES command on the client; look for an entry for the TEST_DB database

  D. Execute the LIST DCS DIRECTORY command on the client; look for an entry for the TEST_DB database

  Correct Answer: D

• Question 237:

  A view named V.VIEW1 is based on a table named T.TABLE1. A user with DBADM authority issues the

  following statement:

  GRANT INSERT ON v.view1 TO user1 WITH GRANT OPTION

  Which of the following statements is USER1 authorized to execute?

  A. GRANT INSERT ON t.table1 TO user2

  B. GRANT CONTROL ON v.view1 TO user2

  C. GRANT ALL PRIVILEGES ON v.view1 TO user2

  D. GRANT INSERT ON v.view1 TO user2

  Correct Answer: D

• Question 238:

  User USER1 has the privileges needed to invoke a stored procedure named GEN_RESUME. User USER2 needs to be able to call the procedure - user USER1 and all members of the group PUBLIC should no longer be allowed to call the procedure. Which of the following statement(s) can be used to accomplish this?

  A. GRANT EXECUTE ON ROUTINEgen_resume TO user2 EXCLUDE user1, PUBLIC

  B. GRANT EXECUTE ON PROCEDUREgen_resume TO user2; REVOKE EXECUTE ON PROCEDURE gen_resume FROM user1, PUBLIC;

  C. GRANT CALL ON ROUTINEgen_resume TO user2 EXCLUDE user1 PUBLIC

  D. GRANT CALL ON PROCEDUREgen_resume TO user2; REVOKE CALL ON PROCEDURE gen_resume FROM user1, PUBLIC;

  Correct Answer: B

• Question 239:

  User USER1 is the owner of TABLE1. Assuming user USER1 only holds privileges for TABLE1,

  A. REVOKE CONTROL ON table1 FROM user1

  B. REVOKE ALL PRIVILEGES ON table1 FROM user1

  C. REVOKE CONTROL ON table1 FROM user1; REVOKE ALL PRIVILEGES ON table1 FROM user1;

  D. REVOKE CONTROL, ALL PRIVILEGES ON table1 FROM user1

  Correct Answer: C

• Question 240:

  Which of the following will provide user USER1 and all members of the group GROUP1 with the ability to perform DML, but no other operations on table TABLE1?

  A. GRANT INSERT, UPDATE, DELETE, SELECT ON TABLE table1 TO user1 AND group1

  B. GRANT INSERT, UPDATE, DELETE, SELECT ON TABLE table1 TO USER user1, GROUP group1

  C. GRANT ALL PRIVILEGES EXCEPT ALTER, INDEX, REFERENCES ON TABLE table1 TO USER user1, GROUP group1

  D. GRANT CONTROL ON TABLE table1 TO user1 AND group1

  Correct Answer: B