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？（）
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？（）
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 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？（）
You are configuring your index to be stored in a tablespace. Which of the following storage parameters are NOT appropriate for indexes?（）
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？（）
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？（）
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?（）
You have lost datafile 4 from your database. Which is typically the fastest way to restore your database? （）
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？（）
If you are going to run a TSPITR recovery， which view will help you to determine which objects will be lost during the TSPITR？（）
You are maintaining your database in Oracle10g. You find that the INDEXES index tablespace should be recovered. How will you recover the index tablespace？（）
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？（）
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？（）
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？（）
You have lost datafile 4 from your database. Which is typically the fastest way to restore your database？（）
You lost the PRODSTD tablespace， which was read/write. The tablespace was readonly when the last backup was performed. How would you recover the tablespace？（）
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？ （）
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？（）
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 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？（）
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.
