单选题There is a problem with one of the disks used for your database and your system administrator informs you that the disk needs to be replaced. The replacement disk will not be available until tomorrow. There was only one data file on this disk； it belongs to the USERS tablespace in your PROD database. Your PROD database runs in ARCHIVELOG mode and nightly online backups are taken. The users need to be able to access the data in the USERS tablespace before the replacement disk arrives. You have already taken the USERS tablespace offline and have restored the data file from last night’s backup to a new disk. Which additional steps are required in order to make the USERS tablespace available？（）AOnly bring the tablespace back online.BOnly recover the tablespace and then bring the tablespace back online.CShut down the database， recover the data file and then start up the database.DIssue the ALTER DATABASE RENAME FILE command， recover the tablespace， and then bring the tablespace online.ERecover the tablespace， issue the ALTER DATABASE RENAME FILE command， and then bring the tablespace online.
单选题
There is a problem with one of the disks used for your database and your system administrator informs you that the disk needs to be replaced. The replacement disk will not be available until tomorrow. There was only one data file on this disk； it belongs to the USERS tablespace in your PROD database. Your PROD database runs in ARCHIVELOG mode and nightly online backups are taken. The users need to be able to access the data in the USERS tablespace before the replacement disk arrives. You have already taken the USERS tablespace offline and have restored the data file from last night’s backup to a new disk. Which additional steps are required in order to make the USERS tablespace available？（）
A
Only bring the tablespace back online.
B
Only recover the tablespace and then bring the tablespace back online.
C
Shut down the database， recover the data file and then start up the database.
D
Issue the ALTER DATABASE RENAME FILE command， recover the tablespace， and then bring the tablespace online.
E
Recover the tablespace， issue the ALTER DATABASE RENAME FILE command， and then bring the tablespace online.
参考解析
解析：
暂无解析
相关考题：
A data file became corrupted in your database due to bad sectors on the disk. Because of corruption， you lost all the important tables in that data file. Which method would you use for recovery？（）A、flash back all the tables in the data file， one by oneB、restore the data file to a new location and perform a media recoveryC、flash back the database; there is no need to restore the data fileD、restore the data file from the most recent backup and flash back the database
Your database is running in ARCHIVELOG mode. One of the data files,USERDATA01.dbf, in the USERS tablespace is damaged and you need to recover the file until the point of failure. The backup for the datafile is available. Which three files would be used in the user-managed recovery process performed by the database administrator (DBA)?（）A、Redo logsB、Control fileC、The latest backup of only the damaged data fileD、The latest backup of all the data file in the USERS tablespaceE、Temporary files of temporary tablespaceF、Archive Logs since the latest backup to point of failure
Your database is running In ARCIIIVELOG mode. One of the data files， USBRDATAOI. DBF， in the users tablespace is damaged and you need to recover the file until the point of failure. The backup for the data file is available. Which three files would be used in the user-managed recovery process performed by the database administrator （DBA）？（） A、 redo logsB、 control fileC、 temporary files of temporary tablespaceD、 the latest backup of only the damaged data fileE、 the latest backup of all the data files In the USERS tablespace
You are managing an Oracle Database 11g ASM instance with a disk group dg01 having three disks. One of the disks in the disk group becomes unavailable because of power failure. You issued the following command to change the DISK_REPAIR_TIME attribute from 3.6 hours to 5 hours: ALTER DISKGROUP dg01 SET ATTRIBUTE 'disk_repair_time' = '5h'; To which disks in the disk group will the new value be applicable?（）A、all disks in the disk groupB、all disks that are currently in OFFLINE modeC、all disks that are not currently in OFFLINE modeD、all disks in the disk group only if all of them are ONLINE
You are using an Automatic Storage Management （ASM） instance to manage the files of your production database. You have two disk groups， DG1 and DG2， with one device each. In the parameter file of the production database， the following parameters have been specified： DB_CREATE_ONLINE_LOG_DEST_1 = ’+dg1’ DB_CREATE_ONLINE_LOG_DEST_2 = ’+dg2’ What would be the impact of this setting？（）A、When a new log group is added， it would have one member in each disk group.B、When a new log group is added， it would have two members in each disk group.C、When a new tablespace is added， it would have one data file in each disk group.D、When a new log file is added， it would have one member spread across the disk groups.
You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode. The database has been configured with three redo logs groups， and there have been five log switches. You lost one non-system-critical data file from your database. Which method would you use to recover the data file？（）A、Restore all the data files and open the databaseB、Create the data file and performtablespacerecoveryC、No need to restore any file， just recover the databaseD、Restore only the system data file and recover the databaseE、Restore only lost date file and performtablespacerecovery
A data file become corrupted in your database due to bad sectors on the disk. Because of corruption， you lost all the important tables in that data file. Which method would you use for recovery？（）A、 Flash back all the tables in the data file， one by one.B、 Restore the data file to a new location and perform a media recovery.C、 Flash back the database， there is no need to restore the data file.D、 Restore the data file from the most recent backup and flash the database.
You are an Oracle DBA responsible for an ASM instance. The disk controller on your system fails. You suspect that the disk itself is okay. You know it will take 24 hours to replace the controller and you don’t want to have to rebuild the disks from scratch. What do you do？（） A、 Take the whole disk group offline and wait for the controller card to be installed. Once it’s installed，bring the disk group online again.B、 Change the ASM parameter ASM_PREFERRED_READ_FAILURE_GROUPS to indicate that you want to read from the non-failed disk. Once the disk controller is replaced，reset the parameter to its original value.C、 You have no choice but to rebuild the disk. Drop the disk from the disk group and wait for the controller to be replaced. Once the controller is replaced， add the disk back into the disk group and allow ASM to rebuild it.D、 If you are using any setting other than REDUNDANCY EXTERNAL for your disk group，you will have to recover any data on that disk from a backup. The database will be unavailable until you can correct the problem and perform recovery.E、 Change the attribute DISK_REPAIR_TIME on the disk group to a time greater than 24 hours.
In which situations will the ASM metadata backup help you recover the ASM disk in a disk group？（）A、 when one or more file directory paths are accidentally deleted from an ASM disk groupB、 when one of the disks in a disk group is accidentaly unpluggedC、 when the data file on an ASM disk group gets corruptedD、 when one or more disks in an ASM disk group are lost
There is a problem with one of the disks used for your database and your system administrator informs you that the disk needs to be replaced. The replacement disk will not be available until tomorrow. There was only one data file on this disk； it belongs to the USERS tablespace in your PROD database. Your PROD database runs in ARCHIVELOG mode and nightly online backups are taken. The users need to be able to access the data in the USERS tablespace before the replacement disk arrives. You have already taken the USERS tablespace offline and have restored the data file from last night’s backup to a new disk. Which additional steps are required in order to make the USERS tablespace available？（）A、Only bring the tablespace back online.B、Only recover the tablespace and then bring the tablespace back online.C、Shut down the database， recover the data file and then start up the database.D、Issue the ALTER DATABASE RENAME FILE command， recover the tablespace， and then bring the tablespace online.E、Recover the tablespace， issue the ALTER DATABASE RENAME FILE command， and then bring the tablespace online.
Your database is configured on non-ASM disk storage. You need to migrate your database to ASM disk storage. Which statement is true about migrating from non-ASM disk storage to ASM disk storage？（） A、 You can use the operating system utility to migrate from non-ASM disk storage to ASM disk storage.B、 You cannot perform a database backup from non-ASM disk storage to tape and then move it to ASM disk storage.C、 You can use the SWITCH DATABASE TO COPY Recovery Manager （RMAN） command to switch back to non-ASM disk storage if you have not deleted your original datafiles.D、 You cannot use Recovery Manager （RMAN） to migrate from non-ASM disk storage to ASM disk storage if you are not using RMAN for your backup and recovery strategies.
You are the network administrator for All network servers run Windows Server 2003. A server named TK1 contains a mirrored volume that consists of two 36-GB disks. Both disks are used for data storage. TK1 also contains a third unallocated dynamic disk. Next week, a database that currently requires 45 GB of disk space will be installed on TK1. This database will grow at a rate of 10 percent every 6 months. You need to realocate disk space on TK1. Your realocation must satisfy the space requirements of the new database, and it must also ensure that data will remain available in case of disk failure. First, you break the mirror and delete all volumes on the disks. What should you do next?（）A、Create a spanned volume.B、Create a stripped volume.C、Create a mirrored volume.D、Create a RAID-5 volume.
You are configuring a failover cluster for a database server. You are assigning four nodes to the cluster. Allnodes have access to a SAN，and adequate storage is available. Which of the following options should youchoose for your quorum configuration？（）A、Node MajorityB、Node And Disk MajorityC、Node And File Share MajorityD、No Majority： Disk Only
You are the network administrator for your company. All network servers run Windows Server 2003.The network includes a file server named File1. File1 contains a single disk for system files and two SCSIhard disks that comprise a 72-GB mirrored volume with 65 GB of read-only data. Users connect to thisdata by using shortcuts on their desktops.File1 is scheduled for replacement. You have a scheduled maintenance window to complete this task.Before the maintenance window, you build a new server.You need to bring the new server online with current data and re-establish redundancy as quickly aspossible. You must also ensure that the desktop shortcuts will continue to function.What should you do? （）A、Name the new server File2. Create a new mirrored volume by using two 72-GB disks. Connect File2 to the network and copy the data from File1. When copying is complete, shut down the old File1.B、Name the new server File1. Move both disks from the old File1 to the new File1. Scan the disks for changes. Import the disks. Connect the new File1 to the network.C、Name the new server File1. Break the mirror on the old File1. Move one of the disks from the old File1 to the new File1. Scan the disk for changes. Initialize the disk. Select the spare disk and create the mirror. Connect the new File1 to the network.D、Name the new server File1. Remove one of the disks in the mirror from the old File1. Move the disk to the new File1. Scan the disk for changes. Import the disk. Shut down the old File1 and connect the new File1 to the network.
单选题You are the network administrator for your company. All network servers run Windows Server 2003. The network includes a file server named File1. File1 contains a single disk for system files and two SCSI hard disks that comprise a 72-GB mirrored volume with 65 GB of read-only data. Users connect to this data by using shortcuts on their desktops. File1 is scheduled for replacement. You have a scheduled maintenance window to complete this task. Before the maintenance window, you build a new server. You need to bring the new server online with current data and re-establish redundancy as quickly as possible. You must also ensure that the desktop shortcuts will continue to function. What should you do? （）AName the new server File2. Create a new mirrored volume by using two 72-GB disks. Connect File2 to the network and copy the data from File1. When copying is complete, shut down the old File1.BName the new server File1. Move both disks from the old File1 to the new File1. Scan the disks for changes. Import the disks. Connect the new File1 to the network.CName the new server File1. Break the mirror on the old File1. Move one of the disks from the old File1 to the new File1. Scan the disk for changes. Initialize the disk. Select the spare disk and create the mirror. Connect the new File1 to the network.DName the new server File1. Remove one of the disks in the mirror from the old File1. Move the disk to the new File1. Scan the disk for changes. Import the disk. Shut down the old File1 and connect the new File1 to the network.
单选题You are an Oracle DBA responsible for an ASM instance. The disk controller on your system fails. You suspect that the disk itself is okay. You know it will take 24 hours to replace the controller and you don’t want to have to rebuild the disks from scratch. What do you do？（）A Take the whole disk group offline and wait for the controller card to be installed. Once it’s installed，bring the disk group online again.B Change the ASM parameter ASM_PREFERRED_READ_FAILURE_GROUPS to indicate that you want to read from the non-failed disk. Once the disk controller is replaced，reset the parameter to its original value.C You have no choice but to rebuild the disk. Drop the disk from the disk group and wait for the controller to be replaced. Once the controller is replaced， add the disk back into the disk group and allow ASM to rebuild it.D If you are using any setting other than REDUNDANCY EXTERNAL for your disk group，you will have to recover any data on that disk from a backup. The database will be unavailable until you can correct the problem and perform recovery.E Change the attribute DISK_REPAIR_TIME on the disk group to a time greater than 24 hours.
单选题You are the administrator of Company.com’s Windows 2000 network. Your computer is configured to use both Windows 2000 Professional and Windows NT Workstation 4.0 Service Pack 3. Your computer has three hard disks: Disk 0, Disk1, and Disk2. Windows NT Workstation 4.0 is installed on Disk 0. Windows 2000 Professional is installed on Disk1. You want to store your project files on Disk2. You configure Disk2 as a basic volume and format the volume as NTFS in Windows 2000 Professional. You then start Windows NT Workstation 4.0. You find that you cannot access your project files. You want to be able to access your project files when using either operating systems. What should you do?（）AUpgrade Windows NT Workstation 4.0 to Service Pack 4 or later.BConfigure Disk 2 as a dynamic volume then format as an NTFS partition.CConfigure Disk 2 to use Encrypting File System （EFS）.DConfigure Disk 2 as a basic volume and forma the volume as FAT32.
单选题You are the network administrator for All network servers run Windows Server 2003. A server named TK1 contains a mirrored volume that consists of two 36-GB disks. Both disks are used for data storage. TK1 also contains a third unallocated dynamic disk. Next week, a database that currently requires 45 GB of disk space will be installed on TK1. This database will grow at a rate of 10 percent every 6 months. You need to realocate disk space on TK1. Your realocation must satisfy the space requirements of the new database, and it must also ensure that data will remain available in case of disk failure. First, you break the mirror and delete all volumes on the disks. What should you do next?（）ACreate a spanned volume.BCreate a stripped volume.CCreate a mirrored volume.DCreate a RAID-5 volume.
单选题You work as a database administrator for Supportcenter.cn. Your database is in NOARCHIVELOG mode. The database has been configured with three redo logs groups， and there have been five log switches. You lost one non-system-critical data file from your database. Which method would you use to recover the data file？（）ARestore all the data files and open the databaseBCreate the data file and perform tablespace recoveryCNo need to restore any file， just recover the databaseDRestore only the system data file and recover the databaseERestore only lost date file and performtablespacerecovery
单选题A data file become corrupted in your database due to bad sectors on the disk. Because of corruption， you lost all the important tables in that data file. Which method would you use for recovery？（）A Flash back all the tables in the data file， one by one.B Restore the data file to a new location and perform a media recovery.C Flash back the database， there is no need to restore the data file.D Restore the data file from the most recent backup and flash the database.
单选题You are configuring a failover cluster for a database server. You are assigning four nodes to the cluster. Allnodes have access to a SAN，and adequate storage is available. Which of the following options should youchoose for your quorum configuration？（）ANode MajorityBNode And Disk MajorityCNode And File Share MajorityDNo Majority： Disk Only
单选题You are using an Automatic Storage Management （ASM） instance to manage the files of your production database. You have two disk groups， DG1and DG2with one device each. In the parameter file of the production database， the following parameters have been specified： DB_CREATE_ONLINE_LOG_DEST_1 = ’+dg1’ DB_CREATE_ONLINE_LOG_DEST_2 = ’+dg2’ What would be the impact of this setting？（）A When a new log group is added， it would have one member in each disk group.B When a new log group is added， it would have two members in each disk group.C When a new tablespace is added， it would have one data file in each disk group.D When a new log file is added， it would have one member spread across the disk groups.
单选题You are using an Automatic Storage Management （ASM） instance to manage the files of your production database. You have two disk groups， DG1 and DG2， with one device each. In the parameter file of the production database， the following parameters have been specified： DB_CREATE_ONLINE_LOG_DEST_1 = ’+dg1’ DB_CREATE_ONLINE_LOG_DEST_2 = ’+dg2’ What would be the impact of this setting？（）AWhen a new log group is added， it would have one member in each disk group.BWhen a new log group is added， it would have two members in each disk group.CWhen a new tablespace is added， it would have one data file in each disk group.DWhen a new log file is added， it would have one member spread across the disk groups.
单选题You are the network administrator for your company. All network servers run Windows Server 2003.The network includes a file server named File1. File1 contains a single disk for system files and two SCSIhard disks that comprise a 72-GB mirrored volume with 65 GB of read-only data. Users connect to thisdata by using shortcuts on their desktops.File1 is scheduled for replacement. You have a scheduled maintenance window to complete this task.Before the maintenance window, you build a new server.You need to bring the new server online with current data and re-establish redundancy as quickly aspossible. You must also ensure that the desktop shortcuts will continue to function.What should you do? （）AName the new server File2. Create a new mirrored volume by using two 72-GB disks. Connect File2 to the network and copy the data from File1. When copying is complete, shut down the old File1.BName the new server File1. Move both disks from the old File1 to the new File1. Scan the disks for changes. Import the disks. Connect the new File1 to the network.CName the new server File1. Break the mirror on the old File1. Move one of the disks from the old File1 to the new File1. Scan the disk for changes. Initialize the disk. Select the spare disk and create the mirror. Connect the new File1 to the network.DName the new server File1. Remove one of the disks in the mirror from the old File1. Move the disk to the new File1. Scan the disk for changes. Import the disk. Shut down the old File1 and connect the new File1 to the network.
单选题A data file became corrupted in your database due to bad sectors on the disk. Because of corruption， you lost all the important tables in that data file. Which method would you use for recovery？（）Aflash back all the tables in the data file， one by oneBrestore the data file to a new location and perform a media recoveryCflash back the database; there is no need to restore the data fileDrestore the data file from the most recent backup and flash back the database
单选题There is a problem with one of the disks used for your database and your system administrator informs you that the disk needs to be replaced. The replacement disk will not be available until tomorrow. There was only one data file on this disk； it belongs to the USERS tablespace in your PROD database. Your PROD database runs in ARCHIVELOG mode and nightly online backups are taken. The users need to be able to access the data in the USERS tablespace before the replacement disk arrives. You have already taken the USERS tablespace offline and have restored the data file from last night’s backup to a new disk. Which additional steps are required in order to make the USERS tablespace available？（）AOnly bring the tablespace back online.BOnly recover the tablespace and then bring the tablespace back online.CShut down the database， recover the data file and then start up the database.DIssue the ALTER DATABASE RENAME FILE command， recover the tablespace， and then bring the tablespace online.ERecover the tablespace， issue the ALTER DATABASE RENAME FILE command， and then bring the tablespace online.
单选题You are managing an Oracle Database 11g ASM instance with a disk group dg01 having three disks. One of the disks in the disk group becomes unavailable because of power failure. You issued the following command to change the DISK_REPAIR_TIME attribute from 3.6 hours to 5 hours: ALTER DISKGROUP dg01 SET ATTRIBUTE 'disk_repair_time' = '5h'; To which disks in the disk group will the new value be applicable?（）Aall disks in the disk groupBall disks that are currently in OFFLINE modeCall disks that are not currently in OFFLINE modeDall disks in the disk group only if all of them are ONLINE
多选题Your database is running In ARCIIIVELOG mode. One of the data files， USBRDATAOI. DBF， in the users tablespace is damaged and you need to recover the file until the point of failure. The backup for the data file is available. Which three files would be used in the user-managed recovery process performed by the database administrator （DBA）？（）Aredo logsBcontrol fileCtemporary files of temporary tablespaceDthe latest backup of only the damaged data fileEthe latest backup of all the data files In the USERS tablespace