Database Fundamentals Assessment

What is a database?

• A database is a physical storage device for files.

• A database is a type of software used for web browsing.

• A database is an organized collection of data that can be easily accessed, managed, and updated.

• A database is a collection of random files without structure.

What is a Database Management System (DBMS)?

• A Database Management System (DBMS) is a type of hardware used for data storage.

• A Database Management System (DBMS) is a programming language for web development.

• A Database Management System (DBMS) is a cloud service for file sharing.

• A Database Management System (DBMS) is software that facilitates the creation, management, and manipulation of databases.

Which of the following is a feature of a Database Management System?

• File storage management

• User authentication

• Concurrency control

• Data encryption

Which of the following components resembles a field in a database?

• database

• table

• row

• column

Databases in educational institutions are used to store:

• Extracurricular activities and events

• Campus facilities and maintenance

• Student records, grades, attendance, course materials, and faculty information.

• Library books and resources

What does SQL stand for?

• Standard Query Language

• Simple Query Language

• Structured Query List

• Structured Query Language

Which of the following is a type of database model?

• Relational model

• Hierarchical model

• Network model

• Object-oriented model

What is the primary purpose of a database index?

• To ensure data integrity and consistency.

• To store data in a structured format.

• To create backups of the database.

• To improve the speed of data retrieval operations.

Which of the following is NOT a type of database?

• spreadsheet

• data warehouse

• cloud storage

• file system

What is normalization in the context of databases?

• Normalization is a method for encrypting sensitive data.

• Normalization refers to the physical storage of data on disk.

• Normalization is the process of increasing data redundancy.

• Normalization in databases is the process of structuring data to minimize redundancy and dependency.