Database Pop Quiz

Which of the following is a limitation of the traditional file-based approach?

• Centralized data access

• Data redundancy and inconsistency

• High data independence

• Automatic backup and recovery

What is the main function of a DBMS?

• To write application code

• To manage data structures only

• To provide access and control over databases

• To design graphical user interfaces

Which component of the DBMS environment manages the physical storage?

• DDL

• DML

• Storage Manager

• Query Processor

In the ANSI-SPARC architecture, which level provides the user view of the data?

• Internal level

• External level

• Conceptual level

• Physical level

What is data independence?

• The ability to access data quickly

• The separation between data and application

• The sharing of data among users

• The process of normalizing data

Which language is used to define the database schema?

• DML

• SQL

• DDL

• HTML

Which of the following is not a function of a DBMS?

• Backup and recovery

• Data storage management

• Web development

• Authorization control

Which model is most commonly used in modern relational databases?

• Network Model

• Object-Oriented Model

• Relational Model

• Hierarchical Model

Which of the following is a relational key that uniquely identifies each record in a table?

• Foreign key

• Super key

• Primary key

• Alternate key

What does a foreign key do in a relational schema?

• Stores NULL values only

• Identifies each record uniquely

• Links tables through relationships

• Increases performance