CHAPTER 1 BLIS

What is the main purpose of a DBMS?

• Produce statistics

• Collect information

• Store data in a way that makes it easier to manage

• Create raw facts

What is the difference between data and information?

• Data is unprocessed facts, while information is processed data

• Data is related to people, while information is related to places

• Data is processed facts, while information is unprocessed data

• Data and information are the same

What are the ACID properties in a DBMS?

• Atomicity, Consistency, Isolation, Reliability

• Atomicity, Consistency, Integrity, Durability

• Accuracy, Consistency, Isolation, Durability

• Atomicity, Consistency, Isolation, Durability

What is the purpose of a Primary Key in a database table?

• Uniquely identify every record

• Store multiple values

• Link to external databases

• Provide additional security

What is the role of Administrators in a DBMS?

• Analyze data for business purposes

• Design the database structure

• Maintain and administer the database

• Retrieve and manipulate data

What is the purpose of a Foreign Key in a database table?

• Provides a way to retrieve data

• References the primary key of other tables

• Enforces uniqueness among rows

• Stores metadata about the database

What is the benefit of using a DBMS in a multi-user environment?

• Reduces data redundancy

• Supports multiple users with different views

• Limits access to a single user

• Increases data inconsistency

What is the main advantage of using real-world entities in a database?

• Increases data redundancy

• Less secure than using abstract entities

• More realistic and uses real-world entities

• Reduces data consistency

What is the purpose of a Query Language in a DBMS?

• Store raw facts in the database

• Create relationships between tables

• Efficiently retrieve and manipulate data

• Maintain data consistency

What is the significance of Isolation of data and application in a DBMS?

• Database is passive while data is active

• Database does not store metadata

• Database is different from its data

• Data redundancy is increased