（单选题）
In one of your online transaction processing （OLTP） applications， users are manipulating and querying a database table simultaneously. From the Segment Advisor， you find that one of the tables is highly fragmented and you want to shrink the table immediately without affecting the currently active queries. Which option would you use with the ALTER TABLE command to achieve this objective？（）
A REBUILD
B CASCADE
C TRUNCATE
D ROW MOVEMENT
E SHRINK SPACE COMPACT
F SHRINK SPACE CASCADE
正确答案
答案解析
略
相似试题
（单选题）
Which WebLogic optimization allows one non-XA resource to participate in a distributed transaction?（）
（单选题）
In Oracle 11g，by default which one of the following conditions implicitly enables Automatic PGA Memory Management？（）
（单选题）
Which one of the following files contains records that do not meet the specified load criteria in the SQL*Loader control file？（）
（单选题）
One of the user sessions was terminated abnormally in the middle of a transaction. What does Oracle database do to recover it？（）
（多选题）
User Scott has updated the salary of one of the employees in the EMPLOYEES table and has not committed the transaction. What are the two types of locks that this scenario would lead to？（）
（单选题）
In your database， online redo log files are multiplexed and one of the members in a group is lost due to media failure？ How would you recover the lost redo log member？（）
（单选题）
One of the redo log members in your database is lost. You queried V$logfile for further details. What would be the member’s status？（）
（单选题）
In order to enable remote administration of users and tablespaces on an Oracle database, which of the following types of files must exist in the database?（）
（单选题）
（）is a collection of components managed by Fusion Middleware Control. It can contain Oracle WebLogic Server domains， one Administration Server， one or more Managed Servers， clusters， and the Oracle Fusion Middleware components that are installed， configured， and running in the domain
（单选题）
For an inventory report, you created a work_in_progress that contains two columns, ID_number and quantity. The parent group of the work_in_progress is in_inventory which contains one column, dept_no. You added a filter of fist fifteen to total_inventory and a filter of last 20 for work_in_progress. Which records will the report return?（）
