READ Free Dumps For Oracle- 1z0-007
| Question ID 7886 | You added a PHONE_NUMBER column of NUMBER data type to an existing EMPLOYEES table. The EMPLOYEES table already contains records of 100 employees. Now, you want to enter the phone numbers of each of the 100 employees into the table. Some of the employees may not have a phone number available. Which data manipulation operation do you perform?
|
| Option A | MERGE
|
| Option B | INSERT
|
| Option C | UPDATE
|
| Option D | ADD
|
| Option E | ENTER
|
| Option F | You cannot enter the phone numbers for the existing employee records.
|
| Correct Answer | C |
Explanation Explanation/Reference: Explanation: To update information you need to use UPDATE command. Incorrect Answers A: Since you don't have to add any records to the table you don't need the MERGE command. B: Since you don't have to add any records to the table you don't need the MERGE command. D: There is no ADD command in Oracle. E: There is no ENTER command in Oracle. F: You can enter the phone numbers for the existing employee records by using UPDATE command. OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 267-270 Chapter 3: Manipulating Oracle Data
| Question ID 7888 | Which two statements accurately describe a role? (Choose two.)
|
| Option A | A role can be given to a maximum of 1000 users.
|
| Option B | A user can have access to a maximum of 10 roles.
|
| Option C | A role can have a maximum of 100 privileges contained in it
|
| Option D | Privileges are given to a role by using the CREATE ROLE statement.
|
| Option E | A role is a named group of related privileges that can be granted to the user.
|
| Option F | A user can have access to several roles, and several users can be assigned the same role.
|
| Correct Answer | EF |
Explanation Explanation/Reference: Explanation: E: A role is a named group of Privileges that can be granted to a user. F: A user can have access to several roles, and several users can be assigned the same role. Incorrect Answers A: There is no limitation to a 1000 users for one role in Oracle. B: There is no limitation to a 10 roles for one user in Oracle. C: There is no limitation to a 1000 privileges for one role in Oracle. D: Privileges can be given to a role by using a CREATE ROLE Statement is incorrect. Privileges are given to a role by the use of a GRANT statement. OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 365-373 Chapter 8: User Access Control in Oracle