CIT 214

10 cards·by heltonce81

What are the three techniques to control deadlock?

Prevention, Detection, and Avoidance

What are the levels that can take place with the use of locking?

Database, Table, Page, Row, and Field

What types of locks are there?

Binary and Exclusive/Shared Locks

What are the three phases of DBMS processing queries?

Parsing, execution, and fetching.

How can application performance be improved for a database client?

optimize SQL in client application

What is a exclusive lock?

A lock that is reserved by a transaction.

All data is stored in what kind of files?

Data.

A table space is what?

a logical grouping of several data files that store data with similar characteristics.

What does an optimizer DBMS process do?

Analyzes SQL queries and finds the most efficient way to access the data.

The SQL parsing activities are performed by what?

Query optimizer