READ Free Dumps For Oracle- 1z0-001
| Question ID 8146 | Using SQL Plus you created a user with this command: CREATE USER Jennifer IDENTIFIED BY jbw122 What should you do to allow users database access?
|
| Option A | Use the alter user command to assign the user a default tablespace.
|
| Option B | Grant the user the create session privilege.
|
| Option C | Use the alter user to assign the user a default profile.
|
| Option D | No action is required to give the user database access.
|
| Correct Answer | B |
Explanation Explanation/Reference: Explanation: Answer B is correct. To connect to database user must have at least the CREATE SESSION privilege. Incorrect Answers: A: If you did not assign default tablespace for user during user account creation, SYSTEM is default tablespace by default for this user. Also default tablespace question does not have any relation to the database access question. C: Default profile is assigned for user automatically during user account creation, it also does not have relation with database access. D: Privilege CONNECT need to be assign for user, this action is required to allow user to access database. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 177-178 Chapter 4: Creating Other Database Objects in Oracle
| Question ID 8147 | A DBA has updated Smiths account by adding the privileges. Create any table and create procedure. Which task can Smith successfully perform?
|
| Option A | Smith can create tables, drop tables and create procedures in any schema of the database.
|
| Option B | Smith can create any table or procedure only in his schema also he can drop any table only from his schema.
|
| Option C | Smith can create a table in any schema of the database but can drop tables from and create a procedure only in his schemas.
|
| Option D | Smith can create table or a procedure in any schema of the database also he can drop the table in any schema of the database.
|
| Correct Answer | C |
Explanation Explanation/Reference: Explanation: Answer C is correct because privilege CREATE ANY TABLE allows user to create tables in any schema, user can drop all tables only in his own schema. CREATE PROCEDURE privilege allows to user just create procedure in his own schema. Incorrect Answers: A: This answer would be correct if Smith's account have been updated with CREATE ANY TABLE, DROP ANY TABLE, CREATE ANY PROCEDURE privileges. B: User can create any table in ALL schemas, not only in his schema. D: User cannot create procedures in ANY schemas and he cannot drop the table in ANY schema, only in his own. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 178-179 Chapter 4: Creating Other Database Objects in Oracle