Managing Hash Clusters - Oracle placement test

Managing Hash Clusters - Oracle placement test

1) A hash cluster provides an alternative to a non-clustered table with an?

A) Index
B) Index Cluster
C) Both A & B
D) None of the above
View Answer / Hide Answer


2) Oracle Database uses a hash function to generate a distribution of numeric values, called hash values, that are based on specific cluster key values?

A) True
B) False
View Answer / Hide Answer


3) In a sorted hash cluster, the rows corresponding to each value of the hash function are sorted on a specified set of columns in which order and that can improve response time during

subsequent operations on the clustered data?

A) Descending order
B) Ascending Order
C) Equal
D) None of the above
View Answer / Hide Answer


4) single-table hash cluster, provides fast access to rows in a table and this table must be the only table in the hash cluster. Essentially, there must be which mapping between hash keys and

data rows?

A) many-to-one mapping
B) one-to-many mapping
C) One-to-one mapping
D) Both A & B
View Answer / Hide Answer


5) SORT_AREA SIZE and HASH_AREA_SIZE parameters are ignored in some of the user sessions. What could be the reason?

A) The User Global Area (UGA) is not configured
B) The sessions were started using the login name SYS
C) The sessions are running in the Automatic Shared Memory Management mode
D) The sessions are running in the automatic Program Global Area (PGA) memory management mode
View Answer / Hide Answer


6) You are using flat files as the data source for one of your data warehousing applications. You plan to move the data from the flat file structures to an Oracle database to optimize the

application performance. In your database you have clustered tables. While migrating the data, you want to have minimal impact on the database performance and optimize the data load

operation. Which method would you use to load data into Oracle database?

A) Use the external table population
B) Use the Oracle Data Pump export and import utility
C) Use the conventional path data load of SQL*Loader utility
D) Use the direct path data load of Oracle export and import utility
View Answer / Hide Answer


7) To find or store a row in an indexed table or cluster, which of these must be performed?

A) One or more I/Os to find or store the key value in the index
B) Another I/O to read or write the row in the table or cluster
C) Both A & B
D) None of the above
View Answer / Hide Answer


8) Even if you decide to use hashing; a table cannot still separate indexes on any columns, including the cluster key?

A) True
B) False
View Answer / Hide Answer


9) In which of these situations hashing is not advantageous?

A) Applications frequently perform full-table scans on the table and the table is sparsely populated
B) You cannot afford to preallocate the space that the hash cluster will eventually need
C) You cannot afford to preallocate the space that the hash cluster will eventually need
D) All mentioned above
View Answer / Hide Answer


10) A hash cluster is created using a DROP CLUSTER statement, but you specify a HASHKEYS clause?

A) True
B) False
View Answer / Hide Answer


11) For maximum distribution of rows in a hash cluster, the database rounds the HASHKEYS value up to the nearest?

A) Prime Number
B) ODD Number
C) Null
D) None of the above
View Answer / Hide Answer


12) When estimating the size of cluster indexes remember that the index is on each cluster key, not the actual rows. Therefore, each key appears only once in the index?

A) True
B) False
View Answer / Hide Answer


13) The Implications of dropping hash clusters and tables in hash clusters are not same as those for dropping index clusters?

A) True
B) False
View Answer / Hide Answer