Introduction to Database Systems

A DBMS is best described as:

Which is a drawback of storing data directly in file systems?

Which level of abstraction describes how a record is actually stored on the device?

The actual content of the database at a particular point in time is called:

`create table instructor (...)` is an example of which language?

The data dictionary stores:

Which is the most widely used commercial DML / query language?

What is the correct order of query processing steps?

Which ACID property guarantees a committed transaction survives system failures?

Which is NOT one of the listed database architectures?

Database systems solve the redundancy, atomicity, concurrency, and security problems of file systems.

Atomicity means a transaction may be left partially completed after a failure.

The logical level describes what data is stored and the relationships among the data.

Physical data independence is the ability to modify the physical schema without changing the logical schema.

DML is used to define the database schema.

In the relational model, all data is stored in tables of rows and columns.

ODBC/JDBC are APIs that allow SQL queries to be sent to a database.

XML was originally designed as a database query language.

The storage manager handles indexing, hashing, and file organization.

The goal of query optimization is to maximize execution time.

Match each level of abstraction with what it describes.

Match each ACID property with its guarantee.

Match each language/term with its role.

Match each query processing step with its action.

Match each data model with its description.