Question 1

____________________ is a measure of how likely an index will be used in query processing.

Accepted Answer

The answer of ____________________ is a measure of how likely...

Question 2

The ____ is a shared,reserved memory area that stores the most recently executed SQL statements or PL/SQL procedures,including triggers and functions.

Accepted Answer

A)   buffer cache
B)   procedure cache
C)   data cache
D)   permanent storageE) A) and C)
F) A) and B)

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

____________________ is another name for table space.

Accepted Answer

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

Question 5

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

Question 6

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

Accepted Answer

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

Question 7

A(n) ____ is a logical grouping of several data files that store data with similar characteristics.

Accepted Answer

A)   procedure cache
B)   file group
C)   data files
D)   extendsE) B) and D)
F) A) and B)

Question 8

The ____________________ cache is a shared,reserved memory area that stores the most recently executed SQL statements or PL/SQL procedures,including triggers and functions.

Accepted Answer

The answer of The ____________________ cache is a shared,reserved memory...

Question 9

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) All of the above F) A) and B)

Question 10

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) None of the above
F) B) and C)

Question 11

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

Question 12

Why do we need to optimize a DBMS with SQL performance tuning,even though they automatically optimize SQL queries?

Accepted Answer

There is considerable room for improveme...

Question 13

The SQL cache stores the end-user written SQL.

Accepted Answer

A) True 
 B)False

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

Question 15

____________________ 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 16

The DBMS ____ the SQL query using the chosen execution plan.

Accepted Answer

A)   parses
B)   executes
C)   fetches
D)   processesE) C) and D)
F) A) and C)

Question 17

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 18

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) None of the above
F) All of the above

Question 19

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

Question 20

On the server side,the DBMS 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 that goal are commonly referred to as ____ tuning.

Accepted Answer

A)   client and server
B)   database
C)   SQL performance
D)   DBMS performanceE) None of the above
F) A) and D)

Exam 11: Database Performance Tuning and Query Optimization

The ____ is a shared,reserved memory area that stores the most recently executed SQL statements or PL/SQL procedures,including triggers and functions.

Correct AnswerverifiedShow Answer

On the server side,the DBMS 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 that goal are commonly referred to as ____ tuning.

Correct AnswerverifiedShow 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 ____ table space is used for transaction-recovery purposes.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Why do we need to optimize a DBMS with SQL performance tuning,even though they automatically optimize SQL queries?

Correct AnswerverifiedThere is considerable room for improveme...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

____________________ is a measure of how likely an index will be used in query processing.

Correct AnswerverifiedShow 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

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

Correct AnswerverifiedShow Answer

A(n) ____ is a logical grouping of several data files that store data with similar characteristics.

Correct AnswerverifiedShow Answer

The ____________________ cache is a shared,reserved memory area that stores the most recently executed SQL statements or PL/SQL procedures,including triggers and functions.

Correct AnswerverifiedShow Answer

The DBMS ____ the SQL query using the chosen execution plan.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The SQL cache stores the end-user written SQL.

Correct AnswerverifiedShow Answer

____________________ is another name for table space.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
There is considerable room for improveme...
View Answer

Correct Answer
verified

Correct Answer
verified

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 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