1 for specific request mail
CS 4001 Quiz 1 Questions and Correct Answers |
Latest Update
The characteristic provided by DBMSs and data models that allows
program-data independence and program-operation independence is
Ans: 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)
© 2026 Assignment
Ans: T
A data model is used to describe the structure of a database. Which of the
Guru01 - Stuvia
following concepts are included in the structure/schema of a database?
Expert
(a) data types
(b) relationships
(c) constraints
(d) All of the above Ans: (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.
, 2 for specific request mail
(d) All of the above Ans: (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
© 2026 Assignment
(d) none of the above Ans: (b) relational data model
The data in the database at a particular point in time is called a ________.
Guru01 - Stuvia
Expert
(a) database state
(b) database schema
(c) meta state
(d) logical database Ans: (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 Ans: (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
CS 4001 Quiz 1 Questions and Correct Answers |
Latest Update
The characteristic provided by DBMSs and data models that allows
program-data independence and program-operation independence is
Ans: 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)
© 2026 Assignment
Ans: T
A data model is used to describe the structure of a database. Which of the
Guru01 - Stuvia
following concepts are included in the structure/schema of a database?
Expert
(a) data types
(b) relationships
(c) constraints
(d) All of the above Ans: (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.
, 2 for specific request mail
(d) All of the above Ans: (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
© 2026 Assignment
(d) none of the above Ans: (b) relational data model
The data in the database at a particular point in time is called a ________.
Guru01 - Stuvia
Expert
(a) database state
(b) database schema
(c) meta state
(d) logical database Ans: (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 Ans: (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
