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

相关问题推荐

• You are working in an online transaction processing （OLTP） environment. You used the FLASHBACK TABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACK TABLE command， the System Change Number （SCN） was 663571. After flashing back the CUSTOMERS table， you realize that the table is not in the correct state and the resultant changes are not what you had desired. So， you need to reverse the effects of the FLASHBACK TABLE command while ensuring that：  a） No other user data in the database is affected.  b） The operation takes the minimum possible time.  Which option would you choose？（）

  A、 Use ROLLBACK command with SCN 663571.

  B、 Perform Flashback Transaction Query with SCN 663571.

  C、 Execute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571.

  D、 Execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571.

  查看答案

• Manually， you set the consumer group of all of the newly created users to MYDB_GRP. You want the users to be able to change their consumer groups as per the application requirement. What was the first step that was needed in the process to achieve this objective？（）

  A、 The user must have been granted the DBA role.

  B、 The user must have been granted the switch privilege as a part of a role.

  C、 The user must have been granted the Resource Manager administrator privilege.

  D、 The user must have been granted the switch privilege by using the DBMS_RESOURCE_MANAGER_PRIVS package.

  查看答案

• You are managing an Oracle Database 10g database that uses Oracle Managed Files （OMF）. You enabled the block change tracking feature for the database. Which statement regarding the change tracking file is true？（）

  A、 One block change tracking file is created for each data file. By default， the file is created in DB_CREATE_FILE_DEST.

  B、 One block change tracking file is created for each data file. By default， the file is created in BACKGROUND_DUMP_DEST.

  C、 One block change tracking file is created for the database. By default， the file is created in DB_CREATE_FILE_DEST.

  D、 One block change tracking file is created for the database. By default， the file is created in BACKGROUND_DUMP_DEST.

  查看答案

• You are using the DBVERIFY utility to check the datafiles for any block corruption. You want to write the output of the dbv command to a file not to the screen.  Which parameter of the DBVERIFY utility will you use？（）

  A、 FILE

  B、 PARFILE

  C、 LOGFILE

  D、 FEEDBACK

  查看答案

• You lost the index tablespace in your database. You are not able to use tablespace point-in-time recovery on the index tablespace. What could be the reason for this？（）

  A、 The index tablespace contains bitmap indexes.

  B、 The index tablespace contains more than one data file.

  C、 The index tablespace supports only complete recovery.

  D、 The index tablespace is not a dictionary-managed tablespace.

  E、 There is a dependency relationship between a table and its indexes.

  查看答案