Database Concepts Quiz

What is a database?

• A collection of unorganized information.

• A structured collection of information stored for easier access.

• A random assortment of data.

• A type of software used for creating websites.

In a database, what does each row represent?

• A single field within a record.

• A separate record in the database.

• A table of information.

• A column of data.

Which of the following is NOT a process involved in database usage?

• Creation

• Import/input

• Storage (data persistence)

• Deletion

What is the purpose of a query in a database?

• To store data persistently and securely.

• To format and summarize records.

• To specify criteria to match values in fields and display selected information.

• To create new tables of information.

What is the role of reports in a database?

• To create new records.

• To format and summarize records returned by a query.

• To store data temporarily.

• To delete unnecessary data.

What is an example of a flat file data storage and access system?

• Database

• Spreadsheet

• Cloud Storage

• Data Warehouse

What does a Comma Separated Values (CSV) file use to identify the end of a column?

• Semicolons

• Tabs

• Commas

• Spaces

Which of the following is NOT a drawback of flat file systems compared to database systems?

• Limited data types for each column

• Inability to manage multiple tables

• High scalability

• Limited support for concurrent users

Which of the following is a benefit of using databases over flat file systems?

• Databases can enforce data types for each column

• Databases are less complex

• Databases are cheaper to maintain

• Databases are easier to create

What does scalability in databases mean?

• Reducing the number of users

• Increasing costs at the same rate as usage

• Expanding usage without increasing costs at the same rate

• Limiting the capacity of the system