单选题

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?()

AREBUILD

BCASCADE

CTRUNCATE

DROW MOVEMENT

ESHRINK SPACE COMPACT

FSHRINK SPACE CASCADE

正确答案

来源:www.examk.com

答案解析

相似试题
  • 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?()

    单选题查看答案

  • You are managing an Oracle Database 11g ASM instance having three disks in a disk group with ASM compatibility attribute set to 11.1.0 and redundancy set to high. One of the disks in the disk group becomes unavailable because of power failure.  Which statements will be true in this scenario?()

    多选题查看答案

  • Given: What is the appropriate definition of the hashCode method in class Person?()

    单选题查看答案

  • Click the Exhibit button. What is the output of the program shown in the exhibit?()

    单选题查看答案

  • Your database is in ARCHIVELOG mode. You have two online redo log groups,each of which contains one redo member.  When you attempt to start the database, you receive the following errors:()

    单选题查看答案

  • Click the Exhibit button.   What is the output of the program shown in the exhibit? ()

    单选题查看答案

  • Given classes defined in two different files: What is required at line 5 in class SomeApp to use the process method of BitUtils?()

    单选题查看答案

  • Given: Which code, inserted at line 15, creates an instance of the Point class defined in Line?()

    单选题查看答案

  • Given classes defined in two different files: What is required at line 5 in class SomeApp to use the process method of BitUtils?()

    单选题查看答案

  • Your database is running in ARCHIVELOG mode. One of the data files, USERDATA01.dbf, in the USERS tablespace is damaged and you need to recover the file until the point of failure. The backup for the datafile is available.  Which three files would be used in the user-managed recovery process performed by the database administrator (DBA)?() 

    多选题查看答案