READ Free Dumps For Oracle- 1z0-007
| Question ID 7951 | What is true about the WITH GRANT OPTION clause?
|
| Option A | It allows a grantee DBA privileges.
|
| Option B | It is required syntax for object privileges.
|
| Option C | It allows privileges on specified columns of tables.
|
| Option D | It is used to grant an object privilege on a foreign key column.
|
| Option E | t allows the grantee to grant object privileges to other users and roles.
|
| Correct Answer | E |
Explanation Explanation/Reference: Explanation: The GRANT command with the WITH GRANT OPTION clause allows the grantee to grant object privileges to other users and roles. Incorrect Answers A: The WITH GRANT OPTION does not allow a grantee DBA privileges. B: It is not required syntax for object privileges. It is optional clause of GRANT command. C: GRANT command does not allows privileges on columns of tables. D: It is not used to grant an object privilege on a foreign key column. OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 356-365 Chapter 8: User Access in Oracle
| Question ID 7952 | Which substitution variable would you use if you want to reuse the variable without prompting the user each time?
|
| Option A | &
|
| Option B | ACCEPT
|
| Option C | PROMPT
|
| Option D | &&
|
| Correct Answer | D |
Explanation Explanation/Reference: Explanation: To reuse the variable without prompting the user each time you can use && substitution variable. Incorrect Answers A: This substitution variable will prompt the user each time. B: ACCEPT is command, not substitution variable. It used to define more accurate or specific prompt or when you want more output to display as the values are defined. C: PROMPT is part of the ACCEPT command, it is not a variable. OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 165-173 Chapter 4: Subqueries