Intro to DBMS

Knowledge: What is a DBMS?

• A) A system used to store and manage data
• B) A system used to analyze data
• C) A system used to design data
• D) A system used to back up data

Synthesis: Which of the following is an example of a database management system?

• A) MySQL
• B) Microsoft Excel
• C) Adobe Photoshop
• D) None of the Above

Knowledge: What is an example of an application of a database management system (DBMS)?

• A) A personal calendar app
• B) A word processing software
• C) A sales tracking system
• D) None of the above

Comprehension: How can a DBMS be used in a school's student records system?

• A) To create class schedules
• B) To manage student grades
• C) To manage school finances
• D) None of the above

Knowledge: Which level of abstraction in a database management system (DBMS) is concerned with how data is stored on disk and accessed by the system?

• A) Physical level
• B) Logical level
• C) View level
• D) None of the above

Comprehension: What is the purpose of the logical level in a DBMS?

• A) To define how data is stored on disk
• B) To define how data is presented to users
• C) To define how data is manipulated by the system
• D) None of the above

Application: If a database schema defines a table "customers" with columns "id", "name", and "email", what would be an example of an instance of this table?

• A) A SQL query that selects all customers with a specific email address
• B) A specific row in the table that contains a customer's information
• C) A stored procedure that updates the name of a customer
• D) None of the above

Comprehension: What is the difference between a database schema and a database instance in a DBMS?

• A) A schema is a conceptual model, while an instance is a physical representation of the data
• B) A schema is a physical representation of the data, while an instance is a logical representation
• C) A schema defines the structure and relationships of the data, while an instance is a specific instantiation of that schema
• D) None of the above

Comprehension: What is the purpose of the logical level in a DBMS?

• A) To define how data is stored on disk
• B) To define how data is presented to users
• C) To define how data is manipulated by the system
• D) None of the above

Knowledge: Which of the following is an application of a database management system (DBMS)?

• A) Managing a personal to-do list
• B) Creating a budget spreadsheet
• C) Tracking sales data in a retail store
• D) None of the above