During tablespace creation， which filename format is NOT used for creating datafiles associated with a tablespace？（）A、 incomplete namesB、 incomplete names with templatesC、 alias with template namesD、 numeric names

第1题：

Your database is running in ARCHIVELOG mode. The SCOTT.EMP table belongs to the DATA1 tablespace. The junior DBA erroneously runs a script that executes the following statement：   SQL> DROP TABLE SCOTT.EMP PURGE；   After one hour， you are performing the user managed incomplete recovery. Which datafiles will you restore from the last full backup？（）

• A、 the datafiles associated with the SYSTEM tablespace
• B、 the datafiles associated to the DATA1 tablespace
• C、 the datafiles associated to the SYSTEM and DATA1 tablespaces
• D、 all the datafiles in the database

第2题：

Consider the following command to create a tablespace in your production database （which is using an Automatic Storage Management [ASM] instance to manage the database files）：  CREATE TABLESPACE user_tbsp  DATAFILE ’+dgroup3（user_temp）/user_files/user_tbsp’ SIZE 200M；  What would be the result of this command？（）

• A、It would result in an error because the template cannot be used along with the disk group.
• B、It would result in an error because the path cannot be specified while creating a tablespace in a disk group.
• C、It would create a tablespace with a data file that has an alias， and its attributes are set by the user-defined template.
• D、It would create a tablespace with a data file that does not have an alias， and its attributes are set by the user-defined template.

第3题：

When performing an incomplete recover of the whole database， which data files must you restore？ （）

• A、Only the damaged or lost data files.
• B、All of the data files of the database.
• C、Only the data files belonging to the SYSTEM tablespace.
• D、The data files belonging to the SYSTEM tablespace and the damaged or lost data files.

第4题：

Connection Manager features cannot be used with which of the following naming method？ （）

• A、Oracle names
• B、Local Naming
• C、Host Naming
• D、Names Server

第5题：

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

第6题：

Your database contains two temporary tablespaces named TEMP and TEMP1. The TEMP tablespace is the default temporary tablespace for the database， and the TEMP1 tablespace was created at database creation. You want to increase the size of the tempfile for the TEMP tablespace and drop the TEMP1 tablespace from the database. The database is not using Oracle-Managed Files （OMF）. Which statement must you use to ensure that when you drop the TEMP1 tablespace from the database， its corresponding operating system file is also deleted？（）

• A、 DROP TABLESPACE temp1；
• B、 DROP TABLESPACE temp1 INCLUDING CONTENTS；
• C、 DROP TABLESPACE temp1 INCLUDING CONTENTS AND DATAFILES；
• D、 DROP TABLESPACE temp1 INCLUDING CONTENTS CASCADE CONSTRAINTS；

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

For an incomplete recovery， which four backup types can be used by Recovery Manager （RMAN） to restore data files？ （）

• A、RMAN image copies
• B、RMAN database backups
• C、RMAN tablespace backups
• D、user­managed backups placed in the flash recovery area
• E、user­managed backups that have been cataloged with RMAN
• F、user­managed data file backups for which the full path name is specified

第14题：

You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup information of your database. Which file can be used as a repository to store information regarding the RMAN backup？（）

• A、 online redo log files
• B、 alert log files
• C、 control file
• D、 datafiles associated with the SYSTEM tablespace

第15题：

Which option is best practice for creating a recovery catalog owner in the catalog database？（）  

• A、 Granting UNLIMITED QUOTA on the SYSTEM tablespace to the owner
• B、 Allocating the SYSTEM tablespace as the default tablespace and granting the SYSDBA privilege to the user
• C、 Creating a new tablespace，allocating this as the default， and granting UNLIMITED QUOTA on this tablespace to the user
• D、 Allocating the SYSAUX tablespace as the default tablespace and granting UNLIMITED QUOTA on this tablespace to the user

第16题：

View this parameter setting in your database：   DB_CREATE_FILE_DEST=’D:// /oracle/product/10.2.0/oradata/oracle’  You created a tablespace by using this command：   CREATE TABLESPACE USERS；  Which two statements are true about the USERS tablespace？（）

• A、The tablespace has two data files.
• B、An error is reported and tablespace creation fails.
• C、Data files are created with names generated by the instance.
• D、The tablespace can be extended without specifying the data file.
• E、Data files belonging to the USERS tablespace cannot be renamed.

第17题：

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.

第18题：

You took the DATA1 tablespace offline at 10：00 A.M. At 12：30 P.M.， a schema of a user is dropped and purged from the Recycle Bin. You noticed this at 2：00 P.M. and decided to perform an incomplete recovery.  Which datafiles will you recover？（）

• A、 all the datafiles in the database
• B、 the datafiles associated with the SYSTEM tablespace
• C、 the datafiles associated with the DATA1 tablespace
• D、 all the datafiles in the database except those associated with the DATA1 tablespace

第19题：

第20题：

第21题：

第22题：

第23题：