Database Management and Information Management Quiz

What is a database?

• A hardware device for storing data

• A type of software for managing emails

• A collection of unrelated files

• A collection of related files containing records

What does DBMS stand for?

• Data Base Management System

• Database Management Service

• Database Management Software

• Data Management Base System

Which of the following is a disadvantage of DBMS?

• Improved data integrity

• Complexity

• Increased productivity

• Control of data redundancy

What is a primary key in a relational database?

• A key used for encryption

• A key that can be duplicated

• A key that uniquely identifies each record

• A key that stores multiple values

Which operation creates a subset of all records meeting stated criteria?

• Join

• Select

• Project

• Update

What is the purpose of a data dictionary?

• To store user passwords

• To create backup copies of data

• To document definitions of data elements

• To manage user access

What type of database is designed to handle large data sets that are not easily organized into tables?

• Cloud Database

• Relational Database

• Distributed Database

• NoSQL Database

Which of the following is an example of a relational database management system?

• MongoDB

• MySQL

• Amazon S3

• Hadoop

What does the term 'data redundancy' refer to?

• Storing data in multiple formats

• The use of outdated data

• Duplicating the same data in different programs

• The loss of data during processing

Which of the following is NOT a capability of a DBMS?

• Data manipulation language

• Data encryption

• Querying and reporting

• Data definition capabilities