【C8】A．decreaseB．declineC．reductionD．release

A. It executes successfully but partition pruning cannot happen for this partition key.

B. It produces an error because the TOTAL_VALUE column cannot be used as a partition key.

C. It produces an error because compression cannot be used for the TOTAL_VALUE partition key.

D. It executes successfully but the values in the TOTAL_VALUE column would not be physically stored in the partitions.

A.Thedatabaseopensnormally.

B.Thedatabasepromptsforadatabaserecovery.

C.Thedatabasewriterwritestoatracefile，indicatingthatthetemporaryfileisnotfound.

D.Thedatabasegetsmountedandthrowsanerrorindicatingthatthetemporaryfilerequiresrecovery.

A.00

B.0001

C.000120

D.00012021

E.Compilation fails.

F.An exception is thrown at runtime.

A.Itwouldresultinanerrorbecausethewarningthresholdcannotbemorethanthecriticalthreshold.

B.Thewarningthresholdisignoredandalertswouldbegeneratedwhenspaceusageexceedsthecriticalthreshold.

C.Thecriticalthresholdisignoredandalertswouldbegeneratedwhenspaceusageexceedsthewarningthreshold.

D.Boththresholdvaluesareusedandalertsaregeneratedwhenspaceusageexceedstherespectivethresholdvalues.

A. The MEMORY_MAX_TARGET parameter is automatically set to 500 MB

B. The value of the MEMORY_MAX_TARGET parameter remains zero till it is changed manually

C. The PGA_AGGREGATE_TARGET and SGA_TARGET parameters are automatically set to zero

D. The lower bounds of PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to 90 MB and 270 MB, respectively

.YouobservethatthereareseveralwarningalertsbeinggeneratedfortheAPPStablespacespaceusagemetrics.Currently，thewarningthresholdforthetablespacespaceusagemetricsissetto70%.Tomakethegeneratedalertsmoreusefulasaproblemidentificationtool，youwanttoreducethefrequencyofalertgenerationforthetablespacespaceusagemetricsfortheAPPStablespace.Whatshouldyoudo？（）

A.disableSQLtracingfortheAPPStablespace

B.disableloggingattributefortheAPPStablespace

C.modifythetablespacetobeadictionarymanagedtablespace

D.increasethecriticalthresholdvalueforthetablespacespaceusagemetricsfortheAPPStablespace

E.increasethewarningthresholdvalueforthetablespacespaceusagemetricsfortheAPPStablespace

A.thealertlogfile

B.thecoredumpfiles

C.thechangetrackingfile

D.theusersessiontracefiles

E.thedatabaseaudittrailfiles

F.thebackgroundprocesstracefiles

A.The instance gets garbage collected.

B.The code on line 33 throws an exception.

C.The code on line 35 throws an exception.

D.The code on line 31 throws an exception.

E.The code on line 33 executes successfully.

Inyourtestdatabase，youfindthatauser’ssessionisexecutingalotofSQLstatements，resultinginthegenerationofalargenumberoftracefiles.Whileinvestigatingthereason，youfindthatSQLtracehasbeenenabledattheinstancelevel.YouwanttodisableSQLtrace，remotely，onlyforthatusersessiontoreducethevolumeoftracedatabeinggenerated.Howdoyouachievethisobjective？（）

A.bysettingtheSQL_TRACEparametertoFALSEintheparameterfile

B.byusingDBMS_MONITOR.SESSION_TRACE_DISABLEtodisablethetracingfortheusersession

C.bysettingtheSQL_TRACEparametertoFALSEbyusingtheALTERSYSTEMcommandintheusersession

D.bysettingtheSQL_TRACEparametertoFALSEbyusingtheALTERSESSIONcommandintheusersession

，someoftheinitializationparameterswerechangedduringruntimewithoutanycomments.Youhavebeenaskedtofindoutthevalueoftheparameterswhentheinstancewasstarted.Whichsourcewouldyouusetolocatethisinformation？（）

A.fixedviews

B.thealertlogfile

C.theparameterfile

D.theserverparameterfile

E.dynamicperformanceviews