niusouti.com

ExaminetheRMANcommand:SWITCHDATAFILE’／DISK3／user_data01.dbf’;Whichcommanddoyouneedtoissuebeforeyouissuetheabovecommand,sothatRMANfindsthefileintherestoredlocationof’DISK2／user_data01.dbf’?()A.RESTOREDATAFILE’/DISK2/user_data01.dbf’B.RESTOREDATAFILE’/DISK3

题目
ExaminetheRMANcommand:SWITCHDATAFILE’／DISK3／user_data01.dbf’;Whichcommanddoyouneedtoissuebeforeyouissuetheabovecommand,sothatRMANfindsthefileintherestoredlocationof’DISK2／user_data01.dbf’?()

A.RESTOREDATAFILE’/DISK2/user_data01.dbf’

B.RESTOREDATAFILE’/DISK3/user_data01.dbf’

C.SETNEWNAMEFOR’/DISK3/user_data01.dbf’TO’/DISK2/user_data01.dbf’

D.SETNEWNAMEFOR’/DISK2/user_data01.dbf’TO’/DISK3/user_data01.dbf’

相似考题

1.Youwanttosetthefollowinginitializationparametersforyourdatabaseinstance：LOG_ARCHIVE_DEST_1=’LOCATION=/disk1/arch’LOG_ARCHIVE_DEST_2=’LOCATION=/disk2/arch’LOG_ARCHIVE_DEST_3=’LOACTION=/disk3/arch’LOG_ARCHIVE_DEST_4=’LOCATION=/disk4/archMANDATORY’Identifythestatementthatcorrectlydescribesthissetting.（）A.TheMANDATORYlocationmustbeaflashrecoveryarea.B.Theoptionaldestinationsmaynotusetheflashrecoveryarea.C.ThissettingisnotallowedbecausethefirstdestinationisnotsetasMANDATORY.D.Theonlineredologfileisnotallowedtobeoverwrittenifthearchivedlogcannotbecreatedinthefourthdestination.

2.YouwanttosetthefollowingInitializationparametersforyourdatabaseInstanceLOG_ARCHIVE_DEBT_1=，，LOCATION=/disk1/archLOG_ARCHIVE_DBST_2=，，LOCATION=/disk2/archLOC_ARCHIVBDBST_3=，，LOCATION=/disk3/archLOG_ARCHIVEDBST_=，，LOCATION=/disk3/archIdentifythestatementthatcorrectlydescribesthissetting.（）A.TheMANDATORYlocationmustbeaflashrecoveryarea.B.Theoptionaldestinationsmaynotusetheflashrecoveryarea.C.ThissettingisnotallowedbecausethefirstdestinationisnotsetasMANDATORY.D.Theonlineredologfileisnotallowedtobeoverwrittenifthearchivedlogcannotbecreatedinthefourthdestination.

3.Youhavethefollowingonlineredologconfiguration：GroupMember1’/disk1/oradata/redo01a.log’2’/disk2/oradata/redo02a.log’3’/disk3/oradata/redo03a.log’Youdecidetomultiplextheonlineredologgroupsforrecoveryofredologfilesincaseofanydisaster.WhichtwostatementswillyouNOTissuetomultiplextheonlineredologfiles？（）A.ALTERDATABASEADDLOGFILEMEMBER’/disk1/oradata/redo01b.log’TOGROUP1；B.ALTERDATABASEADDLOGFILEMEMBER’/disk2/oradata/redo01b.log’TOGROUP1；C.ALTERDATABASEADDLOGFILEMEMBER’/disk1/oradata/redo02b.log’TOGROUP2；D.ALTERDATABASEADDLOGFILEMEMBER’/disk2/oradata/redo02b.log’TOGROUP2；E.ALTERDATABASEADDLOGFILEMEMBER’/disk1/oradata/redo3b.log’TOGROUP3；F.ALTERDATABASEADDLOGFILEMEMBER’/disk2/oradata/redo3b.log’TOGROUP3；

4.YouhaveconfiguredflashrecoveryareainyourdatabaseandyousetthefollowingInitializationparametersforyourdatabaseinstance：LOG_ARCHIVE_DEST1=，，LOCATION=/disk1/archMANDATORY’LOG_ARCHIEVE_DEST2=，，LOCATION=/disk2/arch’LOG_ARCHIVK_DEST_3=，，LOCATION=/diSk3/archLOG_ARCH1VK_DEST_4=’LOCATION=/disk4/arch’LOG_ARCHIVE_MIN-SUCCEED_DEST=2Whilethedatabaseinstanceisfunctional，yourealizedthatthedestinationsetbytheLOG_ARCHIVE_DEST_IparameterIsnotavailableforthearchivedredologfiletobecreatedin.Allredologgroupshavebeenused.Whathappensinaneventoflogswitch？（）

参考答案和解析
参考答案：C
更多“ExaminetheRMANcommand:SWITCHDATAFILE’／DISK3／user_data01.dbf’;Whichcommanddoyouneedtoissuebeforeyouissuetheabovecommand,sothatRMANfindsthefileintherestoredlocationof’DISK2／user_data01.dbf’?() ”相关问题

  • 第1题：

    You are managing an ASM instance. You previously issued the following statements:ALTER DISKGROUP dg1 DROP DISK disk2;ALTER DISKGROUP dg1 DROP DISK disk3;ALTER DISKGROUP dg1 DROP DISK disk5;You want to cancel the disk drops that are pending for the DG1 disk group.Which statement should you issue?（）

    A. ALTER DISKGROUP dg1 UNDROP disk2, disk3, disk5;

    B. ALTER DISKGROUP dg1 UNDROP;

    C. ALTER DISKGROUP dg1 UNDROP DISKS;

    D. You cannot cancel the pending disk drops.


    参考答案：C

  • 第2题：

    Inwhichsituationwillyourunthescriptcontainingthefollowingstatement？（）

    CREATECONTROLFILEREUSEDATABASESALESNORESETLOGSARCHIVELOG

    MAXLOGFILES20

    MAXLOGMEMBERS3

    MAXDATAFILES30

    MAXINSTANCES10

    MAXLOGHISTORY1200

    LOGFILE

    GROUP1（

    ’/disk1/prod/orders/db/log1a.dbf’，

    ’/disk2/prod/orders/db/log1b.dbf’

    ）SIZE100K

    GROUP2（

    ’/disk1/prod/orders/db/log2a.dbf’，

    ’/disk2/prod/orders/db/log2b.dbf’

    ）SIZE100K，

    DATAFILE

    ’/disk1/prod/orders/db/database1.dbf’，

    ’/disk2/prod/orders/db/file1.dbf’；


    参考答案：B

  • 第3题：

    你公司有一个单一ActiveDirectory域。所有服务器运行windowsserver2008.你有一个名为FS1的服务器,安装有文件服务角色。下图展示了磁盘配置。你需要创建一个新的卷来支持具有奇偶校验的数据条带化。怎么做?()

    A.添加一个磁盘，创建一个新的RAID-5卷

    B.用disk1和disk2创建一个带区卷

    C.用disk1和disk2创建一个镜像卷

    D.用disk1和disk2创建一个跨区卷


    参考答案：A

  • 第4题：

    重新启动PLC时，使用CE操作重启PLC，尽量不要断CX1020的24V供电电源重启，因为容易造成hard disk2 丢失


    正确答案:正确

  • 第5题：

    In which situation will you run the script containing the following statement？（）   CREATE CONTROLFILE REUSE DATABASE SALES NORESETLOGS ARCHIVELOG        MAXLOGFILES 20        MAXLOGMEMBERS 3        MAXDATAFILES 30        MAXINSTANCES 10        MAXLOGHISTORY 1200        LOGFILE        GROUP 1 （   ’/disk1/prod/orders/db/log1a.dbf’，        ’/disk2/prod/orders/db/log1b.dbf’        ）SIZE 100K        GROUP 2 （   ’/disk1/prod/orders/db/log2a.dbf’，        ’/disk2/prod/orders/db/log2b.dbf’        ） SIZE 100K，        DATAFILE   ’/disk1/prod/orders/db/database1.dbf’，                                           ’/disk2/prod/orders/db/file1.dbf ’；  

    • A、 when all the control files are missing and only a binary backup of the current control file exists
    • B、 when a multiplexed copy of the current control file is missing
    • C、 when all the control files are missing and only an ASCII representation of the binary control file exists
    • D、 when the SPFILE is missing

    正确答案:B

  • 第6题：

    You want to set the following initialization parameters for your database instance：   LOG_ARCHIVE_DEST_1 = ’LOCATION=/disk1/arch’ LOG_ARCHIVE_DEST_2 = ’LOCATION=/disk2/arch’ LOG_ARCHIVE_DEST_3 = ’LOACTION=/disk3/arch’ LOG_ARCHIVE_DEST_4 = ’LOCATION=/disk4/arch MANDATORY’   Identify the statement that correctly describes this setting.（）  

    • A、 The MANDATORY location must be a flash recovery area.
    • B、 The optional destinations may not use the flash recovery area.
    • C、 This setting is not allowed because the first destination is not set as MANDATORY.
    • D、 The online redo log file is not allowed to be overwritten if the archived log cannot be created in the fourth destination.

    正确答案:D

  • 第7题：

    You have just added three new hard disks to your Windows 2000 Professional computer. You want to configure all of the disks as two drives. You want the two drives to be as equal in size as possible. You want to configure the non-system drive for the best optimal performance.  What should you do?（）

    • A、Extend the system volume onto disk1. Create a single, stripe volume from disk2 and disk3.
    • B、Extend the system volume onto disk2. Create a single, stripe volume from disk1 and disk2
    • C、Extend the system volume onto disk1. Create a single, spanned volume from disk2 and disk3. 
    • D、Extend the system volume onto disk1. Create a single, spanned volume from disk1 and disk2.
    • E、Create a single, stripe volume from disk1, disk2, and disk3. 
    • F、Create a single spanned volume from disk1, disk2, and disk3. 

    正确答案:A

  • 第8题：

    单选题
    If a system administrator wants to show only a disk report for disk2, at two second intervals, what is the correct command to run?（）
    A

     iostat disk1 1 

    B

     iostat -d disk1 2 

    C

     iostat disk2 1 

    D

     iostat -d disk2 2


    正确答案： C
    解析： 暂无解析

  • 第9题：

    单选题
    You are working as a DBA in an organization. The flash recovery area files are created in ’+disk1’. You want to create new flash recovery area files in the ’+disk2’ location. The new location of the flash recovery area files should be written in the control file and the spfile.Which command will you issue to change the location of the flash recovery area files？（）
    A

     ALTER SYSTEM SET DB_RECOVERY_FILE_DEST = ’+disk2’ ；

    B

     ALTER SYSTEM SET DB_RECOVER_FILE_DEST = ’+disk2’ SCOPE = BOTH；

    C

     ALTER SYSTEM SET DB_CREATE_FILE_DEST = ’+disk2’；

    D

     ALTER SYSTEM SET DB_CREATE_ONLINE_LOG_DEST_n = ’+disk2’；


    正确答案： A
    解析： 暂无解析

  • 第10题：

    单选题
    You want to set the following initialization parameters for your database instance：   LOG_ARCHIVE_DEST_1 = ’LOCATION=/disk1/arch’ LOG_ARCHIVE_DEST_2 = ’LOCATION=/disk2/arch’ LOG_ARCHIVE_DEST_3 = ’LOACTION=/disk3/arch’ LOG_ARCHIVE_DEST_4 = ’LOCATION=/disk4/arch MANDATORY’   Identify the statement that correctly describes this setting.（）
    A

     The MANDATORY location must be a flash recovery area.

    B

     The optional destinations may not use the flash recovery area.

    C

     This setting is not allowed because the first destination is not set as MANDATORY.

    D

     The online redo log file is not allowed to be overwritten if the archived log cannot be created in the fourth destination.


    正确答案： D
    解析： 暂无解析

  • 第11题：

    单选题
    You are managing an ASM instance. You previously issued the following statements：   ALTER DISKGROUP dg1 DROP DISK disk2；  ALTER DISKGROUP dg1 DROP DISK disk3；  ALTER DISKGROUP dg1 DROP DISK disk5；   You want to cancel the disk drops that are pending for the DG1 disk group.  Which statement should you issue？（）
    A

     ALTER DISKGROUP dg1 UNDROP disk2，disk3，disk5

    B

     ALTER DISKGROUP dg1 UNDROP

    C

     ALTER DISKGROUP dg1 UNDROP DISKS

    D

     You cannot cancel the pending disk drops


    正确答案： B
    解析： 暂无解析

  • 第12题：

    单选题
    In which situation will you run the script containing the following statement？（）   CREATE CONTROLFILE REUSE DATABASE SALES NORESETLOGS ARCHIVELOG        MAXLOGFILES 20        MAXLOGMEMBERS 3        MAXDATAFILES 30        MAXINSTANCES 10        MAXLOGHISTORY 1200        LOGFILE        GROUP 1 （   ’/disk1/prod/orders/db/log1a.dbf’，        ’/disk2/prod/orders/db/log1b.dbf’        ）SIZE 100K        GROUP 2 （   ’/disk1/prod/orders/db/log2a.dbf’，        ’/disk2/prod/orders/db/log2b.dbf’        ） SIZE 100K，        DATAFILE   ’/disk1/prod/orders/db/database1.dbf’，                                           ’/disk2/prod/orders/db/file1.dbf ’；
    A

     when all the control files are missing and only a binary backup of the current control file exists

    B

     when a multiplexed copy of the current control file is missing

    C

     when all the control files are missing and only an ASCII representation of the binary control file exists

    D

     when the SPFILE is missing


    正确答案： A
    解析： 暂无解析

  • 第13题：

    YouareworkingasaDBAinanorganization.Theflashrecoveryareafilesarecreatedin’+disk1’.Youwanttocreatenewflashrecoveryareafilesinthe’+disk2’location.Thenewlocationoftheflashrecoveryareafilesshouldbewritteninthecontrolfileandthespfile.Whichcommandwillyouissuetochangethelocationoftheflashrecoveryareafiles？（）

    A.ALTERSYSTEMSETDB_RECOVERY_FILE_DEST=’+disk2’；

    B.ALTERSYSTEMSETDB_RECOVER_FILE_DEST=’+disk2’SCOPE=BOTH；

    C.ALTERSYSTEMSETDB_CREATE_FILE_DEST=’+disk2’；

    D.ALTERSYSTEMSETDB_CREATE_ONLINE_LOG_DEST_n=’+disk2’；


    参考答案：B

  • 第14题：

    You are the network administrator for Ezonexam. You are installing Windows 2000 Server on a new computer by using the Windows 2000 Server compact disk. The computer has five 18-GB hard disks Dick0, Disk1, Disk2, Disk3, and Disk4. The disks do not have any partitions defined.

    You want to use as much space on Disk0 as possible for the partition on which Windows 2000 Server is installed. You want the disk on which you install Windows 2000 Server to be fault tolerant. You also want as much disk space as possible across the other disks to be available for data storage and to be fault tolerant.

    What should you do? (Each correct answer presents part of the solution. Choose three)

    A. Install Windows 2000 Server on a 4-GB NTFS partition on Disk 0. Configure the five disks as dynamic disks.

    B. Install Windows 2000 Server on a 18-GB NTFS partition on Disk 0. Configure the five disks as dynamic disks.

    C. Create a RAID-5 volume using Disk2, Disk3, and Disk4.

    D. Create a stripped volume using Disk2, Disk3, and Disk4.

    E. Create a RAID-5 volume using all disks.

    F. Create a stripped volume using all disks.

    G. Select the volume on Disk0 and add a mirror using Disk1.


    正确答案：BCG
    B,C,G 解析：Explanation: RAID-5 volume is where data is written to 3 to 32 physical disks at the same rate, and is interlaced with parity to provide fault tolerance for a single disk failure. Good read performance; good utilization of disk capacity; expensive in terms of processor utilization and write performance as parity must be calculated during write operations.

    Only Windows 2000 supports dynamic storage. To support dynamic storage, a single partition is created that includes the entire disk. A disk that you initialize for dynamic storage is a dynamic disk. Dynamic disks are divided into volumes, which can consist of a portion or portions of one or more physical disks. A dynamic disk can contain simple volumes, spanned volumes, striped volumes (RAID-0), mirrored volumes (RAID-1), and striped with parity volumes (RAID-5). You create a dynamic disk by upgrading a basic disk. A Mirrored volume is where two disks contain identical copies of data. The only software RAID supported on the system volume. Good read and write performance; excellent fault tolerance; but costly in terms of disk utilization, because 50 percent of the volume's potential capacity is used for data redundancy.

    Incorrect answers:
    A: It is not necessary to install Windows 2000 Server on a 4-GB NTFS partition on Disk0. Disk0 consists of 18-GB.

    D: Striped volume is where data is written to 2 to 32 physical disks at the same rate. It offers maximum performance and capacity but no fault tolerance.

    E: The main disadvantage of a RAID-5 volume is that once a drive fails, system performance suffers until you rebuild the RAID-5 volume. This is because the parity information must be recalculated through memory to reconstruct the missing drive. If more than one drive fails, the RAID-5 volume becomes inaccessible. This does not bode well for fault tolerance as is required in this question.

    F: Striped volumes do not provide fault tolerance.

  • 第15题：

    YouissuethisSQLstatement:ALTERDATABASERENAMEFILE’／ORADATA／u02／user_data01.dbf’TO’／ORADATA／u04／user_data01.dbf’;WhatdoesthisSQLstatementdo?()

    A.Itupdatesthecontrolfilewiththenewlocationofthedatafile.

    B.Itupdatesonlythedatadictionarywiththenewlocationofthedatafile.

    C.Itchangesthelocationoftheuser_data01.dbffileintheoperatingsystem.

    D.Itchangesthelocationoftheuser_data01.dbffileintheoperatingsystemandupdatesthecontrolfilewiththenewlocationofthedatafile.


    参考答案：A

  • 第16题：

    If a system administrator wants to show only a disk report for disk2, at two second intervals, what is the correct command to run?（）

    • A、 iostat disk1 1 
    • B、 iostat -d disk1 2 
    • C、 iostat disk2 1 
    • D、 iostat -d disk2 2

    正确答案:D

  • 第17题：

    You want to set the following Initialization parameters for your database Instance   LOG_ARCHIVE_DEBT_1 = ，，LOCATION=/disk1/arch LOG_ARCHIVE_DBST_2 = ，，LOCATION=/disk2/arch LOC_ARCHIVB DBST_3 = ，，LOCATION=/disk3/arch LOG_ARCHIVE DBST_ = ，，LOCATION=/disk3/arch   Identify the statement that correctly describes this setting.（）  

    • A、 The MANDATORY location must be a flash recovery area.
    • B、 The optional destinations may not use the flash recovery area.
    • C、 This setting is not allowed because the first destination is not set as MANDATORY.
    • D、 The online redo log file is not allowed to be overwritten if the archived log cannot be created in the fourth destination.

    正确答案:D

  • 第18题：

    You have the following online redo log configuration：    Group       Member   1     ’/disk1/oradata/redo01a.log’   2     ’/disk2/oradata/redo02a.log’   3     ’/disk3/oradata/redo03a.log’   You decide to multiplex the online redo log groups for recovery of redo log files in case of any disaster. Which two statements will you NOT issue to multiplex the online redo log files？（）

    • A、 ALTER DATABASE ADD LOGFILE MEMBER ’/disk1/oradata/redo01b.log’ TO GROUP 1；
    • B、 ALTER DATABASE ADD LOGFILE MEMBER ’/disk2/oradata/redo01b.log’ TO GROUP 1；
    • C、 ALTER DATABASE ADD LOGFILE MEMBER ’/disk1/oradata/redo02b.log’ TO GROUP 2；
    • D、 ALTER DATABASE ADD LOGFILE MEMBER ’/disk2/oradata/redo02b.log’ TO GROUP 2；
    • E、 ALTER DATABASE ADD LOGFILE MEMBER ’/disk1/oradata/redo3b.log’ TO GROUP 3；
    • F、 ALTER DATABASE ADD LOGFILE MEMBER ’/disk2/oradata/redo3b.log’ TO GROUP3；

    正确答案:A,C

  • 第19题：

    判断题
    重新启动PLC时，使用CE操作重启PLC，尽量不要断CX1020的24V供电电源重启，因为容易造成hard disk2 丢失
    A

    对

    B

    错


    正确答案： 对
    解析： 暂无解析

  • 第20题：

    单选题
    You have configured flash recovery area in your database and you set the following Initialization parameters for your database instance：   LOG_ARCHIVE_DEST 1 = ，，LOCATION=/disk1/arch MANDATORY’  LOG _ARCHIEVE_DEST 2 = ，，LOCATION=/disk2/arch’ LOG_ARCHIVK_DEST_3 = ，，LOCATION=/diSk3/arch  LOG_ARCH1VK_DEST_4 = ’ LOCATION=/disk4/arch’  LOG_ARCHIVE_MIN-SUCCEED_DEST = 2   While the database instance is functional，you realized that the destination set by the  LOG_ARCHIVE_DEST_I parameter Is not available for the archived redo log file to be created in. All redo log groups have been used.  What happens in an event of log switch？（）
    A

     The online redo log file Is not allowed to be overwritten.

    B

     The archived redo log files are written to the flash recovery area until the MANDATORY destination is made available.

    C

     The database instance will crash because the archived redo log file cannot be created in a destination set as MANDATORY.

    D

     The destination set by the LOG_ARCHIVE_DEST_1 parameter is ignored and the archived redo log files are created in the next two available locations to guarantee archive log success.


    正确答案： D
    解析： 暂无解析

  • 第21题：

    单选题
    Examine the RMAN command： SWITCH DATAFILE ’/DISK3/user_data01.dbf’； Which command do you need to issue before you issue the above command， so that RMAN finds the file in the restored location of ’DISK2/user_data01.dbf’？ （）
    A

    RESTORE DATAFILE ’/DISK2/user_data01.dbf’

    B

    RESTORE DATAFILE ’/DISK3/user_data01.dbf’

    C

    SET NEWNAME FOR ’/DISK3/user_data01.dbf’ TO’/DISK2/user_data01.dbf’

    D

    SET NEWNAME FOR ’/DISK2/user_data01.dbf’ TO’/DISK3/user_data01.dbf’


    正确答案： D
    解析： 暂无解析

  • 第22题：

    单选题
    You issue this SQL statement：  ALTER DATABASE RENAME FILE ’/ORADATA/u02/user_data01.dbf’ TO ’/ORADATA/u04/user_data01.dbf’；  What does this SQL statement do？（）
    A

    It updates the control file with the new location of the data file. 

    B

    It updates only the data dictionary with the new location of the data file. 

    C

    It changes the location of the user_data01.dbf file in the operating system. 

    D

    It changes the location of the user_data01.dbf file in the operating system and updates the control file with the new location of the data file.


    正确答案： B
    解析： 暂无解析

  • 第23题：

    单选题
    You have just added three new hard disks to your Windows 2000 Professional computer. You want to configure all of the disks as two drives. You want the two drives to be as equal in size as possible. You want to configure the non-system drive for the best optimal performance. What should you do?（）
    A

     Extend the system volume onto disk1. Create a single, stripe volume from disk2 and disk3. 

    B

     Extend the system volume onto disk2. Create a single, stripe volume from disk1 and disk2. 

    C

     Extend the system volume onto disk1. Create a single, spanned volume from disk2 and disk3. 

    D

     Extend the system volume onto disk1. Create a single, spanned volume from disk1 and disk2. 

    E

     Create a single, stripe volume from disk1, disk2, and disk3.

    F

     Create a single spanned volume from disk1, disk2, and disk3. 


    正确答案： B
    解析： Configuring the non-system volume as a striped volume will realize the best performance gainsinthis scenario. The system volume is extended onto disk1， which makes it size comparable to the non-system drive.

相关内容