READ Free Dumps For Oracle- 1z0-007
| Question ID 7921 | When should you create a role? (Choose two)
|
| Option A | To simplify the process of creating new users using the CREATE USER xxx IDENTIFIED by yyy statement.
|
| Option B | To grant a group of related privileges to a user.
|
| Option C | When the number of people using the database is very high.
|
| Option D | To simplify the process of granting and revoking privileges.
|
| Option E | To simplify profile maintenance for a user who is constantly traveling.
|
| Correct Answer | CD |
Explanation Explanation/Reference: Explanation: You should use roles to grant a group of privileges to a user. You grant the appropriate privileges to the role and after that grant this role to specific users. By granting to or revoking privileges from the role you can simplify procedure of users privileges maintainance: you don't need to grant/revoke privileges to/from each user. It's especially very helpful when you are experiencing a high number of people using the database. Incorrect Answers A: Roles have nothing to do with simplifying the process of creating new users. B: You can use roles to grant a group of privileges to a user, but they can be not related at all. E: Roles have nothing to do with user who is constantly traveling. OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 365-372 Chapter 8: User Control in Oracle
| Question ID 7922 | Which three statements about subqueries are true? (Choose three)
|
| Option A | Which three statements about subqueries are true? (Choose three)
|
| Option B | A single row subquery can retrieve only one row but many columns.
|
| Option C | A multiple row subquery can retrieve multiple rows and multiple columns.
|
| Option D | A multiple row subquery can be compared by using the ">" operator.
|
| Option E | A single row subquery can use the IN operator.
|
| Option F | A multiple row subquery can use the "=" operator.
|
| Correct Answer | BCD |
Explanation Explanation/Reference: Explanation: A single row sub-query can retrieve only one row but many columns. A multiple row sub-query can retrieve one row or multiple rows and multiple columns. A multiple row sub-query can be compared by using the ">" operator. Incorrect Answers A: A single row sub-query can retrieve only one row, but many columns.. E: A single row sub-query cannot use the IN operator. F: A multiple row sub-query cannot use the "=" operator. OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 150-165 Chapter 4: Subqueries