可学答题网 > 问答 > 1z0-043题库
目录: 标题| 题干| 答案| 搜索| 相关
问题

In your test database,


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

  • Aexport and import the mapping table
  • Bdrop and re­create the mapping table
  • Ctruncate the mapping table and reinsert the values
  • Duse the ALTER TABLE .. REBUILD command to defragment the mapping table
参考答案
参考解析:
分类:1z0-043题库
相关推荐

1、In your database insta

In your database instance, the user sessions are connected to the database server from the&ens...

2、In your database, onli

In your database, online redo log files are multiplexed and one of the members in a ...

3、In your test database,

In your test database, you find that a user’s session is executing a lot of SQL&ens...

4、In your database, all&

In your database, all the tablespaces are locally managed. You started Recovery Manager (RMAN)&en...

5、Your database runs in&

Your database runs in ARCHIVELOG mode, and is backed up every Sunday night using RMAN scr...

6、In your database, the&

In your database, the users SYS and SYSTEM have been assigned the profiles, ADMIN_PROF1 and&e...