©GRACEAMELIA 2024/2025 ACADEMIC YEAR. ALL RIGHTS RESERVED
FIRST PUBLISH OCTOBER 2024
Cs430 Exam Practice Questions and
Answers
A relationship in a database is which of the following? - Ans:✔✔-An association between entities
T/F: Atomicity refers to the requirements that either all of a transaction must occur or none of it. -
Ans:✔✔-True
T/F: The person that has central control over a DBMS is called a DataBase Administrator (DBA) - Ans:✔✔-
True
T/F: An attribute takes a null value when the value of the attribute is computed to be zero. - Ans:✔✔-
False
T/F: The schema developed at the conceptual design phase provides a detailed overview of the
enterprise. - Ans:✔✔-True
One very important advantage of using a DBMS is that it offers data independence. This is defined as
what? - Ans:✔✔-Application programs are insulated from changes in the way data is structured and
stored.
Page 1/35
, ©GRACEAMELIA 2024/2025 ACADEMIC YEAR. ALL RIGHTS RESERVED
FIRST PUBLISH OCTOBER 2024
A language that is used to express database queries and updates is called: - Ans:✔✔-A data manipulation
language
A language in which a user specifies a database schema is called: - Ans:✔✔-A data definition language
Typical functions of a database administrator would include which of the following? - Ans:✔✔-Storage
structure and access-method definition
Schema definition.
Security and access rights definitions.
T/F: The DDL interpreter of the query processor is responsible for query optimization. - Ans:✔✔-False
T/F: It is desirable for all users to see the entire logical model. - Ans:✔✔-False
Which of the following are components of the storage manager? - Ans:✔✔-Buffer Manager
Authorization and integrity manager
Transaction manager
File Manager
Which of the following are the data structures the storage manager implements as part of the physical
system? - Ans:✔✔-Indices
Page 2/35
, ©GRACEAMELIA 2024/2025 ACADEMIC YEAR. ALL RIGHTS RESERVED
FIRST PUBLISH OCTOBER 2024
Data files
Data dictionary
A data dictionary contains ____________________, data about data. - Ans:✔✔-metadata
Table: - Ans:✔✔-collection of relations / entity set
Row: - Ans:✔✔-represents a relationship among a set of values/entity
Column headers are: - Ans:✔✔-attributes
Domain: - Ans:✔✔-set of permitted values
Which of the following are disadvantages to file processing systems? - Ans:✔✔-Operating systems
provide only a password mechanism for access control.
We must protect the data from inconsistent changes made by different users accessing the data
concurrently.
We need special programs to answer each question a user may want to ask about the data.
Page 3/35
, ©GRACEAMELIA 2024/2025 ACADEMIC YEAR. ALL RIGHTS RESERVED
FIRST PUBLISH OCTOBER 2024
We must ensure the data is restored to a consistent state if the system cashes while changes are being
made.
T/F: It is not possible for several attributes to have the same domain, we require they be unique. -
Ans:✔✔-False
A ___________________ is a minimal superkey. - Ans:✔✔-Candidate key
T/F: Relational Algebra is a non-procedural query language. - Ans:✔✔-False
T/F: For each attribute, there is a set of permitted values called the domain or the value set. - Ans:✔✔-
True
The logical design of the database is called which of the following? - Ans:✔✔-Database schema
T/F: The schema of a relation changes when tuples are added to the database. - Ans:✔✔-False
T/F: The order of how a tuple appears in a relations is extremely important as that is what determines
the primary key. - Ans:✔✔-False
An instance of a relation is which of the following: - Ans:✔✔-A set of tuples, also called records, in which
each tuple has the same number of fields as the relation schema.
A domain is _____________________ if the elements of the domain are considered to be indivisible
units. - Ans:✔✔-Atomic
Page 4/35
FIRST PUBLISH OCTOBER 2024
Cs430 Exam Practice Questions and
Answers
A relationship in a database is which of the following? - Ans:✔✔-An association between entities
T/F: Atomicity refers to the requirements that either all of a transaction must occur or none of it. -
Ans:✔✔-True
T/F: The person that has central control over a DBMS is called a DataBase Administrator (DBA) - Ans:✔✔-
True
T/F: An attribute takes a null value when the value of the attribute is computed to be zero. - Ans:✔✔-
False
T/F: The schema developed at the conceptual design phase provides a detailed overview of the
enterprise. - Ans:✔✔-True
One very important advantage of using a DBMS is that it offers data independence. This is defined as
what? - Ans:✔✔-Application programs are insulated from changes in the way data is structured and
stored.
Page 1/35
, ©GRACEAMELIA 2024/2025 ACADEMIC YEAR. ALL RIGHTS RESERVED
FIRST PUBLISH OCTOBER 2024
A language that is used to express database queries and updates is called: - Ans:✔✔-A data manipulation
language
A language in which a user specifies a database schema is called: - Ans:✔✔-A data definition language
Typical functions of a database administrator would include which of the following? - Ans:✔✔-Storage
structure and access-method definition
Schema definition.
Security and access rights definitions.
T/F: The DDL interpreter of the query processor is responsible for query optimization. - Ans:✔✔-False
T/F: It is desirable for all users to see the entire logical model. - Ans:✔✔-False
Which of the following are components of the storage manager? - Ans:✔✔-Buffer Manager
Authorization and integrity manager
Transaction manager
File Manager
Which of the following are the data structures the storage manager implements as part of the physical
system? - Ans:✔✔-Indices
Page 2/35
, ©GRACEAMELIA 2024/2025 ACADEMIC YEAR. ALL RIGHTS RESERVED
FIRST PUBLISH OCTOBER 2024
Data files
Data dictionary
A data dictionary contains ____________________, data about data. - Ans:✔✔-metadata
Table: - Ans:✔✔-collection of relations / entity set
Row: - Ans:✔✔-represents a relationship among a set of values/entity
Column headers are: - Ans:✔✔-attributes
Domain: - Ans:✔✔-set of permitted values
Which of the following are disadvantages to file processing systems? - Ans:✔✔-Operating systems
provide only a password mechanism for access control.
We must protect the data from inconsistent changes made by different users accessing the data
concurrently.
We need special programs to answer each question a user may want to ask about the data.
Page 3/35
, ©GRACEAMELIA 2024/2025 ACADEMIC YEAR. ALL RIGHTS RESERVED
FIRST PUBLISH OCTOBER 2024
We must ensure the data is restored to a consistent state if the system cashes while changes are being
made.
T/F: It is not possible for several attributes to have the same domain, we require they be unique. -
Ans:✔✔-False
A ___________________ is a minimal superkey. - Ans:✔✔-Candidate key
T/F: Relational Algebra is a non-procedural query language. - Ans:✔✔-False
T/F: For each attribute, there is a set of permitted values called the domain or the value set. - Ans:✔✔-
True
The logical design of the database is called which of the following? - Ans:✔✔-Database schema
T/F: The schema of a relation changes when tuples are added to the database. - Ans:✔✔-False
T/F: The order of how a tuple appears in a relations is extremely important as that is what determines
the primary key. - Ans:✔✔-False
An instance of a relation is which of the following: - Ans:✔✔-A set of tuples, also called records, in which
each tuple has the same number of fields as the relation schema.
A domain is _____________________ if the elements of the domain are considered to be indivisible
units. - Ans:✔✔-Atomic
Page 4/35
