You lost the index tablespace in your database. You are not able to use tablespace point-in-time recovery on the index tablespace. What could be the reason for this？（）

相似题目

• In your database， online redo log files are multiplexed and one of the members in a group is lost due to media failure？ How would you recover the lost redo log member？（）

  A .  import the database from the last export B .  restore all the members in the group from the last backup C .  drop the lost member from the database and then add a new member to the group D .  restore all the database files from the backup and then perform a complete recovery E .  restore all the database files from the backup and then perform an incomplete recovery

  查看最佳答案

• You lost the PRODSTD tablespace， which was read-only. The tablespace was read-only when the last backup was taken. How would you recover the tablespace？（）

  A .  restore the tablespace from the backup， and then perform an incomplete recovery B .  restore the tablespace from the backup， and then apply all the redo information C .  restore all the data files in the database， and then perform an incomplete recovery D .  restore the tablespace from the backu

  查看最佳答案

• You executed the following procedure to collect statistics regarding an index：       SQL>ANALYZE INDEX EMP_ID VALIDATE STRUCTURE；   Which view will you use to determine whether you need to rebuild the index or not？（） 

  A .  INDEX_STATS B .  DBA_INDEXES C .  DBA_IND_COLUMNS D .  V$OBJECT_USAGE

  查看最佳答案

• 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 your index to be stored in a tablespace. Which of the following storage parameters are NOT appropriate for indexes?（）

  A . OPTIMAL  B . INITIAL  C . PCTINCREASE  D . NEXT

  查看最佳答案

• You are analyzing the performance of a SQL Azure database.   You need to recommend an approach for identifying the indexes that should be added to improve database performance.  What should you recommend？（）

  A .  Use SQL Server Profiler to identify missing indexes. B .  Use the Database Engine Tuning Advisor to identify missing indexes. C .  Use a Dynamic Management View to analyze query plans. D .  Use a DynamicManagement View to ascertain the number of pending I/O requests.

  查看最佳答案

• You lost the index tablespace in your database. You decided to re­create the index tablespace and the indexes in the tablespace.  What methods can you use to re­create the indexes？（）

  A . Data Pump B . SQL scripts C . SQL*Loader D . Flashback database E . Recovery Manager （RMAN） script

  查看最佳答案

• In your database， online redo log files are multiplexed and one of the members in a group is lost due to media failure.  How would you recover the lost redo log member？（）

  A . import the database from the last export B . restore all the members in the group from the last backup C . drop the lost member from the database， and then add a new member to the group D . restore all the database files from the backup， and then perform a complete recovery  E . restore all the database files from the backup， and then perform an incomplete recovery

  查看最佳答案

• You have altered a non-unique index to be invisible to determine if queries execute within an acceptable response time without using this index. Which two are possible if table updates are performed which affect the invisible index columns?（）

  A . The index remains invisible. B . The index is not updated by the DML statements on the indexed table. C . The index automatically becomes visible in order to have it updated by DML on the table. D . The index becomes unusable but the table is updated by the DML. E . The index is updated by the DML on the table.

  查看最佳答案

• You have lost datafile 4 from your database. Which is typically the fastest way to restore your database? （）

  A . Restore and recover the datafile.  B . Restore and recover the tablespace.  C . Restore and recover the database.  D . Restore and recover the control file.  E . Restore and recover the parameter file.

  查看最佳答案

• You lost a temporary file that belongs to the default temporary tablespace in your database. From the options provided， which approach would you take to solve the problem？（）

  A .  flash back the database B .  import the temporary tablespace from the last export C .  restore all the data files and temporary files from the last full database backup and perform a recovery D .  not perform a recovery， but create a new temporary tablespace， make it the default temporary tablespace and then drop the old tablespace

  查看最佳答案

• If you are going to run a TSPITR recovery， which view will help you to determine which objects will be lost during the TSPITR？（）

  A .  TS_OBJECTS_TO_BE_DROPPED B .  TS_PTTR_OBJECT_DROPPED C .  TS_PITR_OBJECTS_TO_BE_DROPPED D .  TS_OBJECTS_DROPPED E .  TS_DROPPED_OBJECTS

  查看最佳答案

• You are maintaining your database in Oracle10g. You find that the INDEXES index tablespace should be recovered. How will you recover the index tablespace？（）

  A .  by using the Flashback Database feature B .  by using RMAN incomplete recovery C .  by performing a user-managed incomplete recovery D .  by dropping and re-creating the index tablespace

  查看最佳答案

• You lost the index tablespace in your database. You decided to re-create the index tablespace and the indexes in the tablespace. What methods can you use to re-create the indexes？（）

  A .  SQL scripts B .  Recovery Manager （RMAN） script C .  Data Pump D .  SQL*Loader E .  Flashback database

  查看最佳答案

• You are a database administrator for your company. You are responsible for a SQL Server 2005 database that has several indexes. You need to write a stored procedure that checks the indexes for fragmentation. Which Transact-SQL statement should you use？（）

  A . DBCC DBREINDEX B . SELECT * FROM sys.dm_db_index_physical_stats C . DBCC INDEXDEFRAG D . SELECT * FROM sys.indexe

  查看最佳答案

• You have lost datafile 4 from your database. Which is typically the fastest way to restore your database？（）  

  A .  Restore and recover the datafile. B .  Restore and recover the tablespace. C .  Restore and recover the database. D .  Restore and recover the control file. E .  Restore and recover the parameter file.

  查看最佳答案

• You lost the PRODSTD tablespace， which was read/write. The tablespace was read­only when the last backup was performed. How would you recover the tablespace？（）

  A . restore the tablespace from the backup; there is no need to apply the redo information  B . restore the full database to recover the data up to the point when you performed the backup  C . restore the tablespace from the backup， and then perform a recovery using the backup control file D . restore the tablespace from the backup， and then recover the tablespace; all the redo information from the point when the tablespace was made read/write is applied

  查看最佳答案

• You lost a data file that belongs to an index tablespace in your database， which operates in ARCHIVELOG mode. Loss of the data file resulted in increased response time on your queries. Which two options would you use to solve this problem？ （）

  A .  Restore the lost data file from the backup， and then flash back the database. B .  Restore the data file pertaining to index tablespace， and then recover the tablespace. C .  Restore all the data files， and then perform an incomplete recovery to get the tablespace back. D .  Restore all the data files， and then perform an incomplete recovery using the backup control file. E .  Drop and re-create the index tablespace， and then re-create all of the indexes in that tablespace.

  查看最佳答案

• One of the redo log members in your database is lost. You queried V$logfile for further details. What would be the member’s status？（）

  A . LOST B . INVALID C . EXPIRED D . DELETED E . CORRUPT F . UNKNOWN G . OBSOLETE

  查看最佳答案

• As soon as you discover that you have lost an online redo log， if the database is still functioning， what should be your first action？（）  

  A .  Shut down the database B .  Clear the online redo log C .  Back up the database D .  Checkpoint the database E .  Call Oracle support

  查看最佳答案

• 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

  查看最佳答案

• 1. Admit that you're lost. The first step in getting help is recognizing that you have a________.

  查看最佳答案

• Can you help me please? I’ve lost my way and ________ to get to the shops before closing time.

  查看最佳答案

• —What did you do with your car？ —I lost my key, so I had to______it in the park.

  A．lock B．repair C．leave D．pass

  查看最佳答案