风险只能由标准差和标准差率来衡量。（)A．正确B．错误

t;ALTER TABLESPACE lmtemp SHRINK SPACE KEEP 20M;Which requirement must be fulfilled for this command to succeed?（）

A. The tablespace must be locally managed.

B. The tablespace must have only one temp file.

C. The tablespace must be made nondefault and offline.

D. The tablespace can remain as the default but must have no active sort operations.

YouhavelostallyourRMANbackupsetpiecesduetoadiskfailure.Unfortunately，youhaveanautomatedcross-checkscriptthatalsodoesadeleteexpiredbackupsetcommand.Youhaverestoredallthebackupsetpiecesfromtape.Whatcommandwouldyouusetogetthosebackupsetpiecesregisteredintherecoverycatalogandthecontrolfileofthedatabaseagain？（）

A.registerdatabase

B.recovercatalog

C.loadbackupset

D.synchmetadata

E.catalogstartwith

A. in the INTO clause of an INSERT statement

B. in the FROM clause of a SELECT statement

C. in the GROUP BY clause of a SELECT statement

D. in the WHERE clause of a SELECT statement

E. in the SET clause of an UPDATE statement

F. in the VALUES clause of an INSERT statement

Youfindtoday’sperformanceofyourproductiondatabasetobethebestever.Therefore，youwanttobenotifiedinthefuturewhenevertheperformancedegradesby10%oftoday’sperformance.Whatisthefirststepthatyouwouldtaketoensurethis？（）

A.createbaselinemetricsfortoday’sperformance

B.writethecurrentdatabasemetricstoadatabasetableandcreateatriggertocomparewithfuturedatabasestatistics

C.writethecurrentdatabasemetricstoaflatfileandcreateanoperatingscripttocomparewithfuturedatabasestatistics

D.writethecurrentdatabasemetricstoadatabasetableandcreateaproceduretocomparewithfuturedatabasestatistics

E.writethecurrentdatabasemetricstoadatabasetableandsubmitajobusingDBMS_JOBtocomparewithfuturedatabasestatistics

for the database instance. To repair the failure, you executed the following as the first command in the RMAN session:RMAN> REPAIR FAILURE;Which statement describes the consequence of the command?（）

A. The command performs the recovery and closes the failures.

B. The command only displays the advice and the RMAN script required for repair.

C. The command produces an error because the ADVISE FAILURE command has not been executed before the REPAIR FAILURE command.

D. The command executes the RMAN script to repair the failure and removes the entry from the Automatic Diagnostic Repository (ADR).

A.Line 26 prints "a" to System.out.

B.Line 26 prints "b" to System.out.

C.An exception is thrown at line 26 at runtime.

D.Compilation of class A will fail due to an error in line 6.

cutefewcommandstofindthelocationofthealertlogfile.ViewtheExhibitandcheckthecommandsexecuted.Whatisthelocationofthealert_orcl.logfile（）

A.ORACLE_HOME/dbs

B.ORACLE_HOME/rdbms

C./u01/app/oracle/admin/orcl/adump

D./u01/app/oracle/flash_recovery_area

E.ORACLE_BASE/diag/rdbms/orcl/orcl/alert

F.ORACLE_BASE/diag/rdbms/orcl/orcl/trace

Inyourtestdatabase，youhavecreatedtheORDERStableasanindex-organizedtable（IOT）.Tofacilitatefasterquerying，youhavecreatedamappingtableandabitmapindexontheORDER_FILLEDcolumn.Youobservethatthequeryperformancedegradeswhenusersperformalargevolumeoftransactions.Whileinvestigatingthereason，youfindthatthemappingtablesegmentisfragmented，leadingtopoorperformance.Whichoptionwouldyouusetodefragmentthemappingtablewithoutaffectingtheoriginaltabledata？（）

A.exportandimportthemappingtable

B.dropandre-createthemappingtable

C.truncatethemappingtableandreinsertthevalues

D.usetheALTERTABLE···REBUILDcommandtodefragmentthemappingtable

A.synchcatalog

B.resynccatalog

C.replicatecatalog

D.updatecatalog

E.restorecatalog

A.crosscheck

B.listbackup

C.confirm

D.resync

E.backupvalidate