Database Management System Quiz 2

What is data?

• Facts and figures related to any object

• A collection of tables in a database

• A column in a table

• A row in a table

What is a database?

• A way to organise data in a tabular format

• A field in a table

• A row in a table

What are tables in a database?

• Lists of data linked to each other

• Columns in a table

• Rows in a table

• Fields in a table

What is a field in a table?

• A column in a table

• A row in a table

• A record in a table

• An intersection of rows and columns

What is a record in a table?

• A row in a table

• A column in a table

• A field in a table

• A value in a cell

What is the main use of a DBMS?

• To reduce data redundancy

• To eliminate inconsistency

• To enhance data security

• To provide backup and recovery

How does DBMS reduce data redundancy?

• By ensuring data is not duplicated

• By updating data automatically

• By providing data security

• By allowing concurrent access

What does DBMS do to eliminate inconsistency?

• Updates data automatically

• Reduces data redundancy

• Provides data security

• Allows concurrent access

What is the benefit of enhanced data security in DBMS?

• Protects data from unauthorized access

• Reduces data redundancy

• Eliminates inconsistency

• Allows concurrent access

What does DBMS provide in case of system failure?

• Facilities for data recovery

• Enhanced data security

• Concurrent access by multiple users

• Elimination of inconsistency