YouworkasadatabaseadministratorforCertkiller.com.InyourOracledatabase10ginstallationyouhavesetORACLE_BASEto/u01/app/oracle.Whichobjectivewillbeachievedbythissetting?() A.TheOraclekernelwillbeplacedinthislocation.B.TheOraclesoftwarewillbeplacedinthislocation.C.Theserverparameterfile(SPFILE)willbeplacedinthislocation.D.Thedatabasefileswillbeplacedinthislocation,ifnotspecifiedexplicitly.E.ThelocationwillbeconsideredforthebaseofOracleManagedFiles(OMF).F.ThelocationwillbeconsideredforthebaseofOptimalFlexibleArchitecture(OFA).

YouworkasadatabaseadministratorforCertkiller.com.InyourOracledatabase10ginstallationyouhavesetORACLE_BASEto/u01/app/oracle.Whichobjectivewillbeachievedbythissetting?()

A.TheOraclekernelwillbeplacedinthislocation.

B.TheOraclesoftwarewillbeplacedinthislocation.

C.Theserverparameterfile(SPFILE)willbeplacedinthislocation.

D.Thedatabasefileswillbeplacedinthislocation,ifnotspecifiedexplicitly.

E.ThelocationwillbeconsideredforthebaseofOracleManagedFiles(OMF).

F.ThelocationwillbeconsideredforthebaseofOptimalFlexibleArchitecture(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 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

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

Williamspecifiedthefollowinginitializationparametersettingsinthepfile:BACKGROUND_DUMP_DEST=’u01\oradata\dir_A’USER_DUMP_DEST=’u01\oradata\dir_B’DB_CREATE_FILE_DEST=’u01\oradata\dir_C’DB_CREATE_ONLINE_LOG_DEST_n=’u01\oradata\dir_D’Williamenabledthechange-trackingfeaturebecausehedoesnotwanttoscantheentiredatafileduringbackup.Whatisthedefaultstoragelocationforthechangetrackingfile?()A.’u01\oradata\dir_A’B.’u01\oradata\dir_B’C.’u01\oradata\dir_C’D.’u01\oradata\dir_D’

Youralertlogfilehasthefollowinginformation:TueMay2517:43:382004ORA-00060:Deadlockdetected.Moreinfoinfile/u01/app/oracle/admin/ORCL/udump/orcl_ora_3173.trc.Whatwouldyoudotoensurethatdatabaseisstillrunningcorrectly?()A.examinethetracefileandkillthesessionthatcausedthedeadlockB.examinethetracefileandkillboththesessionsresponsibleforthedeadlockC.examinethetracefilefordetailsandasktheuserwhocausedthedeadlocktorollbackthetransactionD.examinethetracefilefordetailsandrememberthatdeadlocksareresolvedautomaticallybyOracledatabaseE.examinethetracefilefordetailsandusetheUndoAdvisortorollbackthetransactionthatcausedthedeadlock

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.