单选题In which scenario will you create a sorted hash cluster？（）Aif the application uses queries joining tables only occasionallyBif the full table scan is executed often on only one table of the clustered tablesCif the data for all the rows of a cluster ke

题目

单选题

In which scenario will you create a sorted hash cluster？（）

if the application uses queries joining tables only occasionally

if the full table scan is executed often on only one table of the clustered tables

if the data for all the rows of a cluster key value exceeds one or two Oracle blocks

when you want the data to be returned automatically in the chronological order

更多“单选题In which scenario will you create a sorted hash cluster？（）A if the application uses queries joining tables only occasionallyB if the full table scan is executed often on only one table of the clustered tablesC if the data for all the rows of a clus”相关问题

第1题

In which scenario will you create a sorted hash cluster？（）A、 if the application uses queries joining tables only occasionallyB、 if the full table scan is executed often on only one table of the clustered tablesC、 if the data for all the rows of a cluster key value exceeds one or two Oracle blocksD、 when you want the data to be returned automatically in the chronological order

点击查看答案
第2题

In which scenario will you create a hash cluster？（）A、 when you want the data to be returned automatically in chronological orderB、 if the application uses queries joining tables only occasionallyC、 if the queries against the clustered table use the equality operator （=） to retrieve the desired rowD、 if the full table scan is executed often on only one of the clustered tables

点击查看答案
第3题

You executed this command to create a temporary table： SQL> CREATE GLOBAL TEMPORARY TABLE report_work_area （startdate DATE， enddateDATE， class CHAR（20）） ON COMMIT PRESERVE ROWS； Which statement is true about the rows inserted into the REPORT_WORK_AREA table during a transaction（）A、The rows stay in the table only until session termination.B、The rows stay in the table only until the next transaction starts on the table.C、The rows are visible to all current sessions after the transaction is committed.D、The rows stay available for subsequent sessions after the transaction is committed

点击查看答案
第4题

You are creating a cluster. The tables in the cluster have a relatively uniform distribution of values in the index column and the queries against the clustered table will almost use an equality operator to retrieve the desired row. Which type of cluster will you create？（）A、 Index clusterB、 Hash clusterC、 Sorted Hash clusterD、 Real Application Cluster

点击查看答案
第5题

You are designing an application for Certkiller .com and you have been asked to design a database table to facilitate monthly bill generation. The bill would include details of customer calls， listed in chronological order.Which method would you follow to achieve this objective without increasing the overhead of sorting the rows？（）A、 create a hash cluster to store the dataB、 create an index cluster to store the dataC、 create a partitioned table to store the dataD、 create a sorted hash cluster to store the dataE、 create a heap table with rowid to store the data

点击查看答案
第6题

An application uses Windows Azure Table storage. The application uses five tables. One table used by the application is approaching the limit for storage requests per second. You need to recommend an approach for avoiding data access throttling. What should you recommend？（）A、 Use a single partition key for the table.B、 Compress data before storing it in the table.C、 Create additional partition keys for the table.D、 Continually remove unnecessary data from the table.

点击查看答案
第7题

A Windows Azure application retrieves data from SQL Azure. You need to recommend an approach for improving application query performance. What should you recommend？（）A、 Create a database view to retrieve the data.B、 Use a clustered index on the SQL Azure database tables.C、 Open a new database connection when an operation times out.D、 Create SQL Azure database table indexes basedon application queries

点击查看答案

单选题In which scenario will you create a sorted hash cluster？ （）A if the application uses queries joining tables only occasionallyB if the full table scan is executed often on only one table of the clustered tablesC if the data for all the rows of a clus

题目

更多“单选题In which scenario will you create a sorted hash cluster？ （）A if the application uses queries joining tables only occasionallyB if the full table scan is executed often on only one table of the clustered tablesC if the data for all the rows of a clus”相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容

单选题In which scenario will you create a sorted hash cluster？（）A if the application uses queries joining tables only occasionallyB if the full table scan is executed often on only one table of the clustered tablesC if the data for all the rows of a clus

更多“单选题In which scenario will you create a sorted hash cluster？（）A if the application uses queries joining tables only occasionallyB if the full table scan is executed often on only one table of the clustered tablesC if the data for all the rows of a clus”相关问题