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
Dindexorganized table (IOT)
正确答案
答案解析
相似试题
(单选题)
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?()