单选题You have many users complaining about slow inserts into a large table. While investigating the reason, you find that the number of indexes on the table is high. You want to find out which indexes are not being used.  Which method would you follow to ac

题目
单选题
You have many users complaining about slow inserts into a large table. While investigating the reason, you find that the number of indexes on the table is high. You want to find out which indexes are not being used.  Which method would you follow to achieve this?()
A

enable index monitoring and query the DBA_OBJECTS view

B

enable index monitoring and query the DBA_INDEXES view

C

enable index monitoring and query the V$OBJECT_USAGE view

D

enable index monitoring and view the DBA_INDEXTYPE_COMMENTS view

参考答案和解析
正确答案: A
解析: 暂无解析
如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

You work as a database administrator for Certkiller .com. You find that reports are running for a long time in your data warehousing applications. You suspect a lack of indexes is the reason for the performance degradation.  Which advisory component would you refer to, in order to determine the appropriate indexes?()

  • A、Memory Advisors
  • B、Segment Advisors
  • C、SQL Tuning and Access Advisors
  • D、Automated Workload Repository (AWR)
  • E、Automatic Database Diagnostic Monitor (ADDM)

正确答案:C

第2题:

In your production database, users report that they are unable to generate reports on an important table because it does not contain any data. While investigating the reason, you realize that another user executed the TRUNCATE TABLE command, which accidentally caused the data to be lost. Now you want to recover the lost data of the table without affecting objects in other schemas. Which method must you use to recover the lost data?()

  • A、Complete Recovery with online redo log
  • B、Complete Recovery with archived redo log
  • C、Tablespace Point-in-Time Recovery (TSPITR)
  • D、Incomplete Recovery with system change number (SCN)

正确答案:C

第3题:

In your test database, you have created the ORDERS table as an index/x7forganized 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?()

  • A、export and import the mapping table
  • B、drop and re­create the mapping table
  • C、truncate the mapping table and reinsert the values
  • D、use the ALTER TABLE .. REBUILD command to defragment the mapping table

正确答案:B

第4题:

You work as a database administrator for Certkiller .com. Users in the Certkiller .com PROD database complain about the slow response of transactions. While investigating the reason you find that the transactions are waiting for the undo segments to be available, and undo retention has been set to zero. What would you do to overcome this problem?()

  • A、Increase the undo return
  • B、Create more undo segments
  • C、Create another undotablespace
  • D、Increase the size of the undotablespace

正确答案:D

第5题:

You find that the execution time of reports in your datawarehouse application is significantly high. You suspect the lack of indexes to be the reason for the degradation in performance. Which advisory component would you refer to, in order to determine the appropriate indexes?()

  • A、 Memory Advisor
  • B、 Segment Advisor
  • C、 SQL Access Advisor
  • D、 Automatic Workload Repository (AWR)
  • E、 Automatic Database Diagnostic Monitor (ADDM)

正确答案:C

第6题:

For the V$SESSION_LONGOPS view, you find that some of the database users have long-running queries that consume a lot of CPU time. This causes performance problems for other users in the database, who have much shorter queries. You would like to make sure that the users with large queries do not use all the CPU time, but you still do not want to terminate them with an error message. Which method would you follow to achieve this?()

  • A、 Set the CPU time per call in the users profile.
  • B、 Set the CPU time per session in the users profile.
  • C、 Set the CPU levels for the user’s group using Resource Manager.
  • D、 Set the TIMED_STATISTICS parameter to TRUE in the parameter file.

正确答案:C

第7题:

You have many users complaining about slow inserts into a large table. While investigating the reason, you find that the number of indexes on the table is high. You want to find out which indexes are not being used.  Which method would you follow to achieve this?()

  • A、enable index monitoring and query the DBA_OBJECTS view
  • B、enable index monitoring and query the DBA_INDEXES view
  • C、enable index monitoring and query the V$OBJECT_USAGE view
  • D、enable index monitoring and view the DBA_INDEXTYPE_COMMENTS view

正确答案:C

第8题:

Users in your PROD database complain about the slow response of the transactions. While investigating the reason, you find that the transactions are waiting for the undo segments to be available, and undo retention has been set to zero. What would you do to overcome this problem?()

  • A、increase the undo retention
  • B、create more undo segments
  • C、create another undo tablespace
  • D、increase the size of the undo tablespace

正确答案:D

第9题:

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.

正确答案:B,E

第10题:

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 index
  • 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

正确答案:B,E

更多相关问题