单选题At database startup， you discover that one of the disks containing an index tablespace has been lost due to a media failure. A backup of the lost index tablespace is not available. You have all the necessary scripts to recreate the indexes. You need to re-create the indexes in a new index tablespace. Which action must you perform before re-creating the indexes？（）A Start the database in OPEN mode， and create a new index tablespace.B Start the database in OPEN mode， and drop the lost index tablespace from the database.CStart the database in MOUNT mode， create a new index tablespace， and drop the lost index tablespace from the database.D Start the database in MOUNT mode， drop the lost index tablespace from the database， open the database， and create a new index tablespace.
单选题
At database startup， you discover that one of the disks containing an index tablespace has been lost due to a media failure. A backup of the lost index tablespace is not available. You have all the necessary scripts to recreate the indexes. You need to re-create the indexes in a new index tablespace. Which action must you perform before re-creating the indexes？（）
A
Start the database in OPEN mode， and create a new index tablespace.
B
Start the database in OPEN mode， and drop the lost index tablespace from the database.
C
Start the database in MOUNT mode， create a new index tablespace， and drop the lost index tablespace from the database.
D
Start the database in MOUNT mode， drop the lost index tablespace from the database， open the database， and create a new index tablespace.
参考解析
解析：
暂无解析
相关考题：
You are the administrator of a SQL Server 2000 computer. You have two new hard disks on which you will create a database named inventory. You want to insert, update, and delete data as quickly as possible.Which two actions should you take? (Each correct answer presents parts of the solution. Choose two)A. Configure the hard disks as two mirrored NTFS volumes.B. Configure the hard disks as one mirrored NTFS volumes.C. Configure the hard disks as two independent NTFS volumes.D. Configure the hard disks as one extended NTFS volume.E. Place inventory_data.mdf on the first volume and inventory_log.ldf on the second volume.F. Place inventory_data.mdf on the first volume and inventory_data2.ndf and inventory_log.ldf on the second volume.G. Place inventory_data.mdf and inventory_log.ldf on the same volume.
You are the administrator of a SQL Server computer. Users report that the database times out when they attempt to modify data. You use the Current Activity window to examine locks held in the database as shown in the following screenshot.You need to discover why users cannot modify data in the database, but you do not want to disrupt normal database activities. What should you do?A．Use the spid 52 icon in the Current Activity window to discover which SQL statement is being executedB．Use the sp_who stored procedure to discover who is logged in as spid 52C．Use SQL Profiler to capture the activity of the user who is logged in as spid 52D．Use System Monitor to log the locks that are granted in the database
At database startup， you discover that one of the disks containing an index tablespace has been lost due to a media failure. A backup of the lost index tablespace is not available. You have all the necessary scripts to recreate the indexes. You need to re-create the indexes in a new index tablespace. Which action must you perform before re-creating the indexes？（）A、 Start the database in OPEN mode， and create a new index tablespace.B、 Start the database in OPEN mode， and drop the lost index tablespace from the database.C、Start the database in MOUNT mode， create a new index tablespace， and drop the lost index tablespace from the database.D、 Start the database in MOUNT mode， drop the lost index tablespace from the database， open the database， and create a new index tablespace.
You are in the middle of a transaction and very crucial data has been modified. Because of a hardware failure， the instance has shut down before synchronizing all the database files. Which two statements are true？（）A、On startup， SMON coordinates instance recovery.B、On startup， CKPT coordinates instance recovery.C、On startup， use RMAN to perform instance recovery.D、Uncommitted changes will be rolled back after the database is opened.E、On startup， perform media recovery and then instance recovery.F、On startup， all the files will be synchronized and you get both committed and uncommitted data.
A new LPAR has been created that needs SAN attached disk for a database. After AIX has been installed, the fibre cables are attached to the adapters. How should the administrator configure the disks?（）A、Run 'mkdev' to force the FC adapter to log into the SAN, have the SAN LUNs zoned to the server, run 'cfgmgr' to discover and configure the disks.B、Run 'mkpath' to force the FC adapter to log into the SAN, have the SAN LUNs zoned to the server, run 'cfgmgr' to discover and configure the disks.C、Run 'chpath' to force the FC adapter to log into the SAN, have the SAN LUNs zoned to the server, run 'cfgmgr' to discover and configure the disks.D、Run 'cfgmgr' to force the FC adapter to log into the SAN, have the SAN LUNs zoned to the server, run 'cfgmgr' to discover and configure the disks.
You are working as a DBA at NetFx Corporation. You discover that the SCOTT schema is deleted by mistake. You decide to flash the database back to the time when the schema existed. Which view will you query to determine the estimated size of the flashback data that you require for your current target retention？（）A、 V$FLASHBACK_DATABASE_LOGB、 V$FLASHBACK_DATABASE_STATC、 V$DATABASED、 V$UNDOSTAT
You have joined a new organization as a Database Administrator. The Security Administrator in your organization has kept human errors， such as erroneously dropping users， tables， and important data， to a minimum by carefully granting only the necessary privileges to each user. As a result of several ongoing transactions within your database， you discover that the flashback logs are rapidly increasing in the flash recovery area. To avoid out-of-space errors， you decide to delete the flashback logs from the flash recovery area. How can you delete the flashback logs from the database if your database is up and running？（）A、 Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command and disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.B、 Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement while the database is up and running.C、 Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command. Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement. Disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.D、 Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement. Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command and disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.
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 the control filesB、dropping a user in your databaseC、enabling or disabling redo log archivingD、dropping a tablespace in your databaseE、re-creating the control files， after you lost all the control files in your database
You are managing a single instance Oracle 10g database that utilizes the following parameters： Which of the following set of commands must you execute to enable Flashback Database？（）A、 STARTUP MOUNT EXCLUSIVE ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN；B、 STARTUP MOUNT ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN RESETLOGS；C、 STARTUP MOUNT EXCLUSIVE ATLER DATABASE ARCHIVELOG； ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN RESETLOGS；D、 STARTUP MOUNT ALTER DATABASE ARCHIVELOG； ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN；
You are the Database Administrator for WonderWeb， which has recently acquired a media company TXGlobal. You have been assigned the task to migrate all the database applications of TXGlobal to the database server of WonderWeb. To accommodate more database applications， you need to add disks to the existing disk group. Whenever you add or remove disks from the disk group， Automatic Storage Management （ASM） rebalancing distributes the data evenly across all the disks of the disk group. Which background process performs this actual rebalancing activity， resulting in the movement of data extents in the disk groups？（） A、 ASMBB、 ARBnC、 RBAL in the ASM instanceD、 RBAL in the database instance
You are managing an Oracle Database 11g ASM instance having three disks in a disk group with ASM compatibility attribute set to 11.1.0 and redundancy set to high. One of the disks in the disk group becomes unavailable because of power failure. Which statements will be true in this scenario？（）A、 The disk is immediately dropped from the disk group.B、 The ASM tracks the extents that are modified during the outaC、 The ASM migrates the extents from the unavailable disk to the remaining disks.D、 The disk automatically goes offline.
Your database is in ARCHIVELOG mode. You have two online redo log groups each of which contains one redo member. When you attempt to start the database， you receive the following errors： ORA-00313： open failed for members of log group 1 of thread 1 ORA-00312： online log 1 thread 1： ’D:///REDO01.LOG’ You discover that the online redo log file of the current redo group is corrupted. Which statement should you use to resolve this issue？（）A、 SQLALTER DATABASE DROP LOGFILE GROUP 1；B、 SQLALTER DATABASE CLEAR LOGFILE GROUP 1；C、 SQLALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1；D、 SQLALTER DATABASE DROP LOGFILE MEMBER ’D:///REDO01.LOG’；
You have a single Active Directory directory service domain. You use a Group Policy object （GPO） to apply security settings to your client computers. You configure the startup type for system services settings in a new GPO， and you link the GPO to an organizational unit （OU）. You discover that the startup type for system services on one of the client computers has not been updated. You need to ensure that the Group Policy settings are applied to the client computer. What should you do？（）A、 Restart the client computer.B、 Instruct the user to log off and then log on to the client computer.C、 On the client computer， run the Gpupdate.exe command with the /Force parameter.D、 On the client computer， run the Gpupdate.exe command with the /Target：computer parameter.
You are the network administrator for You manage a Windows 2003 computer named TestKing3 that functions as a file server. The data volume on TestKing3 is mirrored. Each physical disk is on a separate controller. One of the hard disks that contains the data volume fails. You discover that the failure was caused by a faulty SCSI controller. You replace the SCSI controller. You need to restore the data volume to its previous state. You want to achieve this goal by using the minimum amount of administrative effort. What should you do?（）A、Run the diskpart active command on the failed volumeB、Convert both disks to basic disks, and then restore the data.C、Break the mirror, and then re-create the mirror.D、Select a disk in the mirror, and then reactivate the volume.
You are the network administrator for. You administer a Windows Server 2003 computer named TestKing4. TestKing4 has a single physical disk that is configured as a simple volume. You plan to store the files for a large database on TestKing4. You plan to install additional physical disks on TestKing4. You need to reconfigure the disks on TestKing4. Your solution must provide fault tolerance for the operating system and the database files. Which two actions should you perform?（） (Each correct answer presents part of the solution. Choose two.)A、Install three additional physical disks. Create a new RAID-5 volume. Place the database files on the new volume.B、Install three additional physical disks. Create a new striped volume. Place the database files on the new volume.C、Install one additional physical disk. Configure the simple volume as a mirrored volume.D、Install one additional physical disk. Configure the simple volume as a spanned volume.
A support engineer reports that inserting new sales transactions in a SQL Server 2005 database results in an error. You investigate the error. You discover that in one of the databases， a developer has accidentally deleted some data in a table that is critical for transaction processing. The database uses the full recovery model. You need to restore the table. You need to achieve this goal without affecting the availability of other data in the database. What should you do？（）A、Back up the current transaction log. Restore the database with a different name and stop at the point just before the data loss. Copy the table back into the original database.B、Back up the current transaction log. Restore the database to the point just before the data loss.C、Restore the database from the existing backup files to a time just before the data loss.D、Restore the database to the point of the last full backup.
You are a network administrator for your company. All servers run Windows Server 2003. You manage a server that functions as a file server. The data volume on the server is mirrored. Each physical disk is on a separate controller. One of the hard disks that contains the data volume fails. You discover that the failure was caused by a faulty SCSI controller. You replace the SCSI controller. You need to restore the data volume to its previous state. You need to achieve this goal by using the minimum amount of administrative effort. What should you do?（）A、Run the diskpart active command to activate the failed volume.B、Convert both disks to basic disks, and then restore the data.C、Break the mirror, and then re-create the mirror.D、Select a disk in the mirror, and then reactivate the volume.
单选题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？（）Arenaming the control filesBdropping a user in your databaseCenabling or disabling redo log archivingDdropping a tablespace in your databaseEre-creating the control files， after you lost all the control files in your database
单选题A support engineer reports that inserting new sales transactions in a SQL Server 2005 database results in an error. You investigate the error. You discover that in one of the databases, a developer has accidentally deleted some data in a table that is critical for transaction processing. The database uses the full recovery model. You need to restore the table. You need to achieve this goal without affecting the availability of other data in the database. What should you do?（）A Back up the current transaction log. Restore the database with a different name and stop at the point just before the data loss. Copy the table back into the original database.B Back up the current transaction log. Restore the database to the point just before the data loss.C Restore the database from the existing backup files to a time just before the data loss.D Restore the database to the point of the last full backup.
多选题You are managing an Oracle Database 11g ASM instance having three disks in a disk group with ASM compatibility attribute set to 11.1.0 and redundancy set to high. One of the disks in the disk group becomes unavailable because of power failure. Which statements will be true in this scenario？（）AThe disk is immediately dropped from the disk group.BThe ASM tracks the extents that are modified during the outaCThe ASM migrates the extents from the unavailable disk to the remaining disks.DThe disk automatically goes offline.
单选题Your database is in ARCHIVELOG mode. On Friday evening， you perform an online database backup by using the BACKUP DATABASE command at the Recovery Manager （RMAN） prompt and close the database. On Monday， the System Administrator informs you about the failure of two hard disks. One of the lost disks contains two datafiles， HR1.DBF and HR2.DBF， both of which belong to a read/write tablespace named HR. The disk also contains a datafile， USERS.DBF， which belongs to a read/write tablespace named USERS. You need to restore and recover the database backup that was performed on Friday evening. After mounting the database， you issue the following RMAN commands： RMANRESTORE DATABASE； RMANRECOVER DATABASE； After successfully executing these RMAN commands， you issue the following statement using SQL*Plus： SQLALTER DATABASE OPEN； You receive the following errors when attempting to open the database： ORA-01157： cannot identify/lock data file 10 see DBWR trace file ORA-01110： data file 10： ’D:///USERS.DBF’ What is the cause of these errors？（）A The USERS.DBF datafile is corrupted and cannot be restored by RMAN.B The USERS.DBF datafile was not backed up using the RMAN BACKUP DATABASE command.C The USERS.DBF datafile was not restored using the RMAN RESTORE DATABASE command.D The USERS.DBF datafile was not recovered using the RMAN RECOVER DATABASE command.
多选题You are in the middle of a transaction and very crucial data has been modified. Because of a hardware failure， the instance has shut down before synchronizing all the database files. Which two statements are true？（）AOn startup， SMON coordinates instance recovery.BOn startup， CKPT coordinates instance recovery.COn startup， use RMAN to perform instance recovery.DUncommitted changes will be rolled back after the database is opened.EOn startup， perform media recovery and then instance recovery.FOn startup， all the files will be synchronized and you get both committed and uncommitted data.
单选题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
单选题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 managing a single instance Oracle 10g database that utilizes the following parameters： Which of the following set of commands must you execute to enable Flashback Database？（）A STARTUP MOUNT EXCLUSIVE ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN；B STARTUP MOUNT ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN RESETLOGS；C STARTUP MOUNT EXCLUSIVE ATLER DATABASE ARCHIVELOG； ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN RESETLOGS；D STARTUP MOUNT ALTER DATABASE ARCHIVELOG； ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN；
单选题ou need additional storage space on your Windows 2000 Professional computer. You install a second SCSI controller and a second hard disk. During the installation of the SCSI driver, you receive a warning that the driver is unsigned. You complete the installation of the driver and restart Windows 2000 Professional. During startup, you receive a Stop error. You need to correct the error and start Windows 2000 as quickly as possible. What should you do?（）AStart the computer in Recovery Console. Delete the SCSI controller driver.BStart the computer by using the last known good configuration.CStart the computer by using the Windows 2000 startup floppy disks， and repair the system files.DStart the computer by using the Windows 2000 startup floppy disks， and repair the registry.
单选题Your database is in ARCHIVELOG mode. You have two online redo log groups each of which contains one redo member. When you attempt to start the database， you receive the following errors： ORA-00313： open failed for members of log group 1 of thread 1 ORA-00312： online log 1 thread 1： ’D:///REDO01.LOG’ You discover that the online redo log file of the current redo group is corrupted. Which statement should you use to resolve this issue？（）A SQLALTER DATABASE DROP LOGFILE GROUP 1；B SQLALTER DATABASE CLEAR LOGFILE GROUP 1；C SQLALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1；D SQLALTER DATABASE DROP LOGFILE MEMBER ’D:///REDO01.LOG’；
单选题You are the Database Administrator for WonderWeb， which has recently acquired a media company TXGlobal. You have been assigned the task to migrate all the database applications of TXGlobal to the database server of WonderWeb. To accommodate more database applications， you need to add disks to the existing disk group. Whenever you add or remove disks from the disk group， Automatic Storage Management （ASM） rebalancing distributes the data evenly across all the disks of the disk group. Which background process performs this actual rebalancing activity， resulting in the movement of data extents in the disk groups？（）A ASMBB ARBnC RBAL in the ASM instanceD RBAL in the database instance