单选题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题：

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.

第2题：

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

第3题：

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

第4题：

In order to enable remote administration of users and tablespaces on an Oracle database, which of the following types of files must exist in the database?（）

• A、Password file 
• B、Initialization file 
• C、Datafile 
• D、Control file 
• E、Nothing - SYSDBA privileges are not required for these actions

第5题：

You are designing the physical database layout on your host machine. What is the relationship between tablespaces and datafiles in the Oracle database?（）

• A、One tablespace has only one datafile
• B、Many tablespaces can share one datafile
• C、One tablespace can have many datafiles
• D、One datafile can contain many tablespaces

第6题：

The ORDERS table in the database of a company contains one million records. The table is stored in the DATA tablespace and the index created on the ORDERS table is stored in the index tablespace named INDEXES. On Monday， you failed to start the database because the datafiles of the INDEXES tablespace were missing. You dropped and recreated the INDEXES tablespace by issuing the following command：    SQL>DROP TABLESPACE INDEXES INCLUDING CONTENTS；    SQL> CREATE TABLESPACE INDEXES DATAFILE   ’C:///ORACLE/ORADATA/ORA101t/INDEX01.DBF’ SIZE 50m；   After that， you issued the following command to recreate the index：    CREATE UNIQUE INDEX sales_index_pk ON sales （order_id）   PCTFREE 10   INITRANS 2   MAXTRANS 255   TABLESPACE indexes   STORAGE （   INITIAL 1m  NEXT 1m   PCTINCREASE 0   MINEXTENTS 1   MAXEXTENTS 8192  ）   NOLOGGING   PARALLEL（ degree 4）   Which two clauses are responsible for reducing the time for the recreation of the index？（）

• A、 PCTFREE
• B、 MAXTRANS
• C、 PCTINCREASE
• D、 INITIAL
• E、 NOLOGGING
• F、 PARALLEL

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

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

第14题：

 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

第15题：

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.

第16题：

Your database is in ARCHIVELOG mode. On Friday evening， you perform an online database backup by using the BACKUP DATABASE command at the Recovery Manager （RMAN） prompt and close the  database. On Monday， the System Administrator informs you about the failure of two hard disks. One of the lost disks contains two datafiles， HR1.DBF and HR2.DBF， both of which belong to a read/write tablespace named HR. The disk also contains a datafile， USERS.DBF， which belongs to a read/write tablespace named USERS. You need to restore and recover the database backup that was performed on Friday evening. After mounting the database， you issue the following RMAN commands：        RMAN>RESTORE DATABASE；        RMAN>RECOVER DATABASE；   After successfully executing these RMAN commands， you issue the following statement using SQL*Plus：        SQL>ALTER DATABASE OPEN；   You receive the following errors when attempting to open the database：        ORA-01157： cannot identify/lock data file 10 see DBWR trace file        ORA-01110： data file 10： ’D:///USERS.DBF’   What is the cause of these errors？（）

• A、 The USERS.DBF datafile is corrupted and cannot be restored by RMAN.
• B、 The USERS.DBF datafile was not backed up using the RMAN BACKUP DATABASE command.
• C、 The USERS.DBF datafile was not restored using the RMAN RESTORE DATABASE command.
• D、 The USERS.DBF datafile was not recovered using the RMAN RECOVER DATABASE command.

第17题：

Which of the following statements is true when the database is in ARCHIVELOG mode and tablespaces are in hot backup mode？（）

• A、 Archive log generation is suspended until the tablespaces are taken out of hot backup mode. 
• B、 Datafiles are not written to during hot backups.
• C、 Changes to the database are cached during the backup and not written to the datafiles to ensure that the datafiles are consistent when recovered.
• D、 The datafile headers are not updated during the backup.
• E、 The way data is written to the online redo logs is unchanged during the backup.

第18题：

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：