/u01/app/oracle/product/11.1.0/db_1
/u01/app/oracle
$ORACLE_HOME/bdump
$ORACLE_HOME/log
第1题:
ExaminethecommandsexecutedinaDBAsession:SQL>CREATEBIGFILETABLESPACEMRKT2DATAFILE’/u01/app/oracle/oradata/orcl/mrkt.dbf’size10MLOGGING3EXTENTMANAGEMENTLOCALSEGMENTSPACEMANAGEMENTAUTO;Tablespacecreated.SQL>ALTERDATABASEDEFAULTTABLESPACEMRKT;Databasealtered.WhichtwostatementsaretrueregardingtheMRKTtablespace()
A.Nomoredatafilescanbeaddedtothetablespace.
B.Segmentspaceismanagedbyfreelistsinthetablespace.
C.Ausercreatedwithoutbeingassignedadefaulttablespaceusesthistablespace.
D.Thetablespacecanbedroppedwiththecurrentsettingwithsegmentspresentinit
第2题:
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
第3题:
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
第4题:
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.
第5题:
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
第6题:
Youwanttocheckthedetailsoffewerrorsthatusershavereported.Yousearchforthealertlogfileandexecutefewcommandstofindthelocationofthealertlogfile.ViewtheExhibitandcheckthecommandsexecuted.Whatisthelocationofthealert_orcl.logfile()
A.ORACLE_HOME/dbs
B.ORACLE_HOME/rdbms
C./u01/app/oracle/admin/orcl/adump
D./u01/app/oracle/flash_recovery_area
E.ORACLE_BASE/diag/rdbms/orcl/orcl/alert
F.ORACLE_BASE/diag/rdbms/orcl/orcl/trace
第7题:
A.TheOraclekernelwillbeplacedinthislocation.
B.TheOraclesoftwarewillbeplacedinthislocation.
C.Theserverparameterfile(SPFILE)willbeplacedinthislocation.
D.Thedatabasefileswillbeplacedinthislocation,ifnotspecifiedexplicitly.
E.ThelocationwillbeconsideredforthebaseofOracleManagedFiles(OMF).
F.ThelocationwillbeconsideredforthebaseofOptimalFlexibleArchitecture(OFA).
第8题:
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.
第9题:
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
第10题:
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?()