多选题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 （）AThe database automatically d

第1题：

Which two statements about bigfile tablespaces are true？ （）

• A、The bigfile tablespace have only one data file.
• B、The segment space management is automatic.
• C、The extent management is dictionary managed.
• D、The database can have only one bigfile tablespace.
• E、The bigfile tablespace can be converted to a smallfile tablespace.

第2题：

You want to drop the TBS1 tablespace from your database.  You also want to delete the corresponding data files automatically， and not have to do it manually.  What should you do？（）

• A、Use the DROP DATAFILE command.
• B、Use the DROP TABLESPACE command.
• C、Ensure that all database files are Oracle Managed Files before using the DROP TABLESPACE command.
• D、Ensure that the DB_FILE_CREATE_DEST initialization parameter is set before using the DROP TABLESPACE command.

第3题：

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.

第4题：

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.

第5题：

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.

第6题：

You want to be notified when the space usage of an existing critical tablespace has reached 75% of the allocated space. Which option would you use to achieve this？（）

• A、run a procedure to check the tablespace space usage
• B、define the warning threshold for the tablespace at 75% in Database Control
• C、create a trigger to be executed when tablespace space usage reaches 75%
• D、submit a job by using DBMS_JOB package to check the free space in the tablespace at regular intervals
• E、define the warning threshold to be 75% for the tablespace by ALTER TABLESPACE .. ADD THRESHOLD command

第7题：

You have configured your database to use RMAN for backup and recovery. You must back up the datafile contained in the TS1 tablespace. The size of the datafile in the TS1 tablespace is 200 MB.  You issue the following command from the RMAN prompt to perform a backup of the tablespace：   RMAN> BACKUP TABLESPACE TS1 MAXSETSIZE 100M；  Which statement is true about executing this command？（）

• A、 The command generates an error.
• B、 The command backs up the tablespace and creates a backup set of size 200 MB
• C、 The command backs up the tablespace and creates two backup sets of size 100 MB each.
• D、 The command backs up the tablespace and creates a backup set with backup pieces of size 100 MB each.

第8题：

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

第9题：

You issued the following command：   CREATE GLOBAL TEMPORARY TABLE admin_work_area   （startdate DATE， enddate DATE， class CHAR（20）） ON COMMIT DELETE ROWS TABLESPACE tbs_t1；   An index is then created on the ADMIN_WORK_AREA temporary table.  Which two statements are true regarding the TBS_T1 tablespace in the above command？（） 

• A、 It stores only the temporary table but not its indexes.
• B、 It stores both the temporary table as well as its indexes.
• C、 It must be a nondefault temporary tablespace for the database.
• D、 It can be a default or nondefault temporary tablespace for the database.
• E、 It must be the default temporary tablespace of the user who issues the command.

第10题：

Examine the commands executed in a DBA session：SQL> CREATE BIGFILE TABLESPACE MRKT 2 DATAFILE ’/u01/app/oracle/oradata/orcl/mrkt.dbf’ size 10M LOGGING 3 EXTENT MANAGEMENT LOCALSEGMENT SPACE MANAGEMENT AUTO； Tablespace created. SQL> ALTER DATABASE DEFAULT TABLESPACE MRKT； Database altered.  Which two statements are trueregarding the MRKT tablespace（）

• A、No more data files can be added to the tablespace.
• B、Segment space is managed by free lists in the tablespace.
• C、A user created without being assigned a default tablespace uses this tablespace.
• D、The tablespace can be dropped with the current setting with segments present in it