File Info
| Exam | Oracle Database 12cR2 Administration |
| Number | 1z0-072 |
| File Name | Oracle.1z0-072.ActualTests.2019-10-15.42q.tqb |
| Size | 494 KB |
| Posted | Oct 15, 2019 |
| Download | Oracle.1z0-072.ActualTests.2019-10-15.42q.tqb |
How to open VCEX & EXAM Files?
Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.
Coupon: MASTEREXAM
With discount: 20%
Demo Questions
Question 1
TBS1 is a permanent user-defined tablespace created with Oracle Managed Files (OMF).
Examine this command:
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 2
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
Question 3
DATADIR1 and DATADIR2 are database directory objects.
Examine this command:
Which two are true about the expdp operation? (Choose two.)
- It creates a dump file for the entire database.
- It fails if the total size of the dump file is more than 2 GB.
- It creates a dump file only for objects in the SYSTEM schema.
- It creates a master table to store details of the export operation.
- It starts only when four worker processes are available.
Correct answer: AE
Explanation:
Reference: https://docs.oracle.com/database/121/SUTIL/GUID-1E134053-692A-4386-BB77-153CB4A6071A.htm#SUTIL887 Reference: https://docs.oracle.com/database/121/SUTIL/GUID-1E134053-692A-4386-BB77-153CB4A6071A.htm#SUTIL887
