You have an address book for a small business with contact information for about 100 clients. The address book is used by two people. Which solution should you use to store the data?

• Spreadsheet
• Relational database
• Word processing software
• Nonrelational database

Answer explanation

For a small number of rows, with only two people accessing the data, a spreadsheet is fine in this situation.

A database developer is working on generating queries. If the developer needs to ensure that the output of the query has data persistence, to where should the data be written?

• RAM
• Cache
• SSD
• CPU

Answer explanation

Data persistence means that the data is permanently available. Hard drives store data in a persistent way, so the answer is SSD.

Which of the following consists of columns and rows of numerical or text data?

• Document database
• Key/Value database
• Database dump
• Relational database

Answer explanation

A relational database has structured data, which is predictable and organized, with tables containing columns and rows of text or numerical data.

Joe creates a database. What does he need to do next to make it usable?

• Enable permissions
• Import data

• Run queries
• Create forms

Answer explanation

After a database is created, data needs to be imported or inputted.

A user, Ann, is granted permissions to access a database. What is this an example of?

• Data collection
• Data manipulation
• Direct/manual access
• Data definition

Answer explanation

Permissions are considered part of data definition.

A medical office needs to create a solution to manage patient records. They have about 10,000 patients and eight staff, they want to include notes from medical professionals, emails to and from patients, and images such as X-rays. What should they create?

• Spreadsheet
• Relational database
• Nonrelational database
• Primary key

Answer explanation

With different types of data, including images, the best choice for a database is a nonrelational database such as a document database or a key/value database.

You have created a relational database. Which of the following elements uniquely identifies a record in the database?

• Primary key
• Foreign key
• Schema
• Field

Answer explanation

A primary key is one or more fields whose data is used to uniquely identify a record.

Mary, an administrator, creates a field and designates it to hold integer data. Joe, a user, tries to enter his name into the field, but it doesn’t let him save the data. What is this an example of?

• Schema rules
• Primary key
• Foreign key
• Constraints

Answer explanation

Constraints can be placed on fields such that they will accept only certain types of data. For example, if a field is set to accept only integers, users will not be allowed to enter in text data.

Rachel, a database administrator, has created a database for her website. It contains pictures of vacations that people have uploaded. In the database, pictures have associated information about who uploaded them and the date. What is this an example of?

• Semistructured data
• Nonstructured data
• Structured data
• Schema definition

Answer explanation

Pictures by themselves would be nonstructured data, but since metadata is included, these pictures are classified as semistructured data.

Peter is accessing a database using a JDBC connection. Which of the following terms best describes the type of access he is using?

• A. Direct/manual access
• B. Programmatic access
• C. User interface/utility access
• D. Query/report builder

Answer explanation

Using a JDBC connection to a database is an example of direct access.