DBMS Quiz

What does DBMS stand for?

• Database Management Software

• Data Management Base System

• Data Base Management System

• Database Base Management System

Which of the following is NOT a characteristic of a modern DBMS?

• Less redundancy

• ACID Properties

• Multi-user and Concurrent Access

• Data Redundancy

What is the purpose of normalization in a DBMS?

• To improve data retrieval speed

• To enhance data security

• To increase data redundancy

• To reduce data redundancy

Which property is NOT part of the ACID properties?

• Accessibility

• Consistency

• Isolation

• Atomicity

What role do administrators play in a DBMS?

• Create database queries

• Design the database structure

• Maintain the DBMS and manage user access

• Analyze business data

What is meant by 'multiple views' in a DBMS?

• Different users can see the same data

• Users can have customized views of the database

• Only administrators can access the database

• Data is stored in multiple formats

What does the term 'metadata' refer to in a DBMS?

• Data that is archived

• Data that is redundant

• Data that is encrypted

• Data about data

Which of the following best describes a database?

• An organized collection of related data

• A temporary storage space

• A collection of unrelated data

• A single data file

What is the main function of a query language in a DBMS?

• To design database schemas

• To store data securely

• To retrieve and manipulate data

• To create new databases

Who are end users in the context of a DBMS?

• Those who maintain the database

• Those who design the database

• Those who develop the DBMS software

• Those who benefit from the database