Download Oracle Database 12cR2 Administration.1z0-072.ActualTests.2019-10-15.42q.vcex
| Vendor: | Oracle |
| Exam Code: | 1z0-072 |
| Exam Name: | Oracle Database 12cR2 Administration |
| Date: | Oct 15, 2019 |
| File Size: | 355 KB |
How to open VCEX files?
Files with VCEX extension can be opened by ProfExam Simulator.
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
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!