Database Fundamentals Quiz

What is a database?

• A place where you store your snacks

• A system to organize and retrieve data

• A social media platform

• A video game console

Which of these is an example of structured data?

• A list of students in a table

• A random selfie on social media

• A handwritten note

• A painting

What does DBMS stand for?

• Database Management System

• Digital Bank Management Service

• Data Backup Main Server

• Dynamic Business Model Structure

Which of the following is NOT a database model?

• Relational

• NoSQL

• Circular

• Hierarchical

What is a primary key?

• The most important door to a building

• A unique identifier for a database record

• A key used to open your locker

• The password to access a database

Which SQL command is used to view all records in a table?

• SELECT * FROM table_name;

• DELETE FROM table_name;

• INSERT INTO table_name;

• UPDATE table_name;

What kind of relationship exists when one student can enroll in many courses?

• One-to-One

• One-to-Many

• Many-to-Many

• None

Which of these is NOT a function of a DBMS?

• Data storage

• Data retrieval

• Data cooking

• Data security

In databases, what is a ‘record’?

• A song stored in the system

• A row in a table representing one entity

• A key that opens the database

• A type of primary key

Which of these could be a foreign key?

• Student ID in a student table

• Course ID in an enrollment table linking to courses

• The password for the database

• The database server name