CS 4001 QUIZ 1 | QUESTIONS AND ANSWERS |
2026 UPDATE 100% CORRECT ALREADY
GRADED A+
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 - ANSWERS-(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 - ANSWERS-(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 - ANSWERS-(c) logical data independence
Data definition, view definition and data manipulation are handled in one
integrated language known as SQL in current database management
systems based on the relational data model.
(a) True
(b) False - ANSWERS-(a) True
, The characteristic provided by DBMSs and data models that allows program-
data independence and program-operation independence is - ANSWERS-
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) - ANSWERS-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 - ANSWERS-(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 - ANSWERS-(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
2026 UPDATE 100% CORRECT ALREADY
GRADED A+
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 - ANSWERS-(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 - ANSWERS-(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 - ANSWERS-(c) logical data independence
Data definition, view definition and data manipulation are handled in one
integrated language known as SQL in current database management
systems based on the relational data model.
(a) True
(b) False - ANSWERS-(a) True
, The characteristic provided by DBMSs and data models that allows program-
data independence and program-operation independence is - ANSWERS-
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) - ANSWERS-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 - ANSWERS-(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 - ANSWERS-(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
