单选题Examine the following values of the initialization parameters in the database having the SID ORCL：   BACKGROUND_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/bdump USER_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/udump CORE_DUMP_DEST=/u01/app/oracle/

ExaminethecommandsexecutedinaDBAsession：SQL>CREATEBIGFILETABLESPACEMRKT2DATAFILE’/u01/app/oracle/oradata/orcl/mrkt.dbf’size10MLOGGING3EXTENTMANAGEMENTLOCALSEGMENTSPACEMANAGEMENTAUTO；Tablespacecreated.SQL>ALTERDATABASEDEFAULTTABLESPACEMRKT；Databasealtered.WhichtwostatementsaretrueregardingtheMRKTtablespace（）

A.Nomoredatafilescanbeaddedtothetablespace.

B.Segmentspaceismanagedbyfreelistsinthetablespace.

C.Ausercreatedwithoutbeingassignedadefaulttablespaceusesthistablespace.

D.Thetablespacecanbedroppedwiththecurrentsettingwithsegmentspresentinit

Examine the following values of the initialization parameters in the database having the SID ORCL:BACKGROUND_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/bdumpUSER_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/udumpCORE_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/cdumpDIAGNOSTIC_DEST=The environment variables have the following value:ORACLE_BASE=/u01/app/oracleORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1What is the location of the Automatic Diagnostic Repository (ADR) home?（）

A./u01/app/oracle/product/11.1.0/db_1

B./u01/app/oracle

C.$ORACLE_HOME/bdump

D.$ORACLE_HOME/log

A. The ‘/u01/app/oracle/oradata/orcl/users01.dbf‘ data file is recovered from the image copy

B. The ‘/u01/app/oracle/oradata/orcl/users01.dbf‘ data file is recovered from the last incremental backup

C. Image copies of the ‘/u01/app/oracle/oradata/orcl/users01.dbf‘ data file are updated with all changes up to incremental backup SCN. ‘/ u01/app/oracle/oradata/orcl/users01.dbf

D. Image copies of the ‘/u01/app/oracle/oradata/orcl/users01.dbf‘ data file are recovered using the above command if data file recovery fails

Youhavecontrol-fileautobackupsenabled.WhenstartingyourdatabasefromSQL*Plus，youreceivethefollowingerrormessage：SQL>startupORA-01078：failureinprocessingsystemparametersLRM-00109：couldnotopenparameterfile，C：\ORACLE\PRODUCT\11.1.0\DB_1\DATABASE\INITORCL.ORAUsingRMAN，howwouldyourespondtothiserror？（）

A.Issuethestartupnomountcommandandthenissuetherestoreparameterfilecommandfromthe RMANprompt.

B.IssuethestartupnomountcommandandthenissuetherestorespfilecommandfromtheRMANprompt.

C.Issuethestartupnomountcommandandthenissuetherestorespfilefromautobackupcommand fromtheRMANprompt.

D.Issuethestartupnomountcommandandthenissuetherestorespfilefrombackupcommand from theRMANprompt.

E.IssuetherestorespfilefromautobackupcommandfromtheRMANprompt.

WhenyoutrytostarttheDatabaseControlbyusingtheemctlstartdbconsolecommandthefollowingerrorisdisplayed：TZsettoAmerica/New_yorkOC4JConfigurationissue./u01/app/oracle/product/10.1.0/db_1/oc4j/j2ee/OC4J_DBConsole_orcl.us.oracle.comnotfound.WhichtwoenvironmentvariablesdoyouneedtosetappropriatelytoavoidsucherrorsandstarttheDatabaseControlsuccessfully？（）

A.NLS_LANG

B.ORACLE_SID

C.ORACLE_HOME

D.ORACLE_BASE

E.LD_LIBRARY_PATH

Youwanttocheckthedetailsoffewerrorsthatusershavereported.Yousearchforthealertlogfileandexecutefewcommandstofindthelocationofthealertlogfile.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

A.TheOraclekernelwillbeplacedinthislocation.

B.TheOraclesoftwarewillbeplacedinthislocation.

C.Theserverparameterfile（SPFILE）willbeplacedinthislocation.

D.Thedatabasefileswillbeplacedinthislocation，ifnotspecifiedexplicitly.

E.ThelocationwillbeconsideredforthebaseofOracleManagedFiles（OMF）.

F.ThelocationwillbeconsideredforthebaseofOptimalFlexibleArchitecture（OFA）.

A. The path to the location of the background as well as the foreground process trace files is /u01/oracle/diag/rdbms/orclbi/orclbi/trace.

B. The location of the text alert log file is /u01/oracle/diag/rdbms/orclbi/orclbi/alert.

C. The location of the trace file for the current session is /u01/oracle/diag/rdbms/orclbi/orclbi/trace.

D. The location of the XML-formatted version of the alert log is /u01/oracle/diag/rdbms/orclbi/orclbi/alert.

Youralertlogfilehasthefollowinginformation：TueMay2517：43：382004ORA-00060：Deadlockdetected.Moreinfoinfile/u01/app/oracle/admin/ORCL/udump/orcl_ora_3173.trc.Whatwouldyoudotoensurethatdatabaseisstillrunningcorrectly？（）

A.examinethetracefileandkillthesessionthatcausedthedeadlock

B.examinethetracefileandkillboththesessionsresponsibleforthedeadlock

C.examinethetracefilefordetailsandasktheuserwhocausedthedeadlocktorollbackthetransaction

D.examinethetracefilefordetailsandrememberthatdeadlocksareresolvedautomaticallybyOracledatabase

E.examinethetracefilefordetailsandusetheUndoAdvisortorollbackthetransactionthatcausedthedeadlock

Youmanuallycreateanadditionallistenerprocess，L1，fordatabasesPROD，

PAYDBandFINDB.Whilestartingupthelistenerprocess，yougetthefollowingerrormessage：LSNRCTL>startl1

Starting/u01/app/oracle/product/10.1.0/db_1/bin/tnslsnr：pleasewait...

TNSLSNRforLinux：Version10.1.0.2.0-Production

Systemparameterfileis/u01/app/oracle/product/10.1.0/db_1/network/admin/listener.oraLogmessageswrittento/u01/app/oracle/product/10.1.0/db_1/network/log/l1.logErrorlisteningon：

（ADDRESS=（PROTOCOL=TCP）（HOST=144.23.230.185）（port=8899））

TNS-12542：TNS：addressalreadyinuseTNS-12560：

TNS：protocoladaptererrorTNS-00512：Addressalreadyinuse

LinuxError：98：Addressalreadyinuse

Listenerfailedtostart.Seetheerrormessage（s）above...

Whatactionwouldyoutaketoovercomethiserrorwithoutdisruptinganyexistingdatabasecommunications？（）