搜题

【单选题】

Your&ensp;database&ensp;is&ensp;started&ensp;by&ensp;using&ensp;the&ensp;server&ensp;parameter&ensp;file&ensp;（SPFILE）.&ensp;You&ensp;issued&ensp;this&ensp;command&ensp;to&ensp;change&ensp;the&ensp;value&ensp;of&ensp;the&ensp;LOG_BUFFER&ensp;initialization&ensp;parameter：&ensp;<br /> ALTER&ensp;SYSTEM&ensp;SET&ensp;LOG_BUFFER=24M&ensp;SCOPE=BOTH；&ensp;<br /> What&ensp;would&ensp;be&ensp;the&ensp;outcome&ensp;of&ensp;this&ensp;command？&ensp;（）

A、The command would return an error because LOG_BUFFER is a static parameter.

B、The parameter value would be changed and it would come into effect immediately.

C、You need to restart the database so that parameter changes can come into effect.

D、The command would succeed only if initialization parameter LOG_ARCHIVE_MAX_PROCESS is set to value 2.

查看正确答案

更多“ Your&ensp;database&ensp;is&ensp;started&ensp;by&ensp;using&ensp;the&ensp;server&ensp;parameter&ensp;file&ensp;（SPFILE）.&ensp;You&ensp;issued&ensp;this&ensp;command&ensp;to&ensp;change&ensp;the&ensp;value&ensp;of&ensp;the&ensp;LOG_BUFFER&ensp;initialization&ensp;parameter：&ensp;<br /> ALTER&ensp;SYSTEM&ensp;SET&ensp;LOG_BUFFER=24M&ensp;SCOPE=BOTH；&ensp;<br /> What&ensp;would&ensp;be&ensp;the&ensp;outcome&ensp;of&ensp;this&ensp;command？&ensp;（）”相关的问题

第1题

[单选题] You executed the STARTUP MOUNT command to start your database. For which database operation do you need to start the database in the MOUNT state？（）

A、renaming&ensp;the&ensp;control&ensp;files B、dropping&ensp;a&ensp;user&ensp;in&ensp;your&ensp;database C、enabling&ensp;or&ensp;disabling&ensp;redo&ensp;log&ensp;archiving D、dropping&ensp;a&ensp;tablespace&ensp;in&ensp;your&ensp;database E、re-creating&ensp;the&ensp;control&ensp;files，&ensp;after&ensp;you&ensp;lost&ensp;all&ensp;the&ensp;control&ensp;files&ensp;in&ensp;your&ensp;database

点击查看答案

第2题

[] You&ensp;executed&ensp;the&ensp;following&ensp;query&ensp;in&ensp;your&ensp;database：&ensp; FROM&ensp;V$FLASHBACK_DATABASE_LOG;&ensp; What&ensp;would&ensp;you&ensp;determine&ensp;from&ensp;the&ensp;output？（） You&ensp;executed&ensp;the&ensp;following&ensp;query&ensp;in&ensp;your&ensp;database：&ensp; FROM&ensp;V$FLASHBACK_DATABASE_LOG;&ensp; What&ensp;would&ensp;you&ensp;determine&ensp;from&ensp;the&ensp;output？（）

A、A.the&ensp;time&ensp;when&ensp;the&ensp;last&ensp;flashback&ensp;operation&ensp;in&ensp;your&ensp;database&ensp;was&ensp;performed B、B.the&ensp;time&ensp;when&ensp;the&ensp;first&ensp;flashback&ensp;operation&ensp;in&ensp;your&ensp;database&ensp;was&ensp;performed C、C.a&ensp;list&ensp;of&ensp;flashback&ensp;operations&ensp;performed&ensp;in&ensp;your&ensp;database&ensp;using&ensp;SCN&ensp;and&ensp;time D、D.the&ensp;approximate&ensp;time&ensp;and&ensp;the&ensp;lowest&ensp;system&ensp;change&ensp;number&ensp;（SCN）&ensp;to&ensp;which&ensp;you&ensp;can&ensp;flash&ensp;back&ensp;your&ensp;database

点击查看答案

第3题

[单选题] A&ensp;shoot-out&ensp;has&ensp;erupted&ensp;between&ensp;your&ensp;MS&ensp;development&ensp;teams&ensp;using&ensp;.NET&ensp;and&ensp;your&ensp;Linux&ensp;development&ensp;teams&ensp;using&ensp;Java.&ensp; Knowing&ensp;that&ensp;your&ensp;database&ensp;is&ensp;in&ensp;danger，which&ensp;command&ensp;would&ensp;you&ensp;use&ensp;to&ensp;back&ensp;up&ensp;your&ensp;NOARCHIVELOG&ensp;mode&ensp;database&ensp;using&ensp;RMAN&ensp;with&ensp;compression？（）

A、&ensp;backup&ensp;database&ensp;all B、&ensp;backup&ensp;compressed&ensp;database C、&ensp;backup&ensp;as&ensp;compressed&ensp;backupset&ensp;database D、&ensp;backup&ensp;as&ensp;compressed&ensp;backup&ensp;database&ensp;plus&ensp;archivelog&ensp;all E、&ensp;backup&ensp;as&ensp;compressed&ensp;backupset&ensp;database&ensp;plus&ensp;compress&ensp;archivelog&ensp;all

点击查看答案

第4题

[] Your&ensp;database&ensp;runs&ensp;in&ensp;ARCHIVELOG&ensp;mode，&ensp;and&ensp;is&ensp;backed&ensp;up&ensp;every&ensp;Sunday&ensp;night&ensp;using&ensp;RMAN&ensp;scripts.&ensp;On&ensp;Friday&ensp;your&ensp;database&ensp;crashes.&ensp;Now&ensp;you&ensp;want&ensp;to&ensp;use&ensp;the&ensp;backups&ensp;from&ensp;last&ensp;Sunday&ensp;night&ensp;to&ensp;restore&ensp;your&ensp;database.&ensp; How&ensp;can&ensp;you&ensp;do&ensp;this？（） Your&ensp;database&ensp;runs&ensp;in&ensp;ARCHIVELOG&ensp;mode，&ensp;and&ensp;is&ensp;backed&ensp;up&ensp;every&ensp;Sunday&ensp;night&ensp;using&ensp;RMAN&ensp;scripts.&ensp;On&ensp;Friday&ensp;your&ensp;database&ensp;crashes.&ensp;Now&ensp;you&ensp;want&ensp;to&ensp;use&ensp;the&ensp;backups&ensp;from&ensp;last&ensp;Sunday&ensp;night&ensp;to&ensp;restore&ensp;your&ensp;database.&ensp; How&ensp;can&ensp;you&ensp;do&ensp;this？（）

A、A.A B、B.B C、C.C D、D.D

点击查看答案

第5题

[单选题] You executed the following query in your database： SELECT oldest_flashback_scn， oldest_flashback_time FROM V$FLASHBACK_DATABASE_LOG； What would you determine from the output？（）

A、&ensp;The&ensp;time&ensp;when&ensp;the&ensp;last&ensp;flashback&ensp;operation&ensp;in&ensp;your&ensp;database&ensp;was&ensp;performed. B、&ensp;The&ensp;time&ensp;when&ensp;the&ensp;first&ensp;flashback&ensp;operation&ensp;in&ensp;your&ensp;database&ensp;was&ensp;performed. C、&ensp;A&ensp;list&ensp;of&ensp;flashback&ensp;operations&ensp;performed&ensp;in&ensp;your&ensp;database&ensp;using&ensp;SCN&ensp;and&ensp;time. D、&ensp;The&ensp;approximate&ensp;time&ensp;and&ensp;the&ensp;lowest&ensp;system&ensp;change&ensp;number&ensp;（SCN）&ensp;to&ensp;which&ensp;you&ensp;can&ensp;flash&ensp;back&ensp;your&ensp;database.

点击查看答案

第6题

[单选题] You&ensp;are&ensp;maintaining&ensp;your&ensp;database&ensp;in&ensp;Oracle10g.&ensp;You&ensp;find&ensp;that&ensp;the&ensp;number&ensp;of&ensp;languages&ensp;that&ensp;should&ensp;be&ensp;supported&ensp;in&ensp;your&ensp;database&ensp;has&ensp;increased.&ensp;The&ensp;character&ensp;set&ensp;of&ensp;your&ensp;database&ensp;is&ensp;UTF8.&ensp;You&ensp;decide&ensp;to&ensp;migrate&ensp;your&ensp;database&ensp;to&ensp;the&ensp;AL16UTF16&ensp;national&ensp;character&ensp;set.&ensp;&ensp; How&ensp;will&ensp;you&ensp;migrate&ensp;your&ensp;database&ensp;from&ensp;UTF8&ensp;to&ensp;AL16UTF16？（）&ensp;&ensp;

A、&ensp;by&ensp;using&ensp;the&ensp;RMAN&ensp;utility B、&ensp;by&ensp;using&ensp;the&ensp;export/import&ensp;utility C、&ensp;by&ensp;using&ensp;the&ensp;ALTER&ensp;DATABASE&ensp;command D、&ensp;by&ensp;enabling&ensp;the&ensp;change&ensp;tracking&ensp;feature

点击查看答案

第7题

[单选题] For which database operation would you need the database to be in the MOUNT state（）

A、renaming&ensp;the&ensp;control&ensp;files B、re-creating&ensp;the&ensp;control&ensp;files C、dropping&ensp;a&ensp;user&ensp;in&ensp;your&ensp;database D、dropping&ensp;a&ensp;tablespace&ensp;in&ensp;your&ensp;database E、configuring&ensp;the&ensp;database&ensp;instance&ensp;to&ensp;operate&ensp;in&ensp;the&ensp;ARCHIVELOG&ensp;or&ensp;NOARCHIVELOG&ensp;modes

点击查看答案

第8题

[] You&ensp;experienced&ensp;a&ensp;loss&ensp;of&ensp;data&ensp;files&ensp;in&ensp;your&ensp;database.&ensp;You&ensp;did&ensp;not&ensp;lose&ensp;any&ensp;of&ensp;your&ensp;control&ensp;files.&ensp;You&ensp;are&ensp;going&ensp;to&ensp;use&ensp;RMAN&ensp;to&ensp;restore&ensp;and&ensp;recover&ensp;the&ensp;database.&ensp;Currently，&ensp;your&ensp;instance&ensp;is&ensp;shut&ensp;down.&ensp; Which&ensp;sequence&ensp;of&ensp;commands&ensp;is&ensp;correct&ensp;to&ensp;restore&ensp;and&ensp;recover&ensp;your&ensp;database？（） You&ensp;experienced&ensp;a&ensp;loss&ensp;of&ensp;data&ensp;files&ensp;in&ensp;your&ensp;database.&ensp;You&ensp;did&ensp;not&ensp;lose&ensp;any&ensp;of&ensp;your&ensp;control&ensp;files.&ensp;You&ensp;are&ensp;going&ensp;to&ensp;use&ensp;RMAN&ensp;to&ensp;restore&ensp;and&ensp;recover&ensp;the&ensp;database.&

A、A.A B、B.B C、C.C D、D.D

点击查看答案

第9题

[单选题] If you lost your entire database，including the database spfile，control files，online redo logs，and database datafiles，what kind of recovery would be required with RMAN？（）

A、&ensp;Complete&ensp;database&ensp;recovery. B、&ensp;Incomplete&ensp;database&ensp;recovery. C、&ensp;Approximate&ensp;database&ensp;recovery. D、&ensp;Archived&ensp;database&ensp;recovery. E、&ensp;The&ensp;database&ensp;could&ensp;not&ensp;be&ensp;recovered&ensp;with&ensp;RMAN.

点击查看答案

第10题

[多选题] Last night， a media failure caused the loss of a temporary file that belongs to your database. Which two things may happen this morning when you try to open your database？（）

A、The&ensp;database&ensp;opens&ensp;normally. B、The&ensp;database&ensp;prompts&ensp;for&ensp;a&ensp;database&ensp;recovery. C、The&ensp;database&ensp;writer&ensp;writes&ensp;to&ensp;a&ensp;trace&ensp;file，&ensp;indicating&ensp;that&ensp;the&ensp;temporary&ensp;file&ensp;is&ensp;not&ensp;found. D、The&ensp;database&ensp;gets&ensp;mounted&ensp;and&ensp;throws&ensp;an&ensp;error&ensp;indicating&ensp;that&ensp;the&ensp;temporary&ensp;file&ensp;requires&ensp;recovery.

点击查看答案

账号：登录

答题记录

我的收藏

我的题库

客服

TOP

请使用微信扫码支付

订单号：
遇到问题请联系在线客服