其他类 - Oracle认证考试

单选题

ViewtheExhibitthatsetsthethresholdfortheCurrentOpenCursorsCountmetric.WhyistheSignificanceLevelthresholdtypenotavailableinthethresholdsetting?（）

A. becauseAWRbaselineisnotenabled
B. becauseCurrentOpenCursorsCountisnotabasicmetric
C. becausetheSTATISTICS_LEVELparameterissettoBASIC
D. becausetheAWRbaselineisasystem-definedmovingwindowbaseline

查看答案

单选题

YouareintheprocessofcreatingavirtualprivatecataloginyourOracleDatabase11gdatabase.ThePROD1,PROD2,andPROD3OracleDatabase10gdatabasesareregisteredinthebaserecoverycatalog.ThedatabaseuserwhoownsthebaserecoverycatalogisCATOWNER.CATOWNERexecutesthefollowingcommandtograntprivilegestoanewuserVPC1usingOracleDatabase11gRMANexecutables: Whatistheoutcomeoftheabovecommands?（）

A. Theyexecuteandcreateavirtualcatalogforpre-Oracle11gclients.
B. TheyproduceanerrorbecausePROD1andPROD2databasesbelongtotheolderversion.
C. TheyproduceanerrorbecauseyouneedtoconnectasCATOWNERtoexecutethispackagedprocedure.
D. Theyproduceanerrorbecauseyouneedtoconnecttothetargetdatabasetoexecutethispackagedprocedure.

查看答案

多选题

Which two client requests are captured during database replay Capture？（）

A. Flashback queries
B. Shared server requests
C. Login and logoff activities of sessions
Direct path load of data from external files by using utilities such as SQL *loader
E. Data definition language （DDL） and data manipulation language （DML） operations

查看答案

单选题

TheINV_HISTORYtableiscreatedusingthecommand: Youwouldliketostorethedatabelongingtotheyear2006inasinglepartitionandissuethecommand: Whatwouldbetheoutcomeofthiscommand?（）

A. Itexecutessuccessfully,andthetransitionpointissetto'1-apr-2006'.
B. Itexecutessuccessfully,andthetransitionpointissetto'15-apr-2006'.
C. Itproducesanerrorbecausethepartitionsspecifiedformergingarenotadjacent.
D. Itproducesanerrorbecausethedatevaluesspecifiedinthemergedonotmatchthedatevaluesstoredinthetable.

查看答案

单选题

YoucreateanewAutomaticDatabaseDiagnosticMonitor(ADDM)task:instance_analysis_mode_task.ToviewtheADDMreport,youusethefollowingcommand: YouwanttosuppressADDMoutputrelatingtoSegmentAdvisoractionsonuserSCOTT'ssegments.Whatwouldyoudotoachievethis?（）

AddafindingdirectivefortheADDMtask.
B. AddasegmentdirectivefortheADDMtask.
C. AddaparameterdirectivefortheADDMtask.
DisabletheSegmentAdvisorfromtheAutomaticMaintenanceTask.

查看答案

单选题

Given: Whatistheresult?（）

A. B
B,followedbyanException.
Compilationfailsduetoanerroronline9.
D. Compilationfailsduetoanerroronline14.
E. AnExceptionisthrownwithnootheroutput.

查看答案

多选题

ViewtheExhibitandexaminetheresourceconsumptiondetailsforthecurrentplaninusebythedatabaseinstance.Whichtwostatementsaretruebasedontheoutput?（）

AnattempttostartanewsessionbytheuserbelongingtoDSS_QUERIESfailswithanerror
B. AuserbelongingtoDSS_QUERIEScanlogintoanewsessionbutthesessionwillbequeued
C. TheCPU_WAIT_TIMEcolumnindicatesthetotaltimethatsessionsintheconsumergroupwaitedfortheCPUduetoresourcemanagement.
D. TheCPU_WAIT_TIMEcolumnindicatesthetotaltimethatsessionsintheconsumergroupwaitedfortheCPUduetoresourcemanagement,I/Owaits,andlatchorenqueuecontention

查看答案

多选题

YouareworkingonaCATDBdatabasethatcontainsanOracleDatabaseversion11.1catalogschemaownedbytheuserRCO11.TheINST1databasecontainsanOracleDatabaseversion10.1catalogschemaownedbytheuserRCAT10.YouwanttheRMANtoimportmetadatafordatabaseIDs1423241and1423242,registeredinRCAT10,intotherecoverycatalogownedbyRCO11. Youexecutedthefollowingcommands: Whichtwostatementsaretrueregardingthetasksaccomplishedwiththesecommands?（）

A. TheyimportallmetadatafromtheRCAT10catalog.
B. TheyunregisterthedatabasefromtheRCAT10catalog.
C. TheydonotregisterthedatabasesregisteredintheRCAT10catalog.
D. TheyregisteralldatabasesregisteredintheRCAT10catalog.

查看答案

单选题

Given: Whatistheresult?（）

A. testend
B. Compilationfails.
C. testruntimeend
D. testexceptionend
E. Throwableisthrownbymainatruntime.

查看答案

多选题

Youareusingtheflashrecoveryarea(fastrecoveryareain11gRelease2)tostorebackuprelatedfilesinyourdatabase.AfterregularmonitoringofspaceusageintheMashrecoveryarea.Yourealizethattheflashrecoveryareaisjettingfilledupveryfastanditisrunningoutofspace.Yourdatabaseflashrecoveryareaislowonspaceandyouhavenomoreroomondisk. Proactively,whichtwooptionscouldyouusetomakemorespaceavailableintheflashrecovery？（）

A. ChangetheRMANarchivedlogdeletionpolicy
B. UsetheRMANCROSSCHECKcommandtoreclaimthearchivedlogspace
ChangetheRMANretentionpolicytoretainbackupsforashorterperiodoftime
D. UseOScommandtomovefilesfromtheflashrecoveryareatosomeotherlocation

查看答案