Database Systems Quiz

What is a DBMS?

• A hardware component

• A programming language

• A type of database

• A software system for managing databases

Which of the following is a limitation of file-based systems?

• Data independence

• Data duplication

• Controlled access

• Improved security

What does DDL stand for?

• Data Development Language

• Data Definition Language

• Data Design Language

• Data Distribution Language

Which of the following is NOT a component of the DBMS environment?

• Data Administrator

• Database Administrator

• Network Engineer

• Application Programmers

What is one advantage of using a DBMS?

• Higher costs

• Improved data integrity

• Increased data redundancy

• More complex systems

What is a view in the context of databases?

• A method of data encryption

• A type of database management system

• A subset of the database for a user

• A physical representation of data

Which generation of database systems is characterized by relational databases?

• Fourth generation

• Third generation

• Second generation

• First generation

What is one disadvantage of DBMSs?

• Higher impact of a failure

• Reduced complexity

• Improved data accessibility

• Lower costs

What is the primary purpose of a Data Manipulation Language (DML)?

• To define data types

• To manipulate and query data

• To manage user access

• To create database structures

Which of the following is a common application of databases?

• Watching movies

• Purchasing from a supermarket

• Listening to music

• Playing video games