其他类 - Oracle认证考试

单选题

YourdatabaseisinARCHIVELOGmode.Youhavetwoonlineredologgroups,eachofwhichcontainsoneredomember.Whenyouattempttostartthedatabase,youreceivethefollowingerrors: Whichstatementshouldyouusetoresolvethisissue?（）

ALTERDATABASEDROPLOGFILEGROUP1;
B. ALTERDATABASECLEARLOGFILEGROUP1;
C. ALTERDATABASECLEARUNARCHIVEDLOGFILEGROUP1;
D. ALTERDATABASEDROPLOGFILEMEMBER'D:\REDO01.LOG';

查看答案

多选题

Identify the persistent configuration setting for the target database that can be set for the backup by using RMAN.（）

A. Backup retention policy
B. Default backup device type
C. Default destinations for backups
D. Multiple backup device types for single backup
E. Default section size for backups

查看答案

单选题

Given: Whatistheresult?（）

A. abc
B. 123
C. a1b2c3
D. a1
E. Compilationfails.
F. Thecoderunswithnooutput.
G. Anexceptionisthrownatruntime

查看答案

多选题

ExaminethesectionoftheHealthCheckreportgivenbelow: WhichtwostatementsaretrueregardingtheHealthCheckreport?（）

A. HealthCheckwasperformedmanually.
B. HealthCheckwasperformedtocheckthediskimageblockcorruptions.
C. HealthCheckwasperformedtocheckinterblockandintersegmentcorruption.
D. HealthCheckwasperformedtoverifytheintegrityofdatabasefilesandreportfailures.
E. HealthCheckwasperformedbytheHealthMonitorautomaticallyinresponsetoacriticalerror.

查看答案

多选题

Which three functions are performed by the SQL Tuning Advisor？（）

A. Building the SQL profile
B. Recommending optimization of materialized views
Checking query objects for missing and stale statistics
D. Recommending bitmap， function-based， and B-tree indexes
E. Recommending restructuring SQL queries that are using bad plans

查看答案

单选题

YouareworkingonaCATDBdatabasethatcontainsanOracleDatabaseversion11.1catalogschemaownedbytheuserRCO11.TheINST1databasecontainsanOracleDatabaseversion10.1catalogschemaownedbytheuserRCAT10. YouwanttheRMANtoimportmetadatafordatabaseIDs1423241and1423242,registeredinRCAT10,intotherecoverycatalogownedbyRCO11.Youalsowanttoderegisterthemfromthecatalogafterimport. Youexecutedthefollowingcommandstoachievethis: WhathappensiftheRCO11cataloghasscriptswiththesamenameasthatofthescriptsinRCAT10catalog?（）

A. ThescriptsintheRCO11catalogareoverwritten.
B. RMANrenamesthelocalstoredscriptsintheRCO11catalog.
C. TheRMANsessioninwhichthecommandisexecutedaborts.
D. RMANrenamestheglobalscriptsthatareimportedfromtheRCAT10catalog.

查看答案

单选题

Given: Whatistheresult?（）

A. 0
B. 1
C. 2
D. 3
E. 4
F. Compilationfails.
G. Anexceptionisthrownatruntime.

查看答案

单选题

Considerthefollowingscenarioforyourdatabase: WhichstatementistrueregardingthebackupoftheTOOLStablespace?（）

A. TheRMANbackupfailsbecausetheTOOLStablespaceisread-only
B. TheRMANskipsthebackupofthetablespacebecausebackupoptimizationisenabled
C. TheRMANmakesbackupbecauseoptimizationcanbeenabledonlyforbackupstodisk
D. TheRMANmakesthebackupbecausenobackupofthetablespaceexistswithinthesevendaywindow

查看答案

单选题

ViewtheExhibittoexaminethemetricswithathreshold.WhichstatementistrueregardingtheNumberofTransactions(persecond)metric?（）

A. Oracleusesstatisticalrelevancetodeterminewhenanadaptivethresholdhasbeenbreachedforthemetric.
B. Thestatisticsforthemetricvaluesobservedoverthebaselinetimeperiodarenotexaminedtodeterminethresholdvalues.
C. Oracledetermineswhenanadaptivethresholdhasbeenbreachedbasedonthemaximumvaluecapturedbythebaseline.
D. Thetotalconcurrentnumberofthresholdviolations,whichmustoccurbeforeanalertisraisedforthemetric,hasbeensettozero.

查看答案

单选题

Given: Whichcode,insertedatline4,guaranteesthatthisprogramwilloutput[1,2]（）?

A. Setset=newTreeSet();
B. Setset=newHashSet();
C. Setset=newSortedSet();
D. Listset=newSortedList();
E. Setset=newLinkedHashSet();

查看答案