网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)

Yourtnsnames.orafilehasthefollowingentryfortheservicealiasORCL:ORCL=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.156.24.216)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl.oracle.com)))TheTNSPINGcommandexecutessuccessfullywhentestedwithORCLbutyouarenotabletoconnecttothedatabaseinstancewiththefollowingcommand:SQL>CONNECTscott/tiger@orclWhatcouldbethereasonforthis?()

A.Thelistenerisnotrunningattheserver.

B.TheTNS_ADMINenvironmentalvariableissettoawrongvalue.

C.Theorcl.oracle.comdatabaseserviceisnotregisteredwiththelistener.

D.TheDEFAULT_DOMAINparameterissettoawrongvalueintheSQLNET.ORAfile.


参考答案

更多 “ Yourtnsnames.orafilehasthefollowingentryfortheservicealiasORCL:ORCL=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.156.24.216)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl.oracle.com)))TheTNSPINGcommandexecutessuccessfullywhentestedwithORCLbutyouarenotabletoconnecttothedatabaseinstancewiththefollowingcommand:SQLCONNECTscott/tiger@orclWhatcouldbethereasonforthis?()A.Thelistenerisnotrunningattheserver.B.TheTNS_ADMINenvironmentalvariableissettoawrongvalue.C.Theorcl.oracle.comdatabaseserviceisnotregisteredwiththelistener.D.TheDEFAULT_DOMAINparameterissettoawrongvalueintheSQLNET.ORAfile. ” 相关考题
考题 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

考题 ExaminetheCREATEDISKGROUPcommandusedtocreateadiskgroup:SQLCREATEDISKGROUPmiscEXTERNALREDUNDANCYDISK’ORCL:FRA3’NAMEmisc1,’ORCL:FRA4’NAMEmisc2;Inwhichsituationwouldyouusethismethodofdiskgroupcreation?()A.Whentwo-waydiskmirroringisrequiredfortheallocationunitsB.Whenthree-waydiskmirroringisrequiredfortheallocationunitsC.WhenusinghardwaremirroringorRAIDD.WhendiskmirroringisrequiredfortheAutomaticStorageManagement(ASM)disks

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

考题 Yourdatabaseisnotconfiguredforsessionfailover.Yourtnsnames.orafilecontainsthefollowingdetails:test.us.oracle.com=(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=off)(FAILOVER=ON)(ADDRESS=(PROTOCOL=tcp)(HOST=test1-server)(PORT=1521))(ADDRESS=(PROTOCOL=tcp)(HOST=test2-server)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=test.us.oracle.com)))Whichfeatureisenabledinthiscase?()A.LoadbalancingB.InstancefailoverC.DatabasefailoverD.Connect-timefailoverE.TransparentApplicationFailover(TAF)

考题 Youexecutedthefollowingcommandstofindthelocationofthealertlogfile:Whereisthealertlogfilestored() A.intheBACKGROUND_DUMP_DESTlocation;intextformatB.intheBACKGROUND_DUMP_DESTlocation;inXMLformatC.intheBACKGROUND_DUMP_DESTlocation;inbothtextandXMLformatD.intheDIAGNOSTIC_DEST/diag/rdbms/orcl/orcl/alertdirectory;intextformatE.intheDIAGNOSTIC_DEST/diag/rdbms/orcl/orcl/alertdirectory;inXMLformatF.intheDIAGNOSTIC_DEST/diag/rdbms/orcl/orcl/alertdirectory;inbothtextandXMLformat

考题 Youexecutedthefollowingcommand:RMANRECOVERCOPYOFDATAFILE’/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.

考题 如下是某个tnsnames.ora里面的配置, 其中service_name的值与 listener.ora文件中哪个参数的值相对应? db.example.com= (description= (load_balance=on) (address=(protocol=tcp)(host=node1-vip)(port=1521) (address=(protocol=tcp)(host=node2-vip)(port=1521) (connect_data= (service_name=db.example.com)))()A. SID_NAMEB. INSTANCE_NAMEC. GLOBAL_NAMESD. GLOBAL_DBNAME

考题 YouneedtodesignthestorageoftheapplicationtextsforUIelementstofulfilltherequirements.Whichtableandcolumndesignshouldyouuse?() A.Languages(LanguageID,Name)Elements(ElementID,Description)ElementLanguages(ElementID,LanguageID,Text)B.Languages(LanguageID,Name)Elements(ElementID,LanguageID,Description,Text)C.Languages(LanguageID,Name)ElementTexts(LanguageID,Text)ElementDescriptions(ElementID,Description)D.Languages(LanguageID,Name)Elements(ElementID,Description,Text)

考题 YouhavejustrunthissyntaxtostartthelistenerfromtheListenerControlutility:LSNRCTLSTARTStarting/mstgelai/oracle/bin/tnslsnr:pleasewait…Systemparameterfileis/u01/oracle/network/admin/listener.oraLogmessageswrittento/u01/oracle/network/log/listener.logListeningon:(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=stc-sun01-server)(PORT=1521)))Connectingto…ThecommandcompletedsuccessfullyWhatisthenameoftheListeneryoustarted?()A.TNSLSNRB.LISTENERC.LOCAL_LISTENERD.DEFAULT_LSRN