Question 1

helps provide a balance between performance and fault tolerance.

Accepted Answer

RAID Redundant array...

Question 2

The data cache caches system catalog data and the contents of the indexes.

Accepted Answer

A) True 
 B)False

Question 3

List and describe some typical DBMS processes.

Accepted Answer

Listener: The listener process listens f...

Question 4

The data cache is where the data read from the database data files are stored the data have been read or the data are written to the database data files.

Accepted Answer

A)  after; before
B)  after; after
C)  before; before
D)  before; afterE) B) and D)
F) B) and C)

Question 5

DBMS query processing has phases.

Accepted Answer

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

Question 6

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) A) and B)
F) C) and D)

Question 7

An index scan is less efficient than a full table scan.

Accepted Answer

A) True 
 B)False

Question 8

DBMS implementations are typically similar in complexity to two-tier client/server configurations.

Accepted Answer

A) True 
 B)False  False

Question 9

is the central activity during the parsing phase in query processing.

Accepted Answer

A)  Clustering
B)  Partitioning
C)  Query validation
D)  Query optimizationE) C) and D)
F) All of the above

Question 10

The table space is used to store the data dictionary tables.

Accepted Answer

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

Question 11

On the client side,the objective is to generate an SQL query that returns a correct answer in the least amount of time,using a minimum amount of resources at the server end.The activities required to achieve this goal are commonly referred to as tuning.

Accepted Answer

A)  client SQL
B)  database SQL
C)  SQL performance
D)  DBMS performanceE) A) and D)
F) B) and D)

Question 12

End users and the DBMS interact through the use of to generate information.

Accepted Answer

queries

Question 13

On the server side,the database environment must be properly configured to respond to clients' requests in the fastest way possible,while making optimum use of existing resources.The activities required to achieve this goal are commonly referred to as tuning.

Accepted Answer

A)  client and server
B)  database SQL
C)  SQL performance
D)  DBMS performanceE) C) and D)
F) A) and D)

Question 14

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

Accepted Answer

A)  Database statistics
B)  Data sparsity
C)  A bitmap index
D)  ClusteringE) None of the above
F) C) and D)

Question 15

Summarize the steps required to formulate a query.

Accepted Answer

Queries are usually written to answer qu...

Question 16

The data cache or is a shared,reserved memory area that stores the most recently accessed data blocks in RAM.

Accepted Answer

A)  buffer cache
B)  procedure cache
C)  SQL cache
D)  permanent storageE) All of the above
F) B) and C)

Question 17

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

Accepted Answer

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

Question 18

Indexes do not facilitate join operations.

Accepted Answer

A) True 
 B)False

Question 19

Character field comparisons are faster than numeric,date,and NULL comparisons.

Accepted Answer

A) True 
 B)False

Question 20

In the context of RAID levels,striped arrays provide:

Accepted Answer

A)  increased read performance and fault tolerance.
B)  increased fault tolerance but decreased performance.
C)  increased read performance but no fault tolerance.
D)  neither fault tolerance nor good performance.E) C) and D)
F) A) and B)

Exam 11: Database Performance Tuning and Query Optimization

helps provide a balance between performance and fault tolerance.

Correct AnswerverifiedRAID Redundant array...View AnswerShow Answer

The data cache caches system catalog data and the contents of the indexes.

Correct AnswerverifiedShow Answer

List and describe some typical DBMS processes.

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

The data cache is where the data read from the database data files are stored the data have been read or the data are written to the database data files.

Correct AnswerverifiedShow Answer

DBMS query processing has phases.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

An index scan is less efficient than a full table scan.

Correct AnswerverifiedShow Answer

DBMS implementations are typically similar in complexity to two-tier client/server configurations.

Correct AnswerverifiedFalse

is the central activity during the parsing phase in query processing.

Correct AnswerverifiedShow Answer

The table space is used to store the data dictionary tables.

Correct AnswerverifiedShow Answer

On the client side,the objective is to generate an SQL query that returns a correct answer in the least amount of time,using a minimum amount of resources at the server end.The activities required to achieve this goal are commonly referred to as tuning.

Correct AnswerverifiedShow Answer

End users and the DBMS interact through the use of to generate information.

Correct Answerverifiedqueries

On the server side,the database environment must be properly configured to respond to clients' requests in the fastest way possible,while making optimum use of existing resources.The activities required to achieve this goal are commonly referred to as tuning.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Summarize the steps required to formulate a query.

Correct AnswerverifiedQueries are usually written to answer qu...View AnswerShow Answer

The data cache or is a shared,reserved memory area that stores the most recently accessed data blocks in RAM.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedA

Indexes do not facilitate join operations.

Correct AnswerverifiedShow Answer

Character field comparisons are faster than numeric,date,and NULL comparisons.

Correct AnswerverifiedShow Answer

In the context of RAID levels,striped arrays provide:

Correct AnswerverifiedShow Answer

Correct Answer
verified
RAID Redundant array...
View Answer

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
False

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
queries

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Queries are usually written to answer qu...
View Answer

Correct Answer
verified

Correct Answer
verified
A

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified