CS 4001 QUIZ 1 | QUESTIONS AND ANSWERS | 2026
UPDATE 100% CORRECT
The characteristic provided by DBMSs and data models that allows program-
data independence and program-operation independence is Answer - data
abstraction
A fundamental characteristic of the database approach is that the database
system contains not only the database itself but also a definition or description
of the database structure and constraints. (T/F) Answer - T
A data model is used to describe the structure of a database. Which of the
following concepts are included in the structure/schema of a database?
(a) data types
(b) relationships
(c) constraints
(d) All of the above Answer - (d) All of the above
Which of the following statements is true?
(a) End users of a database must know details about the storage structures
used by the database system.
(b) Application programmers are responsible for the physical design of the
database.
(c) The database administrator is responsible for authorizing access to the
database and for maintaining an adequate database system performance level.
, (d) All of the above Answer - (c) The database administrator is responsible for
authorizing access to the database and for maintaining an adequate database
system performance level.
Which of the following is an example of a representational data model?
(a) entity relationship data model
(b) relational data model
(c) access path model
(d) none of the above Answer - (b) relational data model
The data in the database at a particular point in time is called a ________.
(a) database state
(b) database schema
(c) meta state
(d) logical database Answer - (a) database state
The goal of the three schema database architecture is to separate the user
applications from the physical details of a database.
(a) True
(b) False Answer - (a) True
Suppose we change the conceptual schema to add a constraint to the
database. The applications and the external schemas for the database do not
have to be changed. This is an example of what concept?
(a) program operation independence
(b) physical data independence
(c) logical data independence
(d) procedural independence Answer - (c) logical data independence
UPDATE 100% CORRECT
The characteristic provided by DBMSs and data models that allows program-
data independence and program-operation independence is Answer - data
abstraction
A fundamental characteristic of the database approach is that the database
system contains not only the database itself but also a definition or description
of the database structure and constraints. (T/F) Answer - T
A data model is used to describe the structure of a database. Which of the
following concepts are included in the structure/schema of a database?
(a) data types
(b) relationships
(c) constraints
(d) All of the above Answer - (d) All of the above
Which of the following statements is true?
(a) End users of a database must know details about the storage structures
used by the database system.
(b) Application programmers are responsible for the physical design of the
database.
(c) The database administrator is responsible for authorizing access to the
database and for maintaining an adequate database system performance level.
, (d) All of the above Answer - (c) The database administrator is responsible for
authorizing access to the database and for maintaining an adequate database
system performance level.
Which of the following is an example of a representational data model?
(a) entity relationship data model
(b) relational data model
(c) access path model
(d) none of the above Answer - (b) relational data model
The data in the database at a particular point in time is called a ________.
(a) database state
(b) database schema
(c) meta state
(d) logical database Answer - (a) database state
The goal of the three schema database architecture is to separate the user
applications from the physical details of a database.
(a) True
(b) False Answer - (a) True
Suppose we change the conceptual schema to add a constraint to the
database. The applications and the external schemas for the database do not
have to be changed. This is an example of what concept?
(a) program operation independence
(b) physical data independence
(c) logical data independence
(d) procedural independence Answer - (c) logical data independence
