Question 1

A(n)request is a low-level read or write data access operation to or from computer devices.

Accepted Answer

The answer of A(n)request is a low-level read or write...

Question 2

How should storage volumes be allocated for indexes,system,and high-usage tables?

Accepted Answer

Assign separate data files in separate s...

Question 3

If there is no index,the DBMS will perform a scan.

Accepted Answer

A)  loop
B)  range
C)  row ID table access
D)  full tableE) A) and B)
F) A) and C)

Question 4

In RAID level 5,:

Accepted Answer

A)  the data and the parity data are striped across separate drives.
B)  the data blocks are spread over separate drives and are duplicated.
C)  the array requires a minimum of two drives and is known as a striped array.
D)  the array requires a minimum of five drives and is known as duplexing.E) None of the above
F) A) and B)

Question 5

The analyzes the SQL query and finds the most efficient way to access the data.

Accepted Answer

The answer of The analyzes the SQL query and finds...

Question 6

is another name for table space.

Accepted Answer

The answer of is another name for table space....

Question 7

To generate database object statistics manually,following syntax should be used in Oracle: .

Accepted Answer

A) ANALYZE object_name; B) CREATE

object_name; C) ANALYZE

object_name COMPUTE STATISTICS; D) CREATE

object_name COMPUTE STATISTICS;E) A) and D) F) All of the above

Question 8

In standard SQL,the optimizer hint ALL_ROWS is generally used for mode processes.

Accepted Answer

A)  interactive
B)  real-time
C)  batch
D)  transactionE) A) and D)
F) C) and D)

Question 9

The SQL cache stores the end-user written SQL.

Accepted Answer

A) True 
 B)False

Question 10

Describe query optimization and the modes that an optimizer can operate in.

Accepted Answer

Query optimization is the central activi...

Question 11

In standard SQL,the optimizer hint FIRST_ROWS is generally used for mode processes.

Accepted Answer

A)  batch
B)  interactive
C)  transaction
D)  real-timeE) All of the above
F) A) and C)

Question 12

A (n)____ is an index based on a specific SQL function or expression.

Accepted Answer

function-b...

Question 13

A system will perform best when its hardware and software resources are .

Accepted Answer

The answer of A system will perform best when its...

Question 14

The table space is used for transaction-recovery purposes.

Accepted Answer

A)  system
B)  user data
C)  temporary
D)  rollback segmentE) A) and C)
F) A) and D)

Question 15

The DBMS the SQL query and chooses the most efficient access/execution plan.

Accepted Answer

A)  parses
B)  executes
C)  fetches
D)  processesE) None of the above
F) All of the above

Question 16

One of the main functions of a database system is to provide timely answers to end users.

Accepted Answer

A) True 
 B)False

Question 17

In-memory database systems are optimized to store small portions of the database in disk storage alone.

Accepted Answer

A) True 
 B)False

Question 18

A conditional expression is normally expressed within the or HAVING clauses of a SQL statement.

Accepted Answer

The answer of A conditional expression is normally expressed within...

Question 19

DBMS performance tuning includes global tasks such as managing the DBMS processes in primary memory and managing the structures in physical storage.

Accepted Answer

A) True 
 B)False

Question 20

The cache is used as a temporary storage area for ORDER BY or GROUP BY operations,as well as for index-creation functions.

Accepted Answer

A)  data
B)  SQL
C)  sort
D)  optimizerE) A) and B)
F) A) and C)

Exam 11: Database Performance Tuning and Query Optimization

Describe query optimization and the modes that an optimizer can operate in.

Correct AnswerverifiedQuery optimization is the central activi...View AnswerShow Answer

is another name for table space.

Correct AnswerverifiedShow Answer

A (n)____ is an index based on a specific SQL function or expression.

Correct Answerverifiedfunction-b...View AnswerShow Answer

In-memory database systems are optimized to store small portions of the database in disk storage alone.

Correct AnswerverifiedShow Answer

The cache is used as a temporary storage area for ORDER BY or GROUP BY operations,as well as for index-creation functions.

Correct AnswerverifiedShow Answer

In standard SQL,the optimizer hint FIRST_ROWS is generally used for mode processes.

Correct AnswerverifiedShow Answer

The DBMS the SQL query and chooses the most efficient access/execution plan.

Correct AnswerverifiedShow Answer

The analyzes the SQL query and finds the most efficient way to access the data.

Correct AnswerverifiedShow Answer

In RAID level 5,:

Correct AnswerverifiedShow Answer

A(n)request is a low-level read or write data access operation to or from computer devices.

Correct AnswerverifiedShow Answer

In standard SQL,the optimizer hint ALL_ROWS is generally used for mode processes.

Correct AnswerverifiedShow Answer

One of the main functions of a database system is to provide timely answers to end users.

Correct AnswerverifiedShow Answer

DBMS performance tuning includes global tasks such as managing the DBMS processes in primary memory and managing the structures in physical storage.

Correct AnswerverifiedShow Answer

If there is no index,the DBMS will perform a scan.

Correct AnswerverifiedShow Answer

To generate database object statistics manually,following syntax should be used in Oracle: .

Correct AnswerverifiedShow Answer

How should storage volumes be allocated for indexes,system,and high-usage tables?

Correct AnswerverifiedAssign separate data files in separate s...View AnswerShow Answer

A conditional expression is normally expressed within the or HAVING clauses of a SQL statement.

Correct AnswerverifiedShow Answer

A system will perform best when its hardware and software resources are .

Correct AnswerverifiedShow Answer

The SQL cache stores the end-user written SQL.

Correct AnswerverifiedShow Answer

The table space is used for transaction-recovery purposes.

Correct AnswerverifiedShow Answer

Correct Answer
verified
Query optimization is the central activi...
View Answer

Correct Answer
verified

Correct Answer
verified
function-b...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Assign separate data files in separate s...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified