搜题

【单选题】

Your&ensp;database&ensp;is&ensp;running&ensp;in&ensp;NOARCHIVELOG&ensp;mode.&ensp;Every&ensp;night&ensp;there&ensp;is&ensp;a&ensp;backup&ensp;taken&ensp;using&ensp;RMAN.&ensp;During&ensp;your&ensp;startup&ensp;this&ensp;morning&ensp;you&ensp;received&ensp;en&ensp;error&ensp;regarding&ensp;DISK&ensp;3&ensp;on&ensp;your&ensp;server.&ensp;This&ensp;is&ensp;the&ensp;location&ensp;of&ensp;your&ensp;data&ensp;file&ensp;for&ensp;the&ensp;SYSTEM&ensp;tablespace.&ensp;Which&ensp;option&ensp;is&ensp;open&ensp;to&ensp;you？（）<img src="https://nimg.ppkao.com/2018-08/wangjing/2018080110035167073.jpg?sign=521fb575c5742ddfccc041cef4103c57&t=62d0bc55" />

A、A

B、B

C、C

D、D

查看正确答案

更多“ Your&ensp;database&ensp;is&ensp;running&ensp;in&ensp;NOARCHIVELOG&ensp;mode.&ensp;Every&ensp;night&ensp;there&ensp;is&ensp;a&ensp;backup&ensp;taken&ensp;using&ensp;RMAN.&ensp;During&ensp;your&ensp;startup&ensp;this&ensp;morning&ensp;you&ensp;received&ensp;en&ensp;error&ensp;regarding&ensp;DISK&ensp;3&ensp;on&ensp;your&ensp;server.&ensp;This&ensp;is&ensp;the&ensp;location&ensp;of&ensp;your&ensp;data&ensp;file&ensp;for&ensp;the&ensp;SYSTEM&ensp;tablespace.&ensp;Which&ensp;option&ensp;is&ensp;open&ensp;to&ensp;you？（）<img src="https://nimg.ppkao.com/2018-08/wangjing/2018080110035167073.jpg?sign=521fb575c5742ddfccc041cef4103c57&t=62d0bc55" />”相关的问题

第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

请使用微信扫码支付

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