File Info
| Exam | Oracle Database 12cR2 Administration |
| Number | 1z0-072 |
| File Name | Oracle.1z0-072.ActualTests.2019-10-15.42q.vcex |
| Size | 355 KB |
| Posted | Oct 15, 2019 |
| Download | Oracle.1z0-072.ActualTests.2019-10-15.42q.vcex |
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
Question 4
Which statement is true about smallfile tablespaces?
- Extent location metadata is stored in the data dictionary by default.
- The number of data files is constrained only by the size of the storage array.
- Maximum file size can be set to unlimited only if the logical volume manager supports striping.
- Segments can span multiple tablespaces.
- Segments can span multiple data files.
Correct answer: E
Explanation:
Reference: https://docs.oracle.com/database/121/CNCPT/logical.htm Reference: https://docs.oracle.com/database/121/CNCPT/logical.htm
Question 5
Which three are true about Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), and the MMON background process? (Choose three.)
- AWR snapshots must be deleted when no longer required by ADDM.
- ADDM can recommend shrinking the buffer cache.
- By default, MMON creates an AWR snapshot every 30 minutes.
- ADDM can recommend extending the buffer cache.
- By default, AWR snapshots are automatically purged after eight days.
- ADDM performs its analysis only whenever a DBA requests it.
Correct answer: BEF
Question 6
What three are true about Oracle Flashback technology? (Choose three.)
- FLASHBACK TRANSACTION can be used to undo the changes made by a committed transaction.
- FLASHBACK TABLE can be used to rewind a table back in time.
- FLASHBACK DATABASE can be used to rewind a database back and forth in time.
- FLASHBACK TABLE can be used to undo dropping a column from a table.
- FLASHBACK QUERY can be used to view committed data at any given point in time.
Correct answer: ACD
Question 7
Which two can you use to recover a dropped table? (Choose two.)
- FLASHBACK QUERY
- FLASHBACK DATABASE
- FLASHBACK TRANSACTION
- FLASHBACK TABLE TO SCN
- FLASHBACK DROP
Correct answer: DE
Explanation:
Reference: https://docs.oracle.com/database/121/ADMQS/GUID-1DE547D1-3AF0-4269-8BAA-4C298EC05905.htm#GUID-1DE547D1-3AF0-4269-8BAA-4C298EC05905 Reference: https://docs.oracle.com/database/121/ADMQS/GUID-1DE547D1-3AF0-4269-8BAA-4C298EC05905.htm#GUID-1DE547D1-3AF0-4269-8BAA-4C298EC05905
Question 8
orcl.dmp contains a full export of the ORCL database.
This command is executed to load data from orcl.dmp into the TESTDB database:
Which two are true? (Choose two.)
- It skips only tables that exist in both ORCL:SH and TESTDB:HR.
- It drops and recreates tables that exist in both ORCL:SH and TESTDB:HR.
- It skips all indexes of ORCL:SH and ORCL:OE.
- It skips only indexes that exist in both ORCL:SH and TESTDB:HR.
- It drops and re-creates indexes that exist in both ORCL:SH and TESTDB:HR.
Correct answer: DE
Question 9
Which is true about roles?
- A role can be granted to other roles.
- Roles can be created only by SYS or SYSTEM.
- Roles containing object privileges can be created only by the object owner.
- All roles belong to the SYSTEM schema.
- A role can be password-protected only if it has been granted system privileges.
Correct answer: E
Question 10
Your database is configured for shared server and the SGA_TARGET parameter is set to a non-zero value.
Which three actions could help in handling a large number of concurrent users?
- using Automatic SGA Memory Management (ASMM)
- setting the LARGE_POOL_SIZE parameter to a non-zero value
- increasing the size of the PGA
- setting the SHARED_POOL_SIZE parameter to a non-zero value
- increasing the number of dispatchers
Correct answer: BCD
