单选题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/pr

题目
单选题
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/product/11.1.0/db_1/cdump DIAGNOSTIC_DEST= The environment variables have the following value: ORACLE_BASE=/u01/app/oracle ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1 What 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

相似考题

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.ExaminethecommandsexecutedinaDBAsession：SQL>CREATEBIGFILETABLESPACEMRKT2DATAFILE’/u01/app/oracle/oradata/orcl/mrkt.dbf’size10MLOGGING3EXTENTMANAGEMENTLOCALSEGMENTSPACEMANAGEMENTAUTO；Tablespacecreated.SQL>ALTERDATABASEDEFAULTTABLESPACEMRKT；Databasealtered.WhichtwostatementsaretrueregardingtheMRKTtablespace（）A.Nomoredatafilescanbeaddedtothetablespace.B.Segmentspaceismanagedbyfreelistsinthetablespace.C.Ausercreatedwithoutbeingassignedadefaulttablespaceusesthistablespace.D.Thetablespacecanbedroppedwiththecurrentsettingwithsegmentspresentinit

3.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

4.View the Exhibit to examine the output for the V$DIAG_INFO view. Which statements are true regarding the location of diagnostic traces?()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.

更多“单选题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/pr”相关问题

  • 第1题：

    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


    参考答案：B

  • 第2题：

    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


    参考答案：B, C

  • 第3题：

    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.


    参考答案：C

  • 第4题：

    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

  • 第5题：

    You manually create an additional listener process，L1，for databases PROD，  PAYDB and FINDB. While starting up the listener process，you get the following error message： LSNRCTL> start l1  Starting /u01/app/oracle/product/10.1.0/db_1/bin/tnslsnr： please wait...  TNSLSNR for Linux： Version 10.1.0.2.0 - Production  System parameter file is /u01/app/oracle/product/10.1.0/db_1/network/admin/listener.ora Log messages written to /u01/app/oracle/product/10.1.0/db_1/network/log/l1.log Error listening on： （ADDRESS=（PROTOCOL=TCP）（HOST=144.23.230.185）（port=8899））  TNS-12542： TNS：address already in use TNS-12560：  TNS：protocol adapter error TNS-00512： Address already in use  Linux Error： 98： Address already in use  Listener failed to start. See the error message（s） above...  What action would you take to overcome this error without disrupting any existing database communications？（）

    • A、stop and restart the listener process
    • B、set the TNS_ADMIN environmental variable
    • C、stop all running listener processes and restart the listener process
    • D、change the port number to an unused port number and restart the listener process
    • E、change the IP address to host machine name in the LISTENER.ORA file and restart the listener process

    正确答案:D

  • 第6题：

    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 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.
    • 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.

    正确答案:C

  • 第7题：

    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/product/11.1.0/db_1/cdump DIAGNOSTIC_DEST= The environment variables have the following value: ORACLE_BASE=/u01/app/oracle ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1 What 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

    正确答案:B

  • 第8题：

    Your alert log file has the following information： Tue May 25 17：43：38 2004  ORA-00060： Deadlock detected. More info in file  /u01/app/oracle/admin/ORCL/udump/orcl_ora_3173.trc.  What would you do to ensure that database is still running correctly？（）

    • A、examine the trace file and kill the session that caused the deadlock
    • B、examine the trace file and kill both the sessions responsible for the deadlock
    • C、examine the trace file for details and ask the user who caused the deadlock to roll back the transaction
    • D、examine the trace file for details and remember that deadlocks are resolved automatically by Oracle database
    • E、examine the trace file for details and use the Undo Advisor to rollback the transaction that caused the deadlock

    正确答案:D

  • 第9题：

    单选题
    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/product/11.1.0/db_1/cdump DIAGNOSTIC_DEST=   The environment variables have the following value：   ORACLE_BASE=/u01/app/oracle  ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1   What 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


    正确答案： D
    解析： 暂无解析

  • 第10题：

    多选题
    When you try to start the Database Control by using the emctl start dbconsole command the following error is displayed： TZ set to America/New_york OC4J Configuration issue.  /u01/app/oracle/product/10.1.0/db_1/oc4j/j2ee/OC4J_DBConsole_orcl.us.oracle.com not found.  Which two environment variables do you need to set appropriately to avoid such errors，and start the Database Control successfully？（）
    A

    NLS_LANG

    B

    ORACLE_SID

    C

    ORACLE_HOME

    D

    ORACLE_BASE

    E

    LD_LIBRARY_PATH


    正确答案： A,D
    解析： 暂无解析

  • 第11题：

    单选题
    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 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.

    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.


    正确答案： B
    解析： 暂无解析

  • 第12题：

    单选题
    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 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


    正确答案： B
    解析： 暂无解析

  • 第13题：

    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）.


    参考答案：F

  • 第14题：

    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

  • 第15题：

    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

  • 第16题：

    如下面这段监听配置中,sid_name的值来自于哪个参数? SID_LIST_LISTENER = (SID_DESC =(GLOBAL_DBNAME = orcl ) (ORACLE_HOME = ／u01／app／oracle／product／ 10. 2.0／db_1) (SID_NAME = orcl ) )()

    A. INSTANCE_NAME

    B. DB_NAME

    C. DB_UNIQUE_NAME

    D. SERVICE_NAMES

    E. GLOBAL_NAMES


    参考答案A

  • 第17题：

    You work as a database administrator for Supportcenter.cn. In your Oracle database 10g installation you have set ORACLE_BASE to /u01/app/oracle. Which objective will be achieved by this setting？（）

    • A、The Oracle kernel will be placed in this location.
    • B、The Oracle software will be placed in this location.
    • C、The server parameter file （SPFILE） will be placed in this location.
    • D、The database files will be placed in this location， if not specified explicitly.
    • E、The location will be considered for the base of Oracle Managed Files （OMF）.
    • F、The location will be considered for the base of Optimal Flexible Architecture （OFA）.

    正确答案:F

  • 第18题：

    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 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

    正确答案:C

  • 第19题：

    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/product/11.1.0/db_1/cdump DIAGNOSTIC_DEST=   The environment variables have the following value：   ORACLE_BASE=/u01/app/oracle  ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1   What 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

    正确答案:B

  • 第20题：

    When you try to start the Database Control by using the emctl start dbconsole command the following error is displayed： TZ set to America/New_york OC4J Configuration issue.  /u01/app/oracle/product/10.1.0/db_1/oc4j/j2ee/OC4J_DBConsole_orcl.us.oracle.com not found.  Which two environment variables do you need to set appropriately to avoid such errors，and start the Database Control successfully？（）

    • A、NLS_LANG
    • B、ORACLE_SID
    • C、ORACLE_HOME
    • D、ORACLE_BASE
    • E、LD_LIBRARY_PATH

    正确答案:B,C

  • 第21题：

    单选题
    Your alert log file has the following information： Tue May 25 17：43：38 2004  ORA-00060： Deadlock detected. More info in file  /u01/app/oracle/admin/ORCL/udump/orcl_ora_3173.trc.  What would you do to ensure that database is still running correctly？（）
    A

    examine the trace file and kill the session that caused the deadlock

    B

    examine the trace file and kill both the sessions responsible for the deadlock

    C

    examine the trace file for details and ask the user who caused the deadlock to roll back the transaction

    D

    examine the trace file for details and remember that deadlocks are resolved automatically by Oracle database

    E

    examine the trace file for details and use the Undo Advisor to rollback the transaction that caused the deadlock


    正确答案： A
    解析： 暂无解析

  • 第22题：

    单选题
    You work as a database administrator for Supportcenter.cn. In your Oracle database 10g installation you have set ORACLE_BASE to /u01/app/oracle. Which objective will be achieved by this setting？（）
    A

    The Oracle kernel will be placed in this location.

    B

    The Oracle software will be placed in this location.

    C

    The server parameter file （SPFILE） will be placed in this location.

    D

    The database files will be placed in this location， if not specified explicitly.

    E

    The location will be considered for the base of Oracle Managed Files （OMF）.

    F

    The location will be considered for the base of Optimal Flexible Architecture （OFA）.


    正确答案： E
    解析： 暂无解析

  • 第23题：

    单选题
    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/product/11.1.0/db_1/cdump DIAGNOSTIC_DEST= The environment variables have the following value: ORACLE_BASE=/u01/app/oracle ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1 What 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


    正确答案： B
    解析： 暂无解析

  • 第24题：

    单选题
    You manually create an additional listener process，L1，for databases PROD，  PAYDB and FINDB. While starting up the listener process，you get the following error message： LSNRCTL> start l1  Starting /u01/app/oracle/product/10.1.0/db_1/bin/tnslsnr： please wait...  TNSLSNR for Linux： Version 10.1.0.2.0 - Production  System parameter file is /u01/app/oracle/product/10.1.0/db_1/network/admin/listener.ora Log messages written to /u01/app/oracle/product/10.1.0/db_1/network/log/l1.log Error listening on： （ADDRESS=（PROTOCOL=TCP）（HOST=144.23.230.185）（port=8899））  TNS-12542： TNS：address already in use TNS-12560：  TNS：protocol adapter error TNS-00512： Address already in use  Linux Error： 98： Address already in use  Listener failed to start. See the error message（s） above...  What action would you take to overcome this error without disrupting any existing database communications？（）
    A

    stop and restart the listener process

    B

    set the TNS_ADMIN environmental variable

    C

    stop all running listener processes and restart the listener process

    D

    change the port number to an unused port number and restart the listener process

    E

    change the IP address to host machine name in the LISTENER.ORA file and restart the listener process


    正确答案： B
    解析： 暂无解析

相关内容