网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
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’
参考答案
更多 “ 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’ ” 相关考题
考题
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.
考题
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？（）
考题
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.
考题
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；
考题
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.
考题
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’；
考题
Inwhichsituationwillyourunthescriptcontainingthefollowingstatement？（）CREATECONTROLFILEREUSEDATABASESALESNORESETLOGSARCHIVELOGMAXLOGFILES20MAXLOGMEMBERS3MAXDATAFILES30MAXINSTANCES10MAXLOGHISTORY1200LOGFILEGROUP1（’/disk1/prod/orders/db/log1a.dbf’，’/disk2/prod/orders/db/log1b.dbf’）SIZE100KGROUP2（’/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’；
考题
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.
考题
你公司有一个单一ActiveDirectory域。所有服务器运行windowsserver2008.你有一个名为FS1的服务器,安装有文件服务角色。下图展示了磁盘配置。你需要创建一个新的卷来支持具有奇偶校验的数据条带化。怎么做?()
A.添加一个磁盘，创建一个新的RAID-5卷B.用disk1和disk2创建一个带区卷C.用disk1和disk2创建一个镜像卷D.用disk1和disk2创建一个跨区卷
考题
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.
考题
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
考题
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 existsB、 when a multiplexed copy of the current control file is missingC、 when all the control files are missing and only an ASCII representation of the binary control file existsD、 when the SPFILE is missing
考题
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.
考题
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.
考题
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；
考题
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 disk2C、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.
考题
单选题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
考题
单选题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.
考题
单选题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’；
考题
单选题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’
考题
单选题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.
考题
单选题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.
考题
单选题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，disk5B
ALTER DISKGROUP dg1 UNDROPC
ALTER DISKGROUP dg1 UNDROP DISKSD
You cannot cancel the pending disk drops
考题
单选题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.
考题
单选题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 existsB
when a multiplexed copy of the current control file is missingC
when all the control files are missing and only an ASCII representation of the binary control file existsD
when the SPFILE is missing
热门标签
最新试卷
