D468 Discovering Data - Set 4 - Part 1

Test your knowledge of technical writing concepts with these practice questions. Each question includes detailed explanations to help you understand the correct answers.

Question 1: Which SQL clause is used to sort data in descending order?

ORDER BY ASC

ORDER BY DESC

WHERE DESC

GROUP BY DESC

Question 2: What does the AVG function in SQL calculate?

The total sum of values

The average of a set of values

The highest value

The count of non-null values

Question 3: Which term describes breaking data down into smaller parts to better understand and analyze it?

Aggregation

Decomposition

Summarization

Normalization

Question 4: Which SQL statement is used to add new records to a table?

SELECT

UPDATE

INSERT

DELETE

Question 5: What is the role of the SELECT statement in SQL?

To delete rows from a table

To retrieve data from a database

To modify existing records

To create a new table

Question 6: In data analysis, what does "categorizing things" refer to?

Organizing data into distinct groups

Predicting future outcomes

Identifying outliers in a dataset

Summarizing trends

Question 7: What is the role of the HAVING clause in SQL?

To filter individual rows

To filter groups of rows

To join tables

To delete records

Question 8: Which SQL function returns the number of rows that match a specified condition?

SUM

COUNT

AVG

MAX

Question 9: In the data analysis process, which phase involves gathering feedback and adjusting the strategy based on insights?

Act

Process

Prepare

Question 10: Which type of database relationship is established when a foreign key links two tables?

One-to-many

Many-to-many

One-to-one

Self-join

Question 11: What is the purpose of using the MAX function in SQL?

To find the minimum value

To count the number of rows

To find the largest value

To calculate the average

Question 12: Which data analysis problem type involves determining patterns in historical data?

Categorizing things

Spotting something unusual

Finding patterns

Making predictions

Question 13: In SQL, which keyword is used to ensure that only unique values are returned in a query result?

DISTINCT

UNION

COUNT

AVG

Question 14: What does the "M" in SMART goals stand for?

Measurable

Meaningful

Manageable

Motivating

Question 15: Which SQL operator is used to filter data based on a range of values?

BETWEEN

Question 16: In the data analysis process, which phase focuses on collecting raw data from various sources?

Capture

Plan

Analyze

Question 17: What is the purpose of the UPDATE statement in SQL?

To delete rows from a table

To modify existing data in a table

To insert new rows into a table

To retrieve data from a table

Question 18: What is the purpose of using pivot tables in data analysis?

To create complex queries

To sort and filter data

To summarize and analyze large datasets

To store historical data

Question 19: Which SQL keyword is used to combine the result sets of two SELECT queries?

JOIN

UNION

INTERSECT

EXCEPT

Question 20: What does the COUNT function in SQL return?

The sum of values

The number of non-null values

The highest value in a column

The total number of rows

Need Guaranteed Results?

Our exam support service guarantees you'll pass your OA on the first attempt. Pay only after you pass!

Get Exam Support