Database Systems: A Practical Approach to
Design, Implementation, and Management (6th
Edition, by Thomas Connolly) - Complete Test
Bank
## Part 1: Introduction to Databases (Questions 1–30)
**1. Which of the following is NOT a typical characteristic of a database approach?**
A) Self‑describing nature
B) Insulation between programs and data
C) Data redundancy is maximised
D) Multiple views of data
**Answer: C**
**Rationale:** A key goal of the database approach is to *minimise* data redundancy, not
maximise it. The approach emphasises data independence, self‑description (via the catalog),
and support for multiple user views.
---
**2. The three‑level ANSI‑SPARC architecture consists of which levels?**
A) Physical, Logical, View
B) Internal, Conceptual, External
C) Storage, Global, User
D) File, Relational, Object
**Answer: B**
,**Rationale:** The ANSI‑SPARC architecture defines three levels: the *internal* (physical
storage), the *conceptual* (global logical structure), and the *external* (user views).
---
**3. At which level of the ANSI‑SPARC architecture does a user’s personal view of the database
reside?**
A) Internal level
B) Conceptual level
C) External level
D) Physical level
**Answer: C**
**Rationale:** The *external level* represents the part of the database that is relevant to a
particular user or application, providing customised and security‑restricted views.
---
**4. Logical data independence means:**
A) Changes to the internal schema do not affect the conceptual schema
B) Changes to the conceptual schema do not require changes to external views
C) Physical storage devices can be changed without affecting user views
D) Data is automatically encrypted
**Answer: B**
**Rationale:** *Logical data independence* is the immunity of external schemas to changes in
the conceptual schema (e.g., adding a new entity).
,---
**5. Which of the following best describes a DBMS?**
A) A collection of related data
B) A software system that enables users to define, create, maintain, and control access to the
database
C) A hardware device for storing data
D) A query language
**Answer: B**
**Rationale:** A Database Management System (DBMS) is the software that sits between the
physical database and the users, providing tools for definition, creation, manipulation, and
access control.
---
**6. A data model is:**
A) A physical storage structure
B) A set of concepts and rules that define the structure of a database
C) A programming language
D) An operating system
**Answer: B**
**Rationale:** A data model provides the concepts and notation to describe the structure of a
database (data types, relationships, constraints) and sometimes the operations on the data.
---
, **7. Which of the following is an example of a conceptual data model?**
A) Relational model
B) Network model
C) Entity‑Relationship model
D) Object‑oriented model
**Answer: C**
**Rationale:** The Entity‑Relationship (ER) model is a high‑level conceptual model used to
represent the data requirements of an enterprise independently of any specific DBMS.
---
**8. A schema is:**
A) The actual data in the database at a particular moment
B) The description of the database structure
C) A user query
D) A backup copy
**Answer: B**
**Rationale:** The *schema* is the database’s structure (or meta‑data) — the description of
the data types, relationships, and constraints — while the *instance* is the actual data content
at a given time.
---
**9. Which of the following is NOT a responsibility of a DBA?**
A) Schema definition
B) Security management
Design, Implementation, and Management (6th
Edition, by Thomas Connolly) - Complete Test
Bank
## Part 1: Introduction to Databases (Questions 1–30)
**1. Which of the following is NOT a typical characteristic of a database approach?**
A) Self‑describing nature
B) Insulation between programs and data
C) Data redundancy is maximised
D) Multiple views of data
**Answer: C**
**Rationale:** A key goal of the database approach is to *minimise* data redundancy, not
maximise it. The approach emphasises data independence, self‑description (via the catalog),
and support for multiple user views.
---
**2. The three‑level ANSI‑SPARC architecture consists of which levels?**
A) Physical, Logical, View
B) Internal, Conceptual, External
C) Storage, Global, User
D) File, Relational, Object
**Answer: B**
,**Rationale:** The ANSI‑SPARC architecture defines three levels: the *internal* (physical
storage), the *conceptual* (global logical structure), and the *external* (user views).
---
**3. At which level of the ANSI‑SPARC architecture does a user’s personal view of the database
reside?**
A) Internal level
B) Conceptual level
C) External level
D) Physical level
**Answer: C**
**Rationale:** The *external level* represents the part of the database that is relevant to a
particular user or application, providing customised and security‑restricted views.
---
**4. Logical data independence means:**
A) Changes to the internal schema do not affect the conceptual schema
B) Changes to the conceptual schema do not require changes to external views
C) Physical storage devices can be changed without affecting user views
D) Data is automatically encrypted
**Answer: B**
**Rationale:** *Logical data independence* is the immunity of external schemas to changes in
the conceptual schema (e.g., adding a new entity).
,---
**5. Which of the following best describes a DBMS?**
A) A collection of related data
B) A software system that enables users to define, create, maintain, and control access to the
database
C) A hardware device for storing data
D) A query language
**Answer: B**
**Rationale:** A Database Management System (DBMS) is the software that sits between the
physical database and the users, providing tools for definition, creation, manipulation, and
access control.
---
**6. A data model is:**
A) A physical storage structure
B) A set of concepts and rules that define the structure of a database
C) A programming language
D) An operating system
**Answer: B**
**Rationale:** A data model provides the concepts and notation to describe the structure of a
database (data types, relationships, constraints) and sometimes the operations on the data.
---
, **7. Which of the following is an example of a conceptual data model?**
A) Relational model
B) Network model
C) Entity‑Relationship model
D) Object‑oriented model
**Answer: C**
**Rationale:** The Entity‑Relationship (ER) model is a high‑level conceptual model used to
represent the data requirements of an enterprise independently of any specific DBMS.
---
**8. A schema is:**
A) The actual data in the database at a particular moment
B) The description of the database structure
C) A user query
D) A backup copy
**Answer: B**
**Rationale:** The *schema* is the database’s structure (or meta‑data) — the description of
the data types, relationships, and constraints — while the *instance* is the actual data content
at a given time.
---
**9. Which of the following is NOT a responsibility of a DBA?**
A) Schema definition
B) Security management
