You are creating a locally managed tablespace to meet the fo

第1题：

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

第2题：

In your database， you discovered that a tempfile in a locally managed temporary tablespace has been deleted at the operating system level. How would you recover the tablespace？（）

• A、flash back the database
• B、perform point-in-time recovery
• C、perform a full database recovery
• D、drop and re-create the tablespace
• E、use Recovery Manager （RMAN） to recover the database

第3题：

第4题：

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

• A、 The index tablespace contains bitmap indexes.
• B、 The index tablespace contains more than one data file.
• C、 The index tablespace supports only complete recovery.
• D、 The index tablespace is not a dictionary-managed tablespace.
• E、 There is a dependency relationship between a table and its indexes.

第5题：

You issued the following statement in your SQL*Plus session：   SQL>ALTER SESSION ENABLE RESUMABLE TIMEOUT 600；   Which operation is neither suspended nor resumed using the Automatic Resumable Allocation feature in your database？（）

• A、 creating a table in your schema and you exceed your allocated space quota on the tablespace
• B、 executing a long query that involves a sort operation and the statement runs out of temporary space
• C、 loading data into tables by using the SQL*Loader and the number of extents in the table reaches the maximum limit
• D、 creating a table in a dictionary-managed tablespace with an explicit MAXEXTENTS setting which results in an out of space error

第6题：

In which scenario will you perform a cancel-based recovery？（）

• A、 when a tablespace is dropped and you have only RMAN-based backup of the database
• B、 when a table is dropped and stored in the Recycle Bin
• C、 when you are required to recover an existing table to its previous state
• D、 when a tablespace is dropped and you have only a user-managed full backup of the database

第7题：

You specified segment space management as automatic for a tablespace. What effect would this have on space management？（）

• A、Extents would be managed by the freelists.
• B、The segment would be managed by bitmaps.
• C、The segment would be managed by the freelists.
• D、Free space would be managed by the data dictionary.

第8题：

第9题：

You have created a locally managed tablespace by issuing the following command：        CREATE TABLESPACE data1   DATAFILE ’data1_file1.dbf’ SIZE 10M AUTOEXTEND ON MAXSIZE        UNLIMITED；   For the DATA1 tablespace， you have set the warning level alert limit to 70 percent.  In which situation will a warning level alert be generated？（）  

• A、 when 700 KB is used
• B、 when 700 KB is left as free space
• C、 when 7MB is used
• D、 when 7MB is left as free space
• E、 no alert will be generated because an autoextensible datafile is included in the tablespace

第10题：

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