单选题

In your datawarehousing application, you generate reports frequently. The data is static in the tables being used to generate reports. You are currently using joins, resulting in a large performance overhead. What kind of database structure would you use to reduce the response time of the query?()

Ahash clusters

Bindex clusters

Cpartitioned tables

Dindex­organized table (IOT)

正确答案

来源:www.examk.com

答案解析

相似试题
  • How can you change the cursor style in your form? ()

    单选题查看答案

  • Identify the situations in which you use the alert log file in your database to check the detail.()

    多选题查看答案

  • Where can you add your own PL/SQL code in relation-handling triggers?()

    单选题查看答案

  • Your test database is running in NOARCHIVELOG mode. What are the implications of this? ()

    单选题查看答案

  • Your database is functioning in ARCHIVELOG mode. In which two situations would you perform a cancel-based recovery? ()

    多选题查看答案

  • Identify the two situations in which you use the alert log file in your database to check the details.()

    多选题查看答案

  • Your boss at Supportcenter.cn wants you to clarify Oracle 10g. Which condition in your database forces you to perform only consistent backups?()

    单选题查看答案

  • Your end users will need to change values in a REF lookup field in the form application you create. To facilitate choosing a new appropriate value, your provide them with? ()

    单选题查看答案

  • Your boss at Certkiller .com wants you to clarify Oracle 10g. Which condition in your database forces you to perform only consistent backups?()

    单选题查看答案

  • Which built-in would you reference in your trigger code to remove a report from the Reports Server queue dynamically?()

    单选题查看答案