网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
单选题
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
参考答案
参考解析
解析:
暂无解析
更多 “单选题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_1B /u01/app/oracleC $ORACLE_HOME/bdumpD $ORACLE_HOME/log” 相关考题
考题
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
考题
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.
考题
ExaminethecommandsexecutedinaDBAsession:SQLCREATEBIGFILETABLESPACEMRKT2DATAFILE’/u01/app/oracle/oradata/orcl/mrkt.dbf’size10MLOGGING3EXTENTMANAGEMENTLOCALSEGMENTSPACEMANAGEMENTAUTO;Tablespacecreated.SQLALTERDATABASEDEFAULTTABLESPACEMRKT;Databasealtered.WhichtwostatementsaretrueregardingtheMRKTtablespace()A.Nomoredatafilescanbeaddedtothetablespace.B.Segmentspaceismanagedbyfreelistsinthetablespace.C.Ausercreatedwithoutbeingassignedadefaulttablespaceusesthistablespace.D.Thetablespacecanbedroppedwiththecurrentsettingwithsegmentspresentinit
考题
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
考题
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
考题
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).
考题
WhenyoutrytostarttheDatabaseControlbyusingtheemctlstartdbconsolecommandthefollowingerrorisdisplayed:TZsettoAmerica/New_yorkOC4JConfigurationissue./u01/app/oracle/product/10.1.0/db_1/oc4j/j2ee/OC4J_DBConsole_orcl.us.oracle.comnotfound.WhichtwoenvironmentvariablesdoyouneedtosetappropriatelytoavoidsucherrorsandstarttheDatabaseControlsuccessfully?()A.NLS_LANGB.ORACLE_SIDC.ORACLE_HOMED.ORACLE_BASEE.LD_LIBRARY_PATH
考题
Youralertlogfilehasthefollowinginformation:TueMay2517:43:382004ORA-00060:Deadlockdetected.Moreinfoinfile/u01/app/oracle/admin/ORCL/udump/orcl_ora_3173.trc.Whatwouldyoudotoensurethatdatabaseisstillrunningcorrectly?()A.examinethetracefileandkillthesessionthatcausedthedeadlockB.examinethetracefileandkillboththesessionsresponsibleforthedeadlockC.examinethetracefilefordetailsandasktheuserwhocausedthedeadlocktorollbackthetransactionD.examinethetracefilefordetailsandrememberthatdeadlocksareresolvedautomaticallybyOracledatabaseE.examinethetracefilefordetailsandusetheUndoAdvisortorollbackthetransactionthatcausedthedeadlock
考题
Youhavecontrol-fileautobackupsenabled.WhenstartingyourdatabasefromSQL*Plus,youreceivethefollowingerrormessage:SQLstartupORA-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.
考题
Youmanuallycreateanadditionallistenerprocess,L1,forstartl1Starting/u01/app/oracle/product/10.1.0/db_1/bin/tnslsnr:pleasewait...TNSLSNRforLinux:Version10.1.0.2.0-ProductionSystemparameterfileis/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:AddressalreadyinuseLinuxError:98:AddressalreadyinuseListenerfailedtostart.Seetheerrormessage(s)above...Whatactionwouldyoutaketoovercomethiserrorwithoutdisruptinganyexistingdatabasecommunications?()
考题
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.
考题
如下面这段监听配置中,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
考题
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 processB、set the TNS_ADMIN environmental variableC、stop all running listener processes and restart the listener processD、change the port number to an unused port number and restart the listener processE、change the IP address to host machine name in the LISTENER.ORA file and restart the listener process
考题
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).
考题
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.
考题
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
考题
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_1B、/u01/app/oracleC、$ORACLE_HOME/bdumpD、$ORACLE_HOME/log
考题
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_1B、 /u01/app/oracleC、 $ORACLE_HOME/bdumpD、 $ORACLE_HOME/log
考题
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 deadlockB、examine the trace file and kill both the sessions responsible for the deadlockC、examine the trace file for details and ask the user who caused the deadlock to roll back the transactionD、examine the trace file for details and remember that deadlocks are resolved automatically by Oracle databaseE、examine the trace file for details and use the Undo Advisor to rollback the transaction that caused the deadlock
考题
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_LANGB、ORACLE_SIDC、ORACLE_HOMED、ORACLE_BASEE、LD_LIBRARY_PATH
考题
单选题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 deadlockB
examine the trace file and kill both the sessions responsible for the deadlockC
examine the trace file for details and ask the user who caused the deadlock to roll back the transactionD
examine the trace file for details and remember that deadlocks are resolved automatically by Oracle databaseE
examine the trace file for details and use the Undo Advisor to rollback the transaction that caused the deadlock
考题
多选题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?()ANLS_LANGBORACLE_SIDCORACLE_HOMEDORACLE_BASEELD_LIBRARY_PATH
考题
单选题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).
考题
单选题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.
考题
单选题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_1B
/u01/app/oracleC
$ORACLE_HOME/bdumpD
$ORACLE_HOME/log
考题
单选题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
考题
单选题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 processB
set the TNS_ADMIN environmental variableC
stop all running listener processes and restart the listener processD
change the port number to an unused port number and restart the listener processE
change the IP address to host machine name in the LISTENER.ORA file and restart the listener process
热门标签
最新试卷