In your test databas...

单项选择题X 纠错

In your test database， you have created the ORDERS table as an index-organized table （IOT）. To facilitate faster querying， you have created a mapping table and a bitmap index on the ORDER_FILLED column. You observe that the query performance degrees when users perform a large volume of transactions. While investigating the reason， you find that the mapping table segment is fragmented， leading to poor performance. Which option would you use to defragment the mapping table without affecting the original table data？（）

A. Export and import the mapping table.
B. Drop and re-create the mapping table.
C. Truncate the mapping table and reinsert the values.
D. Use the ALTER TABLE .. REBUILD command to defragment the mapping table.

参考答案：

进入题库练习

多项选择题

Your database is functioning in ARCHIVELOG mode. In which two situations would you perform a cancel-based recovery？（）

A. You find that one of the redo log members in each redo log group is lost.
B. You find that a data file that belongs to the USERS tablespace is damaged.
C. You find that a data file that belongs to the SYSTEM tablespace is damaged.
D. You find that the current redo log group is damaged and is not available for recovery.
E. You realized while performing a recovery that an archived redo log file needed for recovery is lost.

点击查看答案进入题库练习

单项选择题

Which statement is true while creating subplans using Resource Manager？（）

A. The subplan must belong to the consumer group， SYS_GROUP.
B. The total CPU usage at any given level must be less than 100%.
C. The subplans can be used to restrict the degree of parallelism for a user.
D. You can use a resource plan instead of a consumer group to implement a priority ranking within the plan.

点击查看答案进入题库练习

多项选择题

You are using Oracle Database 10g. You performed an incomplete recovery of your database and opened the database with the RESETLOGS option. What is the effect of opening the database with the RESETLOGS option？（）

A. This operation resets the SCN for the database.
B. This operation creates a new incarnation of the database.
C. This operation moves all the redo log files to a different location.
D. This operation deletes the old redo log files and creates new redo log files.
E. This operation updates all current datafiles and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and time stamp.

点击查看答案进入题库练习

多项选择题

For an incomplete recovery， which four backup types can be used by Recovery Manager （RMAN） to restore data files？（）

A. RMAN image copies.
B. RMAN database backups.
C. RMAN tablespace backups.
D. User-managed backups placed in the flash recovery area.
E. User-managed backups that have been cataloged with RMAN.
F. User-managed data file backups for which the pull path name is specified.

点击查看答案进入题库练习

多项选择题

You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parameter in the parameter file to YYYY-MM-DD. The default format of which two data types would be affected by this setting？（）

A. DATE
B. TIMESTAMP
C. INTERVAL YEAR TO MONTH
D. INTERVAL DAY TO SECOND
E. TIMESTAMP WITH LOCAL TIME ZONE

点击查看答案进入题库练习

多项选择题

While creating a scheduler window using the DBMS_SCHEDULER package， a user logged in as DBMGR gets the error message insufficient privileges？ Which two commands would you use to resolve this error？（）

A. GRANT dba TO dbmgr；
B. GRANT connect TO dbmgr；
C. GRANT resource TO dbmgr；
D. GRANT hs_admin_role TO dmbgr；
E. GRANT manage scheduler TO dbmgr；

点击查看答案进入题库练习

多项选择题

What are the two advantages of RMAN Block Media Recovery （BMR） over file-level recovery？（）

A. BMR lowers the mean time to recover （MTTR）.
B. BMR supports point-in-time recovery of individual data blocks.
C. BMR enables you to use incremental backups for block recovery.
D. BMR enables recovery even when the database is not mounted or open.
E. BMR enables you to use proxy backups to perform block media recovery.
F. BMR enables increased availability of data during recovery because the data file requires a recovery can remain online.

点击查看答案进入题库练习

单项选择题

Using Oracle Scheduler you have scheduled two jobs， JOB_A and JOB_B， to run at 9：00 p.m. every Friday. You want both the jobs to use a single resource plan， WEEKEND_PLAN. Which task must have already been performed to enable you to achieve this objective？（）

A. A window must have been created with the WEEKEND_PLAN resource plan.
B. A program must have been created with the WEEKEND_PLAN resource plan.
C. A job class must have been created with the WEEKEND_PLAN resource plan.
D. A windows group must have been created with the WEEKEND_PLAN resource plan.

点击查看答案进入题库练习

单项选择题

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 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 usage metrics for the APPS tablespace. What should you do？（）

A. Disable SQL tracing for the APPS tablespace.
B. Disable logging attributes for the APPS tablespace.
C. Modify the tablespace to be a dictionary-managed tablespace.
D. Increase the critical threshold value for the tablespace space usage metrics for the APPS tablespace.
E. Increase the warning threshold value for the tablespace space usage metric for the APPS tablespace.

点击查看答案进入题库练习

多项选择题

You are working in a dedicated server environment. Your database is running in the automatic Program Global Area （PGA） memory management mode. Which two statements are correct in this scenario？（）

A. The WORK_AREASIZE_POLICY initialization parameter cannot be set to AUTO.
B. The Oracle database automatically controls the amount of PGA memory allotted to SQL work areas.
C. Setting the value of the SGA_TARGET initialization parameter to 0 will disable the automatic PGA memory management.
D. The SORT_AREA_SIZE parameter is ignored by all the sessions running in the automatic PGA memory management mode.

点击查看答案进入题库练习