Database Systems Quiz

What does DBMS stand for?

• Database Maintenance System

• Data Base System

• Data Base Management Software

• Database Management System

Which of the following is NOT a disadvantage of file processing systems?

• Difficulty in accessing data

• Data redundancy

• Data normalization

• Data inconsistency

What is the highest level of data abstraction?

• Data level

• View level

• Logical level

• Physical level

Which of the following is a type of data model?

• Information model

• File model

• Relational model

• Data processing model

What is the role of the Query Processor?

• To manage user access

• To translate statements into low-level instructions

• To store data

• To create backups

What is a weak entity?

• An entity that can exist independently

• An entity with multiple relationships

• An entity that depends on another entity

• An entity with no attributes

What does the term 'atomicity' refer to in transaction management?

• The requirement that a transaction is all or nothing

• The ability to perform multiple transactions simultaneously

• The size of the transaction

• The speed of transaction processing

Which of the following describes a relationship in a database?

• A method of data storage

• A type of data model

• An association among entities

• A collection of data

What is the purpose of a database administrator?

• To design user interfaces

• To write application programs

• To coordinate all activities of the database system

• To perform data entry tasks