Week 1 Intro to DBMS Quiz 1

What is the term for an organized collection of data stored electronically, managed by specialized software?

• Spreadsheet

• Database

• File System

• Data Warehouse

What software facilitates the storage, retrieval, and manipulation of data in a database?

• Operating System

• Word Processor

• Database Management System (DBMS)

• Web Browser

In a relational database, what is each row in a table called, representing a single instance of an entity?

• Field

• Column

• Record

• Table

What type of key uniquely identifies each record in a table and cannot be null?

• Foreign Key

• Composite Key

• Primary Key

• Candidate Key

Which of the following is NOT a key characteristic of a database?

• Organized

• Ephemeral (temporary)

• Shareable

• Secure

Which function of a DBMS allows users to define the structure of the database, such as creating tables and specifying data types?

• Data Manipulation

• Data Definition

• Data Security

• Data Backup & Recovery

The ability of a DBMS to manage simultaneous access by multiple users to prevent data corruption is known as:

• Data Integrity

• Data Definition

• Concurrency Control

• Data Security

Which of these is a disadvantage associated with using a Database Management System?

• Enhanced Data Organization

• Reduced Data Redundancy

• High Cost

• Improved Data Sharing

In a relational database, what establishes a link between two tables by pointing to the primary key in another table?

• Primary Key

• Foreign Key

• Unique Key

• Super Key

What is the primary purpose of data types and schemas in a database?

• To increase complexity for users.

• To ensure correct data entry and maintain data integrity.

• To limit storage efficiency.

• To prevent data sharing.