Users in your production database complain that they are getting the following error message while trying to insert rows into the ORDERS table：  ERROR at line 1：  ORA-01654： unable to extend index USERS.ORDERS_IND by 8 in tablespace INDEXES.While investigating， you find that the INDEXES tablespace has run out of space and there is no more free space on the disk where the data files are available. Which two actions could you perform to overcome this error without affecting the queries that are currently being executed？（）

A

 Drop and re-create the inbox.

B

 Coalesce the ORDERS_IND index.

C

 Coalesce the INDEXES tablespace.

D

 Drop and re-create the ORDERS table.

E

 Rebuild the index online and move it to another tablespace.

相关问题推荐

• You are maintaining your OLTP database in Oracle10g. You are performing the Flashback Transaction Query to find the undo SQL statements that can be used to undo the changes made to the database in the specific time period. Which pseudocolumn will you use to perform the Flashback Transaction Query？（）

  A、 VERSIONS_STARTSCN

  B、 VERSIONS_STARTTIME

  C、 VERSIONS_XID

  D、 VERSIONS_OPERATION

  查看答案

• You issued the following statement in your SQL*Plus session：   SQL>ALTER SESSION ENABLE RESUMABLE TIMEOUT 600；   Which operation is neither suspended nor resumed using the Automatic Resumable Allocation feature in your database？（）

  A、 creating a table in your schema and you exceed your allocated space quota on the tablespace

  B、 executing a long query that involves a sort operation and the statement runs out of temporary space

  C、 loading data into tables by using the SQL*Loader and the number of extents in the table reaches the maximum limit

  D、 creating a table in a dictionary-managed tablespace with an explicit MAXEXTENTS setting which results in an out of space error

  查看答案

• You want to use the SQL Tuning Advisor to generate recommendations for badly written SQL statements in your development environment. Which three sources can you select for the advisor to analyze？（）

  A

   Top SQL

  B

   snapshots

  C

   SQL Tuning sets

  D

   index access path

  E

   optimizer statistics

  F

   materialized view logs

  查看答案

• A media failure has occurred. This has resulted in all the members of the next hop log group being rendered inaccessible to the log writer process （LGWR） at a log switch. How does this failure affect the operational database？（）

  A、 The database re-created the missing redo log files automatically.

  B、 The database continues to function normally with the existing files.

  C、 The database allows only queries， no other statements are allowed.

  D、 The database returns and error and the database instance shuts down.

  E、 The user sessions that generate redo logs are terminated automatically.

  查看答案

• 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？（）

  A、import the database from the last export

  B、restore all the members in the group from the last backup

  C、drop the lost member from the database， and then add a new member to the group

  D、restore all the database files from the backup， and then perform a complete recovery 

  E、restore all the database files from the backup， and then perform an incomplete recovery

  查看答案