1z0-074 Free Practice Test

You set the maximum size of the diagnostic collection repository by issuing this command asroot.tfact1 set reposizeMB=5120
You then notice that the current repository size is 5 GB and that old files are not being purged. Which statement is true?

1. A. Thetfact1command fails because it can be set only by the Oracle software owner.
2. B. TFA collects new diagnostic data if theMax Size of TFA Log parameter value is greater than 5 GB.
3. C. TFA does not collect new diagnostic data when the maximum repository size is reached.
4. D. TFA collects new diagnostic data but logs a warning message.
5. E. TFA collects new diagnostic data while the repository directory’s file system has free space.

Correct Answer: A

You log in to the ORCL database as SYSTEM and successfully execute these two blocks of code:
<>>

1. A. All their queries display blanks forLAST_NAMEand the true contents of theSALARYcolumn.
2. B. OnlySCOTT’Squeries display the true contents of theSALARYcolumn and blanks forLAST_NAME.
3. C. All their queries display blanks forLAST_NAMEand zeroes forSALARY.
4. D. OnlySCOTT’Squeries display the true contents of theSALARYandLAST_NAMEcolumns.
5. E. OnlySCOTT’Squeries display zero forSALARYand the true contents of theLAST_NAMEcolumn.

Correct Answer: A

TheORCLCDB has a PDB,ORCL_PDB.
Examine these parameters inORCL:
< ><>>< ><>><>

1. A. SGA_TARGETis set to 600M.The other values remain unchanged in bothORCLandORCL_PDB.
2. B. SGA_TARGETis set to 600M andDB_CACHE_SIZEto 200M inORCL_PD
3. C. The other values remain unchanged in bothORCLandORCL_PDB.
4. D. SGA_TARGETandSGA_MAX_SIZEare set to 600M andDB_CACHE_SIZEto 200M inORCL_PD
5. E. SGA_TARGETandSGA_MAX_SIZEare set to (1360-600)M andDB_CACHE_SIZEto 200M inORCL.
6. F. Altering theDB_CACHE_SIZEresults in an error becauseSGA_TARGETshould be altered to 600M first.
7. G. Altering theDB_CACHE_SIZEresults in an error because it cannot be altered in a PD
8. H. SGA_TARGETsize is changed to 600 M.

Correct Answer: D

Which two are true about the ADR retention advisor in Oracle Database 12c Release 2? (Choose two.)

1. A. ESTIMATE (SHORTP_POLICY = 192)estimates the space requirement based on theSHORTP_POLICYvalue of 192 minutes.
2. B. ESTIMATE (SHORTP_POLICY = 192, LONGP_POLICY = 2160)estimates the space requirement based on current ADR diagnostics file space usage.
3. C. ESTIMATE (SIZEP_POLICY = 209715200)estimates only the long retention policy.
4. D. ESTIMATE (SHORTP_POLICY = 192, LONGP_POLICY = 8760)provides estimates that users can use to setSIZEP_POLICY.
5. E. ESTIMATE (SIZEP_POLICY = 209715200)estimates the value ofLONGP_POLICY.

Correct Answer: DE

One of your databases supports an OLTP workload.
If a better plan is discovered for a statement, then you want that plan to be used. Which two can cause better plans to be used for a statement? (Choose two.)

1. A. adaptive cursor sharing
2. B. using literals in SQL statements
3. C. SQL Access Advisor
4. D. SQL Performance Analyzer
5. E. adaptive execution plans

Correct Answer: CE