Introduction to Database

What is a database?

• A collection of unrelated data

• A large, integrated collection of data

• A software for data processing

• A program for data entry

What does DBMS stand for?

• Database Model System

• Database Manipulation System

• Database Management System

• Data-Based Model Software

Which of the following is NOT a database application?

• Banking

• Sales

• Spreadsheets

• Human Resources

What is the primary purpose of a DBMS?

• To store and manage data efficiently

• To replace physical files

• To serve as an operating system

• To format documents

Which of the following is a type of data model?

• Entity-Relationship model

• Hierarchical model

• Relational model

• All of the above

A schema in a relational model describes:

• Columns or fields in a table

• Rows of data in a table

• User privileges

• Storage devices

What is an example of a conceptual schema in a university database?

• Students(sid, name, age, gpa)

• Indexes on first column

• Raw data files

• Views defined by users

Which level of abstraction defines how users see the data?

• Physical schema

• Conceptual schema

• View schema

• Logical schema

What does logical data independence protect against?

• Changes in physical data structure

• Changes in logical data structure

• User mistakes

• Network failures

What is a key advantage of DBMS?

• Data redundancy

• Data integrity

• Increased storage space

• Reduced performance