Question

Question 1
A data analyst at a logistics company is tasked with analyzing routes and transit times for all orders. The current database of orders contains millions of rows. What tool would be most efficient for the analyst to use?



SQL



Word processor



CSV



Spreadsheet


1 point
2.
Question 2
A data analyst discovers that their database has recognized product price data as text strings. What SQL function can the analyst use to convert the text strings to floats?



SUBSTR



TRIM



CAST



LENGTH


1 point
3.
Question 3
Fill in the blank: A junior data analyst in the engineering department uses the SQL command _____ to add a new row of product specification data to their organization’s database.



INSERT INTO



CREATE TABLE IF NOT EXISTS



DROP TABLE IF EXISTS



UPDATE


1 point
4.
Question 4
You are working with a database table that has columns about products, such as product_name. Which SUBSTR function and AS command will retrieve the first 2 characters of each product name and store the result in a new column called product_ID?



SUBSTR(product_name, 1, 2) AS product_ID



SUBSTR AS (1, 2 product_name) product_ID



SUBSTR(product_name, 2) AS product_ID



SUBSTR(product_name) AS (1, 2) product_ID


1 point
5.
Question 5
In SQL, what function can be used to remove leading spaces from a piece of data?



SUBSTR



TRIM



FORMAT



AVG


1 point
6.
Question 6
While working with a database table that contains the column employee_name, you notice that there are some duplicate entries. Which SQL clause would you use in a query to return the employee_name data without these duplicates?


DROP employee_name



DISTINCT employee_name



DUPLICATE employee_name



DELETE employee_name


1 point
7.
Question 7
Fill in the blank: The SQL command _____ is irreversible, so data analysts should consider whether data should be backed up before using it.


INSERT INTO



DROP TABLE IF EXISTS



CREATE TABLE IF NOT EXISTS



UPDATE


1 point
8.
Question 8
You are using a database table that includes the column user_password, and you want to make sure all passwords are aligned to company protocols. Which SQL clause will help you confirm that the passwords are 15 characters long?


IDENTIFY(user_password) = 15



WHERE(user_password) < 15



COUNT(user_password) > 15



LENGTH(user_password) = 15


1 point
9.
Question 9
As you migrate data from a legacy system to a new database, you find that many client records contain missing values in the email_address column. What SQL function can you use to replace these null values with a value in a different column?


CAST



COALESCE



TRIM



CONCAT


1 point

Answer 1

1. SQL

2. CAST

3. INSERT INTO

4. SUBSTR(product_name, 1, 2) AS product_ID

5. TRIM

6. DISTINCT employee_name

7. DROP TABLE IF EXISTS

8. LENGTH(user_password) = 15

9. COALESCE