READ Free Dumps For Oracle- 1z0-001
| Question ID 1510 | You are a user of the PROD database which contains over 1000 tables, and you need to determine the number of tables you can access. Which data dictionary view could you query to display this information? |
| Option A | A. DBA_TABLES |
| Option B | B. ALL_OBJECTS |
| Option C | C. USER_OBJECTS |
| Option D | D. DBA_SEGMENTS |
| Correct Answer | B |
| Question ID 1511 | Using SQL*Plus, you created a user with this command: |
| Option A | A. Grant the user the CREATE SESSION privilege. |
| Option B | B. Use the ALTER USER to assign the user a default profile. |
| Option C | C. Use the ALTER USER command to assign the user a default tablespace. |
| Option D | D. No action is required to give the user database access. |
| Correct Answer | A |