Download Oracle Database 12cR2 Administration.1z0-072.Dump4Pass.2020-12-29.80q.tqb
| Vendor: | Oracle |
| Exam Code: | 1z0-072 |
| Exam Name: | Oracle Database 12cR2 Administration |
| Date: | Dec 29, 2020 |
| File Size: | 2 MB |
How to open TQB files?
Files with TQB (Taurus Question Bank) extension can be opened by Taurus Exam Studio.
Purchase
Coupon: TAURUSSIM_20OFF
Discount: 20%
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?
- It suspends the transaction, which can be resumed by increasing the size of UNDOTBS2.
- It returns an error because UNDOTBS2 is fixed size and has RETENTION GUARANTEE.
- It suspends the transaction, which can be resumed by increasing USER1’s quota on UNDOTBS2.
- It returns an error because UNDOTBS2 has RETENTION GUARANTEE.
- It suspends the transaction, which can be resumed by setting UNDOTBS1 as the active undo tablespace.
- It returns an error because UNDOTBS2 is fixed size.
Correct answer: F
Question 2
Which three failures require intervention for recovery? (Choose three.)
- a user error such as dropping the wrong table
- network interface card (NIC) failure
- user process failure
- statement failure
- media failure
Correct answer: ACE
Question 3
Which three are true about Oracle Managed Files (OMF)? (Choose three.)
- 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.
- If DB_RECOVERY_FILE_DEST is specified, at least two different locations must be specified for DB_CREATE_ONLINE_LOG_DEST_n.
- If only DB_CREATE_FILE_DEST is specified, only the data files and temp files are OMF.
- 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.
- 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.
- 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?
- Oracle Connection Manager must be installed on the client.
- Net service names must be configured on both the client and database servers.
- The Listener Control utility must be installed on the client if you are using the default listener on the server.
- Only Oracle Net can be used.
- 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?
- It imports EMP, EMP_ENO_PK, and the unique index associated with EMP_ENO_PK and EMP_IDX.
- It imports only EMP, EMP_ENO_PK, and the unique index associated with EMP_ENO_PK.
- It fails because TESTDB has TBS1.
- It imports only EMP.
- It fails because TESTDB does not have TBS2 to create EMP_IDX.
Correct answer: B
HOW TO OPEN VCE FILES
Use VCE Exam Simulator to open VCE files
HOW TO OPEN VCEX FILES
Use ProfExam Simulator to open VCEX files
ProfExam at a 20% markdown
You have the opportunity to purchase ProfExam at a 20% reduced price
Get Now!