网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)
单选题
You want the size of the tablespace to increase when it is full. Which option would you use?()
A

use automatic extent allocation

B

disable threshold for the tablespace

C

use freelists to manage the free space

D

use automatic segment space management

E

create the tablespace as a bigfile tablespace

F

use the RESIZE clause while creating the tablespace

G

enable AUTOEXTEND for at least one of the data files in the tablespace


参考答案

参考解析
解析: 暂无解析
更多 “单选题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 the tablespace as a bigfile tablespaceF use the RESIZE clause while creating the tablespaceG enable AUTOEXTEND for at least one of the data files in the tablespace” 相关考题
考题 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 shrinkB. modify the storage parameters for the tablespaceC. automatically shrink the segments with unused spaceD. check the alerts generated for the tablespace that is running low on space

考题 You create a new Automatic Database Diagnostic Monitor (ADDM) task: instance_analysis_mode_task. To view the ADDM report, you use the following command: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.

考题 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 the tablespace as a bigfile tablespaceF、use the RESIZE clause while creating the tablespaceG、enable AUTOEXTEND for at least one of the data files in the tablespace

考题 Users are performing a large volume of inserts and deletes on the application tables in the APPS tablespace. You observe that there are several warning alerts being generated for the APPS tablespace space usage metrics. Currently, the warning threshold for the tablespace space usage metrics is set to 70%.  To make the generated alerts more useful as a problem identification tool, you want to reduce the frequency of alert generation for the tablespace space usage metrics for the APPS tablespace. What should you do?()A、disable SQL tracing for theAPPS tablespaceB、disable logging attribute for the APPS tablespaceC、modify the tablespace to be a dictionary­managed tablespaceD、increase the critical threshold value for the tablespace space usage metrics for the APPS tablespaceE、increase the warning threshold value for the tablespace space usage metrics for the APPS tablespace

考题 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 50B、specify extent allocation as UniformC、specify extent allocation as AutomaticD、create the tablespace as bigfile tablespaceE、create the tablespace as smallfile tablespaceF、set segment space management to AutomaticG、use the RESIZE clause while creating the tablespace

考题 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 AssistantB、 Recovery Manager (RMAN)C、 Oracle Data Pump Export and ImportD、 conventional Oracle Export and ImportE、 operating system utilities to copy the files to the ASM instance

考题 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 shrinkB、modify the storage parameters for the tablespaceC、automatically shrink the segments with unused spaceD、check the alerts generated for the tablespace that is running low on space

考题 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 usageB、define the warning threshold for the tablespace at 75% in Database ControlC、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 intervalsE、define the warning threshold to be 75% for the tablespace by ALTER TABLESPACE .. ADD THRESHOLD command

考题 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.

考题 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 managerB、use DBMS_SQL packageC、use DBMS_AWR packageD、use PRVT_WORKLOAD packageE、query the AWR snapshot repository objectsF、use DBMS_WORKLOAD_REPOSITORY package

考题 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 AssistantB、Recovery Manager (RMAN)C、Oracle Data Pump Export and ImportD、conventional Oracle Export and ImportE、operating system utilities to copy the files to the ASM instance

考题 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.

考题 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 tablespacesD、It will detect and advise about chained rows.E、It may advise the use of segment shrink for free list managed tables.

考题 Which of the following would you use to enable automatic media recovery for a database?()A、SET AUTORECOVERY ONB、SET RECOVERY ONC、SET AUTO OND、You cannot enable automatic media recovery.

考题 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.

考题 单选题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 shrinkB  modify the storage parameters for the tablespaceC  automatically shrink the segments with unused spaceD  check the alerts generated for the tablespace that is running low on space

考题 单选题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 AssistantB  Recovery Manager (RMAN)C  Oracle Data Pump Export and ImportD  conventional Oracle Export and ImportE  operating system utilities to copy the files to the ASM instance

考题 单选题You want to move all the objects of the APPS user in the test database to the DB_USER schema of the production database. Which option of IMPDP would you use to accomplish this task?()A FULLB SCHEMASC REMAP_SCHEMAD REMAP_DATAFILESE REMAP_TABLESPACE

考题 单选题You want to move all objects of the APPS user in the test database to the DB_USER schema of theproduction database.  Which option of IMPDP would you use to accomplish this task()A FULLB SCHEMASC TRANSFORMD REMAP_SCHEMAE REMAP_TABLESPACE

考题 单选题You explicitly specified the tablespace usage threshold values while creating a tablespace. You need to revert to the database-wide default tablespace usage threshold values for the tablespace. Which PL/SQL package would you use?()A DBMS_STATS B DBMS_ALERT C DBMS_SPACE D DBMS_MONITOR E DBMS_SERVER_ALERTF DBMS_SPACE_ADMIN

考题 单选题You want to move all objects of the APPS user in the test database to the DB_USER schema of the productiondatabase.  Which option of IMPDP would you use to accomplish this task()A FULLB SCHEMASC TRANSFORMD REMAP_SCHEMAE REMAP_TABLESPACE

考题 单选题You are performing the shrink operation on the SCOTT.EMP table. You want to perform the same operation on all dependent objects of the SCOTT.EMP table. What is NOT a prerequisite for the operation?()A  You must enable the row movement on the SCOTT.EMP table.B  You must define the tablespace of the SCOTT.EMP table for automatic segment space management.C  You must use the CASCADE clause in the ALTER TABLE SHRINK SPACE statement.D  You must use the COMPACT clause in the ALTER TABLE SHRINK SPACE statement.

考题 单选题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.

考题 单选题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 usageB define the warning threshold for the tablespace at 75% in Database ControlC 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 intervalsE define the warning threshold to be 75% for the tablespace by ALTER TABLESPACE .. ADD THRESHOLD command

考题 单选题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 AssistantB Recovery Manager (RMAN)C Oracle Data Pump Export and ImportD conventional Oracle Export and ImportE operating system utilities to copy the files to the ASM instance

考题 多选题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?()AIt may advise the use of online table redefinition for tables in dictionary managed tablespace.BIt may advise the use of segment shrink for tables in dictionary managed tablespaces it the no chained rows.CIt may advise the use of online table redefinition for tables in locally managed tablespacesDIt will detect and advise about chained rows.EIt may advise the use of segment shrink for free list managed tables.

考题 单选题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 the tablespace as a bigfile tablespaceF use the RESIZE clause while creating the tablespaceG enable AUTOEXTEND for at least one of the data files in the tablespace

考题 单选题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/x7fASM instance to an ASM instance?()A Oracle Migration AssistantB Recovery Manager (RMAN)C Oracle Data Pump Export and ImportD conventional Oracle Export and ImportE operating system utilities to copy the files to the ASM instance