You are preparing to analyze some sales data and have a large amount of information in an Excel spreadsheet. You have decided to convert the Excel spreadsheet to a relational database. What is your first step?

$1$ point

Get the data into the database.

Clean and split the data into load files.

Create the physical database objects.

Create a logical and physical database design.

$2.$

Question $2$

What is a referential constraint?

$1$ point

This occurs when one table can$$t find a matching entry in another table.

This occurs when there is a one$-$to$-$many relationship between tables.

This occurs when there is a many$-$to$-$many relationship between tables.

This occurs when there is a primary key$/$foreign key relationship between two tables.

$3.$

Question $3$

What is a common tool or language used to clean and split data into load files?

$1$ point

Excel

Java

Python

SQL

$4.$

Question $4$

Why is the SQL LOAD command recommended over the IMPORT command for large amounts of data?

$1$ point

The LOAD command performs SQL INSERT statements for a group of rows and commits them periodically, saving transaction process time.

The LOAD command is not recommended for large amounts of data. IMPORT is a much better choice.

The LOAD command bypasses the database transactional logging mechanism, making it fast and efficient.

The LOAD command uses transactional logging$,$ making it fast and efficient.

$5.$

Question $5$

Which type of plots are specifically employed to visualize the median and distribution, both within a category and across categories?

$1$ point

Scatter plots

Pie charts

Line graphs

Boxplots