Database Concepts Quiz

In a three-tier architecture, which tier is responsible for business logic?

• Presentation Tier

• Data Tier

• Application Tier

• Client Tier

Data independence refers to:

• The ability to run queries without a database

• The ability to change the database schema without affecting the application

• The ability to use multiple database types

• The independence of data from the user interface

The cardinality ratio of a relationship describes:

• The physical storage size of data

• The number of attributes in a table

• The number of instances of one entity that can or must be associated with instances of another entity

• The speed of data retrieval

Which of the following is NOT a type of database model?

• Relational Model

• Hierarchical Model

• Network Model

• Graphical Model

In database terminology, an entity is best defined as:

• A unique identifier for a record

• A real-world object or concept represented in the database

• A collection of attributes

• A set of relationships

Which type of key is used to uniquely identify a record in a database table?

• Foreign Key

• Composite Key

• Primary Key

• Candidate Key

A foreign key in a database is used to:

• Increase data storage capacity

• Enforce referential integrity between two tables

• Serve as a primary key in the same table

• Improve data retrieval speed

Which SQL statement is used to retrieve data from a database?

• GET

• SELECT

• FETCH

• READ

In a relational database, what does normalization help to achieve?

• Increase redundancy

• Improve performance

• Reduce data anomalies

• Simplify queries

Which of the following describes a composite key?

• A single attribute that uniquely identifies a record

• A combination of two or more attributes that uniquely identifies a record

• A key used to establish a relationship between two tables

• A key that cannot be null