如下面这段监听配置中,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_NAMEB. DB_NAMEC. DB_UNIQUE_NAMED. SERVICE_NAMESE. GLOBAL_NAMES

题目
如下面这段监听配置中,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

相似考题

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

参考答案和解析
参考答案A
更多“如下面这段监听配置中,sid_name的值来自于哪个参数? SID_LIST_LISTENER = (SID_DESC =(GLOBAL_DBNAME = orcl ) (ORACLE_HOME = ／u01／app／oracle／product／ 10. 2.0／db_1) (SID_NAME = orcl ) )() ”相关问题

  • 第1题：

    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

  • 第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题：

    YouworkasadatabaseadministratoratCertkiller&ensp

    YouworkasadatabaseadministratoratCertkiller.com.YourdatabaseisopenandrunninginARCHIVELOGmode.YoutakeRMANfullbackupseverySundaynight.OnMondaymorning，whilequeryingtheuser1.employeestable，youreceivethefollowingerrormessage：

    01578：ORACLEdatablockcorrupted（file#5，block#51）

    ORA-01110：datafile5：’/u01/app/oracle/oradata/orcl/example01.dbf’

    Youneedtorectifythecorruptionwhileensuringthefollowing：

    Thedatafileshouldremainonline.

    Themeantimetorecover（MTTR）shouldbeminimal.

    Youarenotusingabackupcontrolfileandallthearchivedlogsareaccessible.

    Whichoptionwouldyouchoose？（）


    参考答案：D

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

相关内容