You want the size of the tablespace to increase when it is full. Which option would you use？（）A、use automatic extent allocationB、disable threshold for the tablespaceC、use freelists to manage the free spaceD、use automatic segment space managementE、create t

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

You have 100 segments in the USERS tablespace. You realize that the USERS tablespace is running low on space. You can use Segment Advisor to（）。

• A、identify the segments that you should shrink
• B、modify the storage parameters for the tablespace
• C、automatically shrink the segments with unused space
• D、check the alerts generated for the tablespace that is running low on space

第3题：

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

第4题：

You work as a database administrator for Certkiller .com. You have set the retention period for Automatic Repository （AWR） statistics to four days and collection interval to 15 minutes. You want to view the statistics collected and stored in AWR snapshot. Which two methods would you use to view the AWR statistics？（）

• A、use enterprise manager
• B、use DBMS_SQL package
• C、use DBMS_AWR package
• D、use PRVT_WORKLOAD package
• E、query the AWR snapshot repository objects
• F、use DBMS_WORKLOAD_REPOSITORY package

第5题：

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.

第6题：

Which of the following would you use to enable automatic media recovery for a database？（）

• A、SET AUTORECOVERY ON
• B、SET RECOVERY ON
• C、SET AUTO ON
• D、You cannot enable automatic media recovery.

第7题：

You create a new Automatic Database Diagnostic Monitor （ADDM） task：  instance_analysis_mode_task. To view the ADDM report， you use the following command：   SQL> SELECT dbms_addm.get_report（’my_instance_analysis_mode_task’） FROM dual；   You want to suppress ADDM output relating to Segment Advisor actions on user SCOTT’s segments.  What would you do to achieve this？（）

• A、 Add a finding directive for the ADDM task.
• B、 Add a segment directive for the ADDM task.
• C、 Add a parameter directive for the ADDM task.
• D、 Disable the Segment Advisor from the Automatic Maintenance Task.

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

n your production database you want to use an Automatic Storage Management （ASM） instance to manage the database files. Which option would you use to migrate the database files from a non-ASM instance to an ASM instance？（）

• A、 Oracle Migration Assistant
• B、 Recovery Manager （RMAN）
• C、 Oracle Data Pump Export and Import
• D、 conventional Oracle Export and Import
• E、 operating system utilities to copy the files to the ASM instance

第14题：

Very soon you will be performing maintenance operations. You would have several jobs to run as soon as the maintenance period starts. Which method would you use to create jobs without specifying the time period when the job should be run？（）

• A、 use DBMS_IJOB package
• B、 use Oracle Scheduler
• C、 use DBMS_JOB package
• D、 use Oracle Data Pump Export and Import

第15题：

You want to create a new optimized database for your transactional production environment to be used by a financial application. While creating the database， you want the Oracle software to take care of all basic settings to optimize the database performance. Which method would you use to achieve this objective？（）

• A、Use the CREATE DATABASE .. command to create the database with Oracle-managed files. 
• B、Use the Database Configuration Assistant (DBCA) to create the database with Oracle-managed files. 
• C、Use Enterprise Manager to create a new database with the Online Transaction Processing (OLTP) option. 
• D、Use Database Configuration Assistant (DBCA) to create the database with Transaction Processing template. 
• E、Use the CREATE DATABASE .. command to create the database with Automatic Storage Management (ASM) file system.

第16题：

In your production database you want to use an Automatic Storage Management （ASM） instance to manage the database files. Which option would you use to migrate the database files from a non-ASM instance to an ASM instance？（）

• A、Oracle Migration Assistant
• B、Recovery Manager （RMAN）
• C、Oracle Data Pump Export and Import
• D、conventional Oracle Export and Import
• E、operating system utilities to copy the files to the ASM instance

第17题：

You use the segment advisor to help determine objects for which space may be reclaimed. Which three statements are true about the advisor given by the segment advisor?（）

• A、It may advise the use of online table redefinition for tables in dictionary managed tablespace.
• B、It may advise the use of segment shrink for tables in dictionary managed tablespaces it the no chained rows.
• C、It may advise the use of online table redefinition for tables in locally managed tablespaces
• D、It will detect and advise about chained rows.
• E、It may advise the use of segment shrink for free list managed tables.

第18题：

USER_DATA is a nonencrypted tablespace that contains a set of tables with data. You want to convert all existing data in the USER_DATA tablespace and the new data into the encrypted format. Which methodswould you use to achieve this?（）

• A、Use Data Pump to transfer the existing data to a new encrypted tablespace
• B、Use ALTER TABLE MOVE to transfer the existing data to a new encrypted tablespace
• C、Use CREATE TABLE AS SELECT to transfer the existing data to a new encrypted tablespace
• D、Enable row movement for each table to be encrypted and then use ALTER TABLESPACE to encrypt the tablespace
• E、Encrypt the USER_DATA tablespace using the ALTER TABLESPACE statement so that all the data in the tablespace is automatically encrypted

第19题：

You install Windows 2000 Professional on your portable computer. You install an SCSI and PC card adapter, that you can use in the office to use color scanner. You use a docking station for your computer when you are in the office. You want to maximize the battery performance for your portable computer. You also want to prevent the driver from loading whenever you are away from the office. What should you do?（）

• A、When away from the office use Device Manager to remove the adapter. 
• B、When away from the office configure the startup properties for the adapter to be automatic. 
• C、Remove the computer from the docking station and start Windows 2000 Professional to disable the SCSI PC card adapter device for the current profile.
• D、Remove the computer from the docking station and start Windows 2000 Professional, use Device Manager to remove SCSI PC card adapter device.

第20题：

第21题：

第22题：

第23题：