Database Concepts Quiz (Lecture W1)

What is a database?

• A programming language for data manipulation

• A type of software for managing applications

• A shared, integrated computer structure that stores related data

• A collection of unrelated data

Which of the following is an example of end user data?

• Data characteristics

• Database management system

• Database structure

• Patient ID

What does metadata refer to?

• Database management software

• Raw facts of interest

• User access permissions

• Data about data

Which of the following is NOT a type of database management system (DBMS)?

• PostgreSQL

• HTML

• Oracle

• MySQL

What is the primary function of a DBMS?

• To store data in a non-integrated manner

• To create programming languages

• To manage the database structure and control access to data

• To generate reports for users

In a hospital database, which table would contain information about patients?

• Appointments Table

• Doctors Table

• Patients Table

• Prescriptions Table

Which of the following best describes a database system?

• A programming language for databases

• A single table of data

• An organization of components that manage data

• A collection of unrelated data

What is an example of a database management system?

• Adobe Photoshop

• Windows OS

• MySQL

• Microsoft Word

Which of the following is a characteristic of metadata?

• It is raw data

• It describes data characteristics

• It is only used for storage

• It is not related to end user data

What type of data does the 'Appointments Table' in a hospital database contain?

• Prescription details

• Appointment ID, Patient ID, Doctor ID, Date & Time

• Doctor specialization

• Patient medical history