Zybook 4-4 Flashcards
(19 cards)
Manages database connections and compiles SQL queries.
Query Processor
Contains MySQL Workbench.
Tools
Does not directly interact with the query processor.
File System
Executes instructions compiled from SQL queries.
Storage Engine
An application program is part of the tools layer.
False
The Workbench is intended primarily for database users.
False
A program that helps database administrators configure MySQL is considered a utility program.
True
Many Connector tools are built on top of API tools.
True
Which component detects a missing semicolon at the end of an SQL statement?
Query parser
Which component detects an incorrect database server address?
Connection manager
Which component determines that a query was recently executed?
Cache manager
Oracle Database has multiple storage engines.
False
What block does InnoDB discard when more space is needed in the buffer?
The block that has not been accessed for the longest time.
After the above animation completes, block C is updated and block G is read from the file system. What happens to the buffer?
Block C moves to the top, block D is discarded, and block G moves to the top.
Which is not a MySQL storage engine?
MongoDB
Which storage engine is commonly used for transaction management?
InnoDB
The __________ describes tables, columns, keys, indexes, and other database objects.
data dictionary
The ___________ table provides various table statistics and is used by the query optimizer to generate efficient execution plans.
table_stats
_________ support database recovery in the event of a system failure.
log files
