CS430 Midterm Study Guide || A+ Guaranteed.
What is the buffer manager responsibility? correct answers Brings pages in from disk to memory
as needed in response to read requests
An attribute takes a null value when the value of the attribute is computed to be zero. correct
answers False
Which of the following are the data structures the storage manager implements as part of the
physical system? correct answers Data dictionary
Data files
Indicies
A data dictionary contains ____________________, data about data. correct answers Metadata
Durability refers to the fact that values within a database must survive system failures. correct
answers True
Which of the following are reasons to let the DBMS manage disk space and buffer management
as opposed to the OS? correct answers Portability issues between OS
OS Limitations i.e. files spanning disk
Need the ability to perform special tasks such as pinning a page, pre-fetch policy, etc.
Entities are described in a database by which of the following? correct answers A set of attributes
In which phases does the design move from an abstract data mode to the design of the database
correct answers logical design phase
physical design phase
A language in which a user specifies a database schema is called: correct answers A data
definition language
A storage manager is a program module that provides the interface between the low-level data
stored in the database and the applications programs and queries submitted to the system. correct
answers True
Atomicity refers to the requirements that either all of a transaction must occur or none of it.
correct answers True
A __________________ is a set of one or more attributes that uniquely identify an entity (or
tuple). correct answers Superkey
A database schema is depicted by which of the following? correct answers Schema Diagram
, A foreign key is the primary key of another relation schema. correct answers True
A query language is a language in which the user requests information from the database. correct
answers True
The schema of a relation changes when tuples are added to the database. correct answers False
The output of a relational algebra operation is a single relation. correct answers True
Define Procedural Query Language correct answers The user instructs the system to perform a
sequence of operations
Define Non-Procedural Query Language correct answers The user describes the desired
information
A snapshot of the data in a database at a given time is called which of the following? correct
answers Database instance
It is not possible for several attributes to have the same domain, we require they be unique.
correct answers False
One domain value that is a member of any possible domain is what? correct answers null
A transaction is a single operation that performs multiple logical functions within a database.
correct answers False
A candidate key must consist of a single attribute with an atomic domain. correct answers False
For each attribute, there is a set of permitted values called the domain or the value set. correct
answers True
What is the Query optimizer responsibility correct answers Uses information about how the data
is stored to provide an efficient execution plan for evaluating the query
What is the File and access methods layer responsibility correct answers Supports the concept of
a file, which in DBMS is a collection of pages or a collection of records
What is the disk space manager responsibility correct answers Deals with management of space
on disk, where the data is stored
What is the transaction manager responsibility correct answers Ensures that transactions request
and release locks according to a suitable locking protocol
What is the lock manager responsibility correct answers Keeps track of request for locks and
grant locks on database objects when they become available
What is the buffer manager responsibility? correct answers Brings pages in from disk to memory
as needed in response to read requests
An attribute takes a null value when the value of the attribute is computed to be zero. correct
answers False
Which of the following are the data structures the storage manager implements as part of the
physical system? correct answers Data dictionary
Data files
Indicies
A data dictionary contains ____________________, data about data. correct answers Metadata
Durability refers to the fact that values within a database must survive system failures. correct
answers True
Which of the following are reasons to let the DBMS manage disk space and buffer management
as opposed to the OS? correct answers Portability issues between OS
OS Limitations i.e. files spanning disk
Need the ability to perform special tasks such as pinning a page, pre-fetch policy, etc.
Entities are described in a database by which of the following? correct answers A set of attributes
In which phases does the design move from an abstract data mode to the design of the database
correct answers logical design phase
physical design phase
A language in which a user specifies a database schema is called: correct answers A data
definition language
A storage manager is a program module that provides the interface between the low-level data
stored in the database and the applications programs and queries submitted to the system. correct
answers True
Atomicity refers to the requirements that either all of a transaction must occur or none of it.
correct answers True
A __________________ is a set of one or more attributes that uniquely identify an entity (or
tuple). correct answers Superkey
A database schema is depicted by which of the following? correct answers Schema Diagram
, A foreign key is the primary key of another relation schema. correct answers True
A query language is a language in which the user requests information from the database. correct
answers True
The schema of a relation changes when tuples are added to the database. correct answers False
The output of a relational algebra operation is a single relation. correct answers True
Define Procedural Query Language correct answers The user instructs the system to perform a
sequence of operations
Define Non-Procedural Query Language correct answers The user describes the desired
information
A snapshot of the data in a database at a given time is called which of the following? correct
answers Database instance
It is not possible for several attributes to have the same domain, we require they be unique.
correct answers False
One domain value that is a member of any possible domain is what? correct answers null
A transaction is a single operation that performs multiple logical functions within a database.
correct answers False
A candidate key must consist of a single attribute with an atomic domain. correct answers False
For each attribute, there is a set of permitted values called the domain or the value set. correct
answers True
What is the Query optimizer responsibility correct answers Uses information about how the data
is stored to provide an efficient execution plan for evaluating the query
What is the File and access methods layer responsibility correct answers Supports the concept of
a file, which in DBMS is a collection of pages or a collection of records
What is the disk space manager responsibility correct answers Deals with management of space
on disk, where the data is stored
What is the transaction manager responsibility correct answers Ensures that transactions request
and release locks according to a suitable locking protocol
What is the lock manager responsibility correct answers Keeps track of request for locks and
grant locks on database objects when they become available
