itgle.com

单选题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 belo

题目
单选题
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.

相似考题

1. 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

2. 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

3. 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

4.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

更多“单选题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 belo”相关问题

  • 第1题：

    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.

    正确答案:A

  • 第2题：

    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.

    正确答案:B

  • 第3题：

    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 group
    • B、 when one of the disks in a disk group is accidentaly unplugged
    • C、 when the data file on an ASM disk group gets corrupted
    • D、 when one or more disks in an ASM disk group are lost

    正确答案:A,D

  • 第4题：

    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.

    正确答案:C

  • 第5题：

    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 Majority
    • B、Node And Disk Majority
    • C、Node And File Share Majority
    • D、No Majority： Disk Only

    正确答案:B

  • 第6题：

    单选题
    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? （）
    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.


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

  • 第7题：

    单选题
    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?（）
    A

    Upgrade Windows NT Workstation 4.0 to Service Pack 4 or later.

    B

    Configure Disk 2 as a dynamic volume then format as an NTFS partition.

    C

    Configure Disk 2 to use Encrypting File System （EFS）.

    D

    Configure Disk 2 as a basic volume and forma the volume as FAT32.


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

  • 第8题：

    单选题
    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？（）
    A

    Restore all the data files and open the database

    B

    Create the data file and perform tablespace recovery

    C

    No need to restore any file， just recover the database

    D

    Restore only the system data file and recover the database

    E

    Restore only lost date file and performtablespacerecovery


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

  • 第9题：

    单选题
    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 Majority

    B

    Node And Disk Majority

    C

    Node And File Share Majority

    D

    No Majority： Disk Only


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

  • 第10题：

    单选题
    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.


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

  • 第11题：

    单选题
    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 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 back the database


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

  • 第12题：

    单选题
    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 group

    B

    all disks that are currently in OFFLINE mode

    C

    all disks that are not currently in OFFLINE mode

    D

    all disks in the disk group only if all of them are ONLINE


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

  • 第13题：

    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 database
    • B、Create the data file and performtablespacerecovery
    • C、No need to restore any file， just recover the database
    • D、Restore only the system data file and recover the database
    • E、Restore only lost date file and performtablespacerecovery

    正确答案:A

  • 第14题：

    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.

    正确答案:E

  • 第15题：

    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.

    正确答案:D

  • 第16题：

    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.

    正确答案:D

  • 第17题：

    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.

    正确答案:B

  • 第18题：

    单选题
    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.


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

  • 第19题：

    单选题
    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.


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

  • 第20题：

    单选题
    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.


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

  • 第21题：

    单选题
    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.


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

  • 第22题：

    单选题
    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.


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

  • 第23题：

    单选题
    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.


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

  • 第24题：

    多选题
    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 logs

    B

    control file

    C

    temporary files of temporary tablespace

    D

    the latest backup of only the damaged data file

    E

    the latest backup of all the data files In the USERS tablespace


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

相关内容