Database Design & Development - Ch. 10 & 11

Flashcards based on information from Chapters 10 and 11

14 cards·by SSJwiggy

pokemansdatabaseseric luczaj

What is data/buffer cache?

Shared, reserved memory area that stores the most recently access data blocks in RAM

What does SQL/procedure cache do?

Stores most recently executed SQL statements & PL/SQL procedures, including triggers and functions

All data in databases are stored in what?

Data Files

The goal of database performance is what?

To execute queries as fast as possible

A ______ side query generates an SQL query that returns correct answers in the least amount of time

Client

What does a lock do?

Guarantees exclusive use of a data item to a current transaction

A _____ lock is when concurrent transactions are granted read access on the basis of a common lock

Shared

What is the condition that occurs when two transactions wait for each other to unlock data?

Deadlocks

What are temporary storage areas in primary memory?

Buffers

What assigns a unique time stamp to each transaction?

Time Stamps

A _________ establishes the order in which concurrent transaction operations are executed

Scheduler

Prevention, detection, and avoidance are techniques to control what?

Deadlock

A Shared, reserved memory area

Data/buffer cache

Listener, User, Scheduler, Lock manager, Optimizer are all typical what?

DBMS processes