Download Oracle Database 12cR2 Administration.1z0-072.NewDumps.2020-12-29.80q.vcex

Vendor: Oracle
Exam Code: 1z0-072
Exam Name: Oracle Database 12cR2 Administration
Date: Dec 29, 2020
File Size: 1 MB
Download Exam

How to open VCEX files?

Files with VCEX extension can be opened by ProfExam Simulator.

Download
ProfExam Simulator

Purchase
Coupon: EXAMFILESCOM

Discount: 20%

ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator

Demo Questions

Question 1
The ORCL database has DEFERRED_SEGMENT_CREATION set to TRUE. 
UNDOTBS2 is the active undo tablespace. 
Examine these commands:
  
USER1 executes DML, which generates more than 2 MB of UNDO. 
What is the result and why?
  1. It suspends the transaction, which can be resumed by increasing the size of UNDOTBS2.
  2. It returns an error because UNDOTBS2 is fixed size and has RETENTION GUARANTEE.
  3. It suspends the transaction, which can be resumed by increasing USER1’s quota on UNDOTBS2.
  4. It returns an error because UNDOTBS2 has RETENTION GUARANTEE.
  5. It suspends the transaction, which can be resumed by setting UNDOTBS1 as the active undo tablespace.
  6. It returns an error because UNDOTBS2 is fixed size.
Correct answer: F
Question 2
Which three failures require intervention for recovery? (Choose three.)
  1. a user error such as dropping the wrong table
  2. network interface card (NIC) failure
  3. user process failure
  4. statement failure
  5. media failure 
Correct answer: ACE
Explanation:
Question 3
Which three are true about Oracle Managed Files (OMF)? (Choose three.)
  1. If DB_CREATE_FILE_DEST is specified but DB_CREATE_ONLINE_LOG_DEST_n is not, the redo logs and control files are placed in DB_CREATE_FILE_DEST by default.
  2. If DB_RECOVERY_FILE_DEST is specified, at least two different locations must be specified for DB_CREATE_ONLINE_LOG_DEST_n.
  3. If only DB_CREATE_FILE_DEST is specified, only the data files and temp files are OMF.
  4. If DB_RECOVERY_FILE_DEST is specified but DB_CREATE_ONLINE_LOG_DEST_n is not, the redo logs and control files are placed in DB_RECOVERY_FILE_DEST by default.
  5. If DB_CREATE_ONLINE_LOG_DEST_1 is specified but DB_CREATE_FILE_DEST is not, the data files and temp files are placed in DB_CREATE_ONLINE_LOG_DEST_1 by default.
  6. If only DB_CREATE_ONLINE_LOG_DEST_n is specified, only the redo logs and control files are OMF.
Correct answer: ABF
Question 4
Your client application and Oracle database are located on different hosts. 
Which statement is true about establishing a connection between them?
  1. Oracle Connection Manager must be installed on the client.
  2. Net service names must be configured on both the client and database servers.
  3. The Listener Control utility must be installed on the client if you are using the default listener on the server.
  4. Only Oracle Net can be used.
  5. Oracle Net Listener is required.
Correct answer: D
Explanation:
Reference: https://docs.oracle.com/cd/E25178_01/server.1111/e25789/dist_pro.htm
Reference: https://docs.oracle.com/cd/E25178_01/server.1111/e25789/dist_pro.htm
Question 5
In the ORCL database, USER1 has unlimited quota on TBS1 and TBS2.  
The USER1.EMP table with primary key EMP_ENO_PK resides in TBS1.  
USER1.EMP_IDX residing in TBS2 is an index on U1.EMP.ENAME. 
TBS1 is exported from ORCL by using this command:
  
The TESTDB database has a TBS1 tablespace but no TBS2. 
The SYSTEM user in TESTDB executes this command:
  
What is the result and why?
  1. It imports EMP, EMP_ENO_PK, and the unique index associated with EMP_ENO_PK and EMP_IDX.
  2. It imports only EMP, EMP_ENO_PK, and the unique index associated with EMP_ENO_PK.
  3. It fails because TESTDB has TBS1.
  4. It imports only EMP.
  5. It fails because TESTDB does not have TBS2 to create EMP_IDX.
Correct answer: B
Question 6
In your database, you create a user, HR, and then execute this command:
  
Which three actions can HR perform? (Choose three.)
  1. Grant the CREATE SESSION privilege without ADMIN OPTION to other users.
  2. Grant the CREATE SESSION privilege with ADMIN OPTION to other users.
  3. Execute DML statements in the HR schema.
  4. Log in to the database instance.
  5. Revoke the CREATE SESSION privilege from other users.
  6. 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 7
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?
  1. The INCLUDING CONTENTS AND DATAFILES clause must be added to the command. 
  2. TBS1 must be placed in READ ONLY state.
  3. Objects in TBS1 must not be in use when the command is executed.
  4. TBS1 must not contain any temp files. 
  5. 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 8
Which three types of files are created by expdp operations? (Choose three.)
  1. SQL files
  2. dump files
  3. reject files
  4. log files
  5. input data files
  6. bad files
  7. 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 9
DATADIR1 and DATADIR2 are database directory objects. 
Examine this command:
  
Which two are true about the expdp operation? (Choose two.)
  1. It creates a dump file for the entire database.
  2. It fails if the total size of the dump file is more than 2 GB.
  3. It creates a dump file only for objects in the SYSTEM schema.
  4. It creates a master table to store details of the export operation.
  5. 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 10
Which statement is true about smallfile tablespaces?
  1. Extent location metadata is stored in the data dictionary by default.
  2. The number of data files is constrained only by the size of the storage array.
  3. Maximum file size can be set to unlimited only if the logical volume manager supports striping.
  4. Segments can span multiple tablespaces.
  5. 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
CONNECT US
HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset

HOW TO OPEN VCEX AND EXAM FILES

Use ProfExam Simulator to open VCEX and EXAM files
ProfExam Screen

ProfExam
ProfExam at a 20% markdown

You have the opportunity to purchase ProfExam at a 20% reduced price

Get Now!