IT 221 Information Management Quiz

What is the main difference between data and information?

• Data is collected, while information is analyzed.

• Data is stored in tables, while information is stored in files.

• Data is unprocessed facts, while information is processed data.

• Data is processed, while information is raw.

What is the purpose of a DBMS?

• To analyze data and information.

• To develop software applications.

• To create and manage databases.

• To design websites.

What is the role of Administrators in a DBMS?

• Retrieve and manipulate data.

• Maintain the DBMS and administrate the database.

• Design the database structure.

• Analyze data for business insights.

What is the primary function of a Primary Key in a database table?

• Store metadata about the database.

• Provide access profiles for users.

• Enforce uniqueness among rows.

• Apply filtering options to retrieve data.

What does a Foreign Key in a database table reference?

• The primary key of other tables.

• The filtering options for data retrieval.

• The metadata of the database.

• The access profiles of users.

What is the purpose of ACID properties in a DBMS?

• To establish relationships between tables.

• To enforce security features.

• To create multiple views for users.

• To maintain consistency and durability of data.

What is the benefit of using Real-world Entities in a database?

• It allows for more realistic and meaningful data representation.

• It simplifies the database design process.

• It reduces redundancy in data storage.

• It provides multiple views for users.

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

• To separate the database from its data.

• To store metadata about the database.

• To enforce consistency in data.

• To provide security features.

What is the significance of Query Language in a DBMS?

• It enforces security constraints on data entry.

• It makes it more efficient to retrieve and manipulate data.

• It creates relationships between tables.

• It maintains consistency in the database.

What is the purpose of Multiple Views in a DBMS?

• To create relationships between tables.

• To maintain consistency in data.

• To enforce ACID properties on transactions.

• To offer different perspectives of the database to users.