A business wants to set up a database to store customer and order information. They have decided to use a relational database. Which of the following is the main benefit of using a relational database?

The data can be organized into separate tables that are related to each other.

The data can be saved as a flat file.

The data is stored as a single file for quick retrieval.

The data can be stored as unstructured data.

Marty, a database administrator, has added a foreign key to a table in a database. Which of the following describes the purpose of a foreign key?

For one table to reference records in another table.

For one database to reference another database.

To allow the storage of unstructured data.

To provide a way to distinguish records within a table.

Patricia, a database system manager for a large hotel chain, is setting up a relational database to track customer hotel registrations for each hotel. The table in the database currently includes fields (columns) for First Name, Last Name, Phone, Email, License Plate #, and Check-in Date. What can Patricia do to make sure that each record (row) in the database is unique?

Create an additional Check-in ID field.

Designate the Phone field as the primary key.

Combine the Email field and the Phone field to use as the primary key.

Designate the License Plate # field as the primary key.

Mary needs to view the records from the Clients table that pertain to Travis. Which command should she use?

SELECT * FROM Clients WHERE name = Travis

UPDATE * FROM Clients WHERE name = Travis

SELECT ^ FROM Clients WHERE name = Travis

April is a database manager who wants to insert some new records (rows) into the company's customer contact database. Instead of using a database client to insert the records, she wants to use a command. Which of the following languages provides a command for inserting records into a database?

DML (Data Manipulation Language)

HTML (HyperText Markup Language)

IT Fundamentals Chapter 7

Quiz

•

Information Technology (IT)

•

Professional Development

•

Practice Problem

•

Hard

Danielle Mack

FREE Resource

Student preview

45 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

Which of the following is a way for programmers and others to make sense of complex business flows?

Microsoft Access

Data modeling

Database management system

Primary keys

2.

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

Which of the following is found in one or more columns of data and contains a unique identifier for the row?

Relationship

Primary key

Attribute

Foreign key

3.

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

Which data model focuses on high-level concepts?

Conceptual

Physical

Operational

Logical

4.

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

Which data type uses historical data to make decisions in the present?

Analytical

Conceptual

Operational

Logical

5.

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

Which type of analytical data can help you make investment decisions?

Machine

Sensor

Transactional

Market

6.

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

What is the general term for software that creates and manages databases?

MySQL

DBMS

Tables

Microsoft Access

7.

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

Which database object is essentially questions that we can ask the database?

Forms

Queries

Tables

Reports

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever

or continue with

Microsoft

Apple

Others

Already have an account?

Popular Resources on Wayground

15 questions

Fractions on a Number Line

Quiz

•

3rd Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

54 questions

Analyzing Line Graphs & Tables

Quiz

•

4th Grade

$fractions$

22 questions

fractions

Quiz

•

3rd Grade

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

15 questions

Equivalent Fractions

Quiz

•

4th Grade

Discover more resources for Information Technology (IT)

20 questions

Black History Month Trivia Game #1

Quiz

•

Professional Development

100 questions

Screening Test Customer Service

Quiz

•

Professional Development

20 questions

90s Cartoons

Quiz

•

Professional Development

10 questions

Reading a ruler in Inches

Quiz

•

4th Grade - Professio...

16 questions

Parallel, Perpendicular, and Intersecting Lines

Quiz

•

KG - Professional Dev...

12 questions

Valentines Day Trivia

Quiz

•

Professional Development

IT Fundamentals Chapter 7

45 questions

Which of the following is a way for programmers and others to make sense of complex business flows?

Which of the following is found in one or more columns of data and contains a unique identifier for the row?

Which data model focuses on high-level concepts?

Which data type uses historical data to make decisions in the present?

Which type of analytical data can help you make investment decisions?

What is the general term for software that creates and manages databases?

Which database object is essentially questions that we can ask the database?

Which of the following makes it easier for users to enter data into their tables?

Which of the following DBMS programs is open source?

Which of the following database objects provides a summary of data?

Access all questions and much more by creating a free account

Popular Resources on Wayground

Discover more resources for Information Technology (IT)