YouworkasadatabaseadministratorforSupportcenter.cn.InyourOracledatabase10ginstallationyouhavesetORACLE_BASEto／u01／app／oracle.Whichobjectivewillbeachievedbythissetting?()A.TheOraclekernelwillbeplacedinthislocation.B.TheOraclesoftwarewillbeplacedinthislocat

题目
YouworkasadatabaseadministratorforSupportcenter.cn.InyourOracledatabase10ginstallationyouhavesetORACLE_BASEto／u01／app／oracle.Whichobjectivewillbeachievedbythissetting?()

A.TheOraclekernelwillbeplacedinthislocation.

B.TheOraclesoftwarewillbeplacedinthislocation.

C.Theserverparameterfile（SPFILE）willbeplacedinthislocation.

D.Thedatabasefileswillbeplacedinthislocation，ifnotspecifiedexplicitly.

E.ThelocationwillbeconsideredforthebaseofOracleManagedFiles（OMF）.

F.ThelocationwillbeconsideredforthebaseofOptimalFlexibleArchitecture（OFA）.

相似考题

1.You executed the following command:RMAN> RECOVER COPY OF DATAFILE ‘／u01／app／oracle／oradata／orcl／users01.dbf‘;Which statement regarding the above command is correct?()A. The ‘/u01/app/oracle/oradata/orcl/users01.dbf‘ data file is recovered from the image copyB. The ‘/u01/app/oracle/oradata/orcl/users01.dbf‘ data file is recovered from the last incremental backupC. 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.dbfD. Image copies of the ‘/u01/app/oracle/oradata/orcl/users01.dbf‘ data file are recovered using the above command if data file recovery fails

2.Youwanttocheckthedetailsoffewerrorsthatusershavereported.Yousearchforthealertlogfileandexecutefewcommandstofindthelocationofthealertlogfile.ViewtheExhibitandcheckthecommandsexecuted.Whatisthelocationofthealert_orcl.logfile（）A.ORACLE_HOME/dbsB.ORACLE_HOME/rdbmsC./u01/app/oracle/admin/orcl/adumpD./u01/app/oracle/flash_recovery_areaE.ORACLE_BASE/diag/rdbms/orcl/orcl/alertF.ORACLE_BASE/diag/rdbms/orcl/orcl/trace

3.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_1B./u01/app/oracleC.$ORACLE_HOME/bdumpD.$ORACLE_HOME/log

4.ExaminethecommandsexecutedinaDBAsession：SQL>CREATEBIGFILETABLESPACEMRKT2DATAFILE’/u01/app/oracle/oradata/orcl/mrkt.dbf’size10MLOGGING3EXTENTMANAGEMENTLOCALSEGMENTSPACEMANAGEMENTAUTO；Tablespacecreated.SQL>ALTERDATABASEDEFAULTTABLESPACEMRKT；Databasealtered.WhichtwostatementsaretrueregardingtheMRKTtablespace（）A.Nomoredatafilescanbeaddedtothetablespace.B.Segmentspaceismanagedbyfreelistsinthetablespace.C.Ausercreatedwithoutbeingassignedadefaulttablespaceusesthistablespace.D.Thetablespacecanbedroppedwiththecurrentsettingwithsegmentspresentinit

更多“YouworkasadatabaseadministratorforSupportcenter.cn.InyourOracledatabase10ginstallationyouhavesetORACLE_BASEto／u01／app／oracle.Whichobjectivewillbeachievedbythissetting?() ”相关问题

  • 第1题：

    Williamspecifiedthefollowinginitializationparametersettingsinthepfile：BACKGROUND_DUMP_DEST=’u01\oradata\dir_A’USER_DUMP_DEST=’u01\oradata\dir_B’DB_CREATE_FILE_DEST=’u01\oradata\dir_C’DB_CREATE_ONLINE_LOG_DEST_n=’u01\oradata\dir_D’Williamenabledthechange-trackingfeaturebecausehedoesnotwanttoscantheentiredatafileduringbackup.Whatisthedefaultstoragelocationforthechangetrackingfile？（）

    A.’u01\oradata\dir_A’

    B.’u01\oradata\dir_B’

    C.’u01\oradata\dir_C’

    D.’u01\oradata\dir_D’


    参考答案：C

  • 第2题：

    Youmanuallycreateanadditionallistenerprocess,L1,for&en

    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？（）


    参考答案：D

  • 第3题：

    YouworkasadatabaseadministratorforCertkiller.com.InyourOracledatabase10ginstallationyouhavesetORACLE_BASEto／u01／app／oracle.Whichobjectivewillbeachievedbythissetting?()

    A.TheOraclekernelwillbeplacedinthislocation.

    B.TheOraclesoftwarewillbeplacedinthislocation.

    C.Theserverparameterfile（SPFILE）willbeplacedinthislocation.

    D.Thedatabasefileswillbeplacedinthislocation，ifnotspecifiedexplicitly.

    E.ThelocationwillbeconsideredforthebaseofOracleManagedFiles（OMF）.

    F.ThelocationwillbeconsideredforthebaseofOptimalFlexibleArchitecture（OFA）.


    参考答案：F

  • 第4题：

    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


    参考答案：D

  • 第5题：

    Youexecutedthefollowingcommand:RMAN>RECOVERCOPYOFDATAFILE’／u01／app／oracle／oradata／orcl／users01.dbf’;Whichstatementregardingtheabovecommandiscorrect?()

    A.The’/u01/app/oracle/oradata/orcl/users01.dbf’datafileisrecoveredfromtheimagecopy.

    B.The’/u01/app/oracle/oradata/orcl/users01.dbf’datafileisrecoveredfromthelastincrementalbackup.

    C.Imagecopiesofthe’/u01/app/oracle/oradata/orcl/users01.dbf’datafileareupdatedwithallchangesuptoincrementalbackupSCN.

    D.Imagecopiesofthe’/u01/app/oracle/oradata/orcl/users01.dbf’datafilearerecoveredusingtheabovecommandifdatafilerecoveryfails.


    参考答案：C

相关内容