FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 14: Managing Database and Sql Performance

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 21

Short Answer

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 22

Multiple Choice

Review LaterAdd Note

Review Later

The ____ must be set large enough to permit as many data requests to be serviced from cache as possible.

A) data cache
B) SQL cache
C) sort cache
D) optimizer mode

E) A) and B)
F) C) and D)

Correct Answer

verified

Show Answer

Question 23

Short Answer

Review LaterAdd Note

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

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

RAID systems use a single disk to create storage volumes.

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

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

The DBMS ____ the data and sends the result set back to the client.

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

____ is/are the central activity during the parsing phase in query processing.

A cost-based optimizer uses a set of preset rules and points to determine the best approach to execute a query.

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.

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

The ____________________ table space is the most frequently accessed table space and should be stored in its own volume.

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

A system table space, a user data table space, an index table space, and a temporary table space are examples of ____.

Indexes are very useful in small tables or tables with low sparsity.

All data in a database are stored in ____ files.

A DBA determines the initial size of the data files that make up the database; however, as required, the data files can automatically expand in predefined increments known as ____.

____________________ is another name for table space.