单选题You are creating tablespaces in Oracle. Which of the following keywords or clauses permits the datafiles of a database to grow automatically in order to accommodate data growth?（）A DEFAULT STORAGE B EXTENT MANAGEMENT C AUTOEXTEND D DATAFILE

第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题：

Which two statements are true regarding undo tablespaces（）

• A、The database can have more than one undo tablespace.
• B、The UNDO_TABLESPACE parameter is valid in both automatic andmanualundo management.
• C、Undo segments automatically grow and shrink as needed， acting as circular storage buffer for their assigned transactions.
• D、An undotablespaceis automatically created if the UNDO_TABLESPACEparameter is not set and the UNDO_MANAGEMENT parameter is set to AUTO during the database instance start up.

第3题：

第4题：

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、 ASMB
• B、 ARBn
• C、 RBAL in the ASM instance
• D、 RBAL in the database instance

第5题：

You have a database with the following tablespaces： SYSTEM， SYSAUX， UNDO， USERS， TEMP. You want to"roll back" the data in the USERS tablespace to the way it looked yesterday.  Which tablespaces do you need to perform a point-in-time restore operation on in order to complete this task？（） 

• A、 SYSTEM
• B、 SYSAUX
• C、 UNDO
• D、 USERS
• E、 TEMP
• F、 This restore is not possible

第6题：

Which of the following best describes a full backup? （）

• A、All datafiles of a database 
• B、All datafiles, archive logs, and control files 
• C、All datafiles and control files 
• D、All the used blocks in a datafile

第7题：

You are creating a locally managed tablespace to meet the following requirements： All the extents should be of the same size.  The data should be spread across two data files.  A bitmap should be used to record the free space within the allocated extents. Which three options would you choose？（）

• A、set PCTFREE and PCTUSED to 50
• B、specify extent allocation as Uniform
• C、specify extent allocation as Automatic
• D、create the tablespace as bigfile tablespace
• E、create the tablespace as smallfile tablespace
• F、set segment space management to Automatic
• G、use the RESIZE clause while creating the tablespace

第8题：

A database is running in ARCHIVELOG mode and regular backups are performed. A user receives the following error message . Which is the recommended sequence of operations you need to perform for the query successfully?（）

• A、Drop the affected tablespace, re-create the tablespace, restore the datafiles, and the tablespace. 
• B、Take the affected datafile offline (if not already offline), restore the damaged image of the datafile, and then bring it online. 
• C、Restart the database in MOUNT mode, restore the damaged datafile, recover the datafile and then open the database with resetlogs.
• D、Put the database in RESTRICTED mode, restore all the datafiles in the affected datafile and recover the tablespace, and then put the database in normal operational mode. 

第9题：

 You are creating tablespaces in Oracle. Which of the following keywords or clauses permits the datafiles of a database to grow automatically in order to accommodate data growth?（）

• A、DEFAULT STORAGE 
• B、EXTENT MANAGEMENT 
• C、AUTOEXTEND 
• D、DATAFILE

第10题：

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

• A、The database automatically determines the extent-sizing policy for the tablespace.
• B、The segments are automatically shrunk when the contents are removed from them.
• C、The allocation of extents within the tablespace is managed through the dictionary tables.
• D、The space utilization description of the data blocks in segments is recorded in bitmap blocks.
• E、The space utilization description of the data blocks in segments is managed through free lists.