Download Oracle.1z0-072.PracticeTest.2019-06-19.34q.tqb
| Vendor: | Oracle |
| Exam Code: | 1z0-072 |
| Exam Name: | Oracle Database 12cR2 Administration |
| Date: | Jun 19, 2019 |
| File Size: | 145 KB |
| Downloads: | 1 |
Demo Questions
Question 1
In your database, you create a user, HR, and then execute this command:
GRANT CREATE SESSION TO hr WITH ADMIN OPTION;
Which three actions can HR perform? (Choose three.)
- Grant the CREATE SESSION privilege without ADMIN OPTION to other users.
- Grant the CREATE SESSION privilege with ADMIN OPTION to other users.
- Execute DML statements in the HR schema.
- Log in to the database instance.
- Revoke the CREATE SESSION privilege from other users.
- Execute DDL statements in the HR schema.
Correct answer: BDE
Explanation:
Reference: https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_9013.htm Reference: https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_9013.htm
Question 2
TBS1 is a permanent user-defined tablespace created with Oracle Managed Files (OMF).
Examine this command:
DROP TABLESPACE tbs1;
Which is required to ensure that TBS1 is dropped and its datafiles are deleted from their file system?
- The INCLUDING CONTENTS AND DATAFILES clause must be added to the command.
- TBS1 must be placed in READ ONLY state.
- Objects in TBS1 must not be in use when the command is executed.
- TBS1 must not contain any temp files.
- DB_CREATE_FILE_DEST must refer to an Oracle Automatic Storage Management (ASM)disk group.
Correct answer: A
Explanation:
Reference: https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_9004.htm Reference: https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_9004.htm
Question 3
Which three types of files are created by expdp operations? (Choose three.)
- SQL files
- dump files
- reject files
- log files
- input data files
- bad files
- control files
Correct answer: ABD
Explanation:
Reference: https://docs.oracle.com/cd/B28359_01/server.111/b28319/dp_export.htm#g1022624 Reference: https://docs.oracle.com/cd/B28359_01/server.111/b28319/dp_export.htm#g1022624
