Question 1

To generate database object statistics manually, you could use the following syntax: ____.

Accepted Answer

A) ANALYZE object_name; B) CREATE

object_name; C) ANALYZE

object_name COMPUTE STATISTICS; D) CREATE

object_name COMPUTE STATISTICS;E) B) and C) F) A) and C)

Question 2

Once an SQL statement is transformed, the DBMS creates what is commonly known as a(n) ____________________ plan.

Accepted Answer

The answer of Once an SQL statement is transformed, the...

Question 3

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)

Question 4

The purpose of an I/O operation is to move data to and from different computer components or devices.

Accepted Answer

A) True 
 B)False

Question 5

The majority of primary memory resources will be allocated to the ____ cache.

Accepted Answer

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

Question 6

DBMS query processing has ____________________ phases.

Accepted Answer

The answer of DBMS query processing has ____________________ phases....

Question 7

____________________ are special instructions for the optimizer that are embedded inside the SQL command text.

Accepted Answer

The answer of ____________________ are special instructions for the optimizer...

Question 8

When setting optimizer hints, ____ forces the optimizer to use the P_QOH_NDX index to process this query.

Accepted Answer

A)   ALL_ROWS
B)   FIRST_ROWS
C)   INDEX(P_QOH_NDX) 
D)   OPTIMIZATION_ROWSE) C) and D)
F) None of the above

Question 9

List and describe some typical DBMS processes.

Accepted Answer

Listener: The listener process listens f...

Question 10

The ____ table space is used to store end-user data.

Accepted Answer

A)   system
B)   user data
C)   temporary
D)   rollback segmentE) B) and C)
F) All of the above

Question 11

Knowing the sparsity of a column helps you decide whether the use of ____ is appropriate.

Accepted Answer

A)   query processing
B)   query optimization
C)   an index
D)   a full table scanE) B) and C)
F) A) and D)

Question 12

The ____ table space is used for transaction-recovery purposes.

Accepted Answer

A)   system
B)   user data
C)   temporary
D)   rollback segmentE) All of the above
F) B) and C)

Question 13

A data file can only contain rows from one single table.

Accepted Answer

A) True 
 B)False

Question 14

____ refers to the number of different values a column could possibly have.

Accepted Answer

A)   Database statistics
B)   Data sparsity
C)   Primary keys
D)   Query optimizationE) C) and D)
F) None of the above

Question 15

To work with the data, the DBMS must retrieve the data from the ____ and place it in the ____.

Accepted Answer

A)   data files, procedure cache
B)   data files, data cache
C)   temporary files, RAM
D)   temporary files, procedure cacheE) B) and C)
F) B) and D)

Question 16

All factors must be checked to ensure that each system component operates at its optimum level and has sufficient resources to minimize the occurrence of bottlenecks.

Accepted Answer

A) True 
 B)False

Question 17

The SQL cache stores the end-user written SQL.

Accepted Answer

A) True 
 B)False

Question 18

Indexes do not facilitate join operations.

Accepted Answer

A) True 
 B)False

Question 19

The ____ table space is used as a temporary storage area for merge, sort, or set aggregate operations.

Accepted Answer

A)   system
B)   user data
C)   temporary
D)   rollback segmentE) B) and D)
F) All of the above

Question 20

Good database performance is easy to evaluate.

Accepted Answer

A) True 
 B)False

Exam 14: Managing Database and Sql Performance

Knowing the sparsity of a column helps you decide whether the use of ____ is appropriate.

Correct AnswerverifiedShow Answer

The ____ table space is used as a temporary storage area for merge, sort, or set aggregate operations.

Correct AnswerverifiedShow Answer

Indexes do not facilitate join operations.

Correct AnswerverifiedShow Answer

To generate database object statistics manually, you could use the following syntax: ____.

Correct AnswerverifiedShow Answer

The ____ table space is used for transaction-recovery purposes.

Correct AnswerverifiedShow Answer

____ refers to the number of different values a column could possibly have.

Correct AnswerverifiedShow Answer

Once an SQL statement is transformed, the DBMS creates what is commonly known as a(n) ____________________ plan.

Correct AnswerverifiedShow Answer

To work with the data, the DBMS must retrieve the data from the ____ and place it in the ____.

Correct AnswerverifiedShow Answer

Good database performance is easy to evaluate.

Correct AnswerverifiedShow Answer

The SQL cache stores the end-user written SQL.

Correct AnswerverifiedShow Answer

When setting optimizer hints, ____ forces the optimizer to use the P_QOH_NDX index to process this query.

Correct AnswerverifiedShow Answer

The majority of primary memory resources will be allocated to the ____ cache.

Correct AnswerverifiedShow Answer

The ____ table space is used to store end-user data.

Correct AnswerverifiedShow Answer

List and describe some typical DBMS processes.

Correct AnswerverifiedListener: The listener process listens f...View AnswerShow Answer

A data file can only contain rows from one single table.

Correct AnswerverifiedShow Answer

The purpose of an I/O operation is to move data to and from different computer components or devices.

Correct AnswerverifiedShow Answer

All factors must be checked to ensure that each system component operates at its optimum level and has sufficient resources to minimize the occurrence of bottlenecks.

Correct AnswerverifiedShow Answer

____________________ are special instructions for the optimizer that are embedded inside the SQL command text.

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

DBMS query processing has ____________________ phases.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

To work with the data, the DBMS must retrieve the data from the and place it in the .

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Listener: The listener process listens f...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified