Download Oracle Database 12cR2 Administration.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 |
How to open VCEX files?
Files with VCEX extension can be opened by ProfExam Simulator.
Discount: 20%
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
HOW TO OPEN VCE FILES
Use VCE Exam Simulator to open VCE files
HOW TO OPEN VCEX AND EXAM FILES
Use ProfExam Simulator to open VCEX and EXAM files
ProfExam at a 20% markdown
You have the opportunity to purchase ProfExam at a 20% reduced price
Get Now!