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？（）

You need to rename a data file of a tablespace. How would you perform this？（）

单选题查看答案

You have a large amount of historical data in a flat file. Some analysts in your organization need toquery this data in the file. The file is too large to load the data in it into your current database.  Which is the most effective method to access this data in your database（）

单选题查看答案

You executed the following command to create a tablespace called SALES_DATA： SQL> CREATE TABLESPACE sales_data DATAFILE SIZE 100M SEGMENT SPACE MANAGEMENT AUTO； Which two statements are true about the SALES_DATA tablespace（）

多选题查看答案

You executed the following command to create a tablespace called SALES_DATA：  > CREATE TABLESPACE sales_data DATAFILE SIZE 100M SEGMENT SPACE MANAGEMENT AUTO；  Which two statements are true about the SALES_DATA tablespace （）

多选题查看答案

You created a snapshot of the /data2 filesystem as follows：   # fssnap -F ufs -o bs=/data2/snap /data2   But， the system responds with the following error： snapshot error： Invalid backing file path   What is the problem？ （）

单选题查看答案

You work as a database administrator for Certkiller .com. You need to rename a data file of atablespace.  How would you perform this？（）

单选题查看答案

ou have a large amount of historical data in a flat file. Some analysts in your organization need to query thisdata in the file. The file is too large to load the data in it into your current database.  Which is the most effectivemethod to access this data in your database（）

单选题查看答案

Consider the following scenario：  You have a directory， data， under the disk group tdgroup  A. You want to create an alias for one of the data files and you execute the following command： ALTER DISKGROUP tdgroupA  ADD ALIAS ’+tdgroupA/data/datafile.dbf’  FOR ’+tdgroupA. 231.45678’；  Which task would be accomplished by the command？（）

单选题查看答案

You have discovered that a disk failure occurred on DISK1 where the data files belonging to the SYSTEM and USER_DATA tablespaces is stored. The database is currently open and you need to recover the data files. You will restore the data files to DISK2. What is the correct sequence of RMAN commands to restore and recover the data files？（）

单选题查看答案