CHAPTER 1 BLIS

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

• Link to external databases

• Uniquely identify every record

• Provide additional security

• Store multiple values

What is the difference between data and information?

• Data is unprocessed facts, while information is processed data

• Data and information are the same

• Data is processed facts, while information is unprocessed data

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

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

• References the primary key of other tables

• Enforces uniqueness among rows

• Provides a way to retrieve data

• Stores metadata about the database

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

• Reduces data consistency

• Increases data redundancy

• More realistic and uses real-world entities

• Less secure than using abstract entities

What is the main function of Designers in a DBMS?

• Work on the designing part of the database

• Create access profiles for users

• Maintain the DBMS resources

• Analyze market rates

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

• Store raw facts in the database

• Efficiently retrieve and manipulate data

• Maintain data consistency

• Create relationships between tables

What is the role of Administrators in a DBMS?

• Design the database structure

• Analyze data for business purposes

• Retrieve and manipulate data

• Maintain and administer the database

What is the main purpose of a DBMS?

• Create raw facts

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

• Collect information

• Produce statistics

What are the ACID properties in a DBMS?

• Atomicity, Consistency, Integrity, Durability

• Accuracy, Consistency, Isolation, Durability

• Atomicity, Consistency, Isolation, Reliability

• Atomicity, Consistency, Isolation, Durability

What is the significance of a Relationship in a DBMS?

• An association between common fields in two tables

• A method to increase data redundancy

• A technique to reduce data consistency

• A way to store raw facts