D426 Data Management Foundations - Set 5 - 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: What is the purpose of the JOIN clause in SQL?

To remove duplicates

To combine rows from two or more tables based on a related column

To filter results from a single table

To sort the results of a query

Question 2: Which type of join returns all records from the left table and matched records from the right table?

INNER JOIN

RIGHT JOIN

LEFT JOIN

FULL JOIN

Question 3: What does the term 'Normalization' refer to in database design?

Combining multiple tables into one

Organizing data to reduce redundancy and improve data integrity

Storing data in a hierarchical format

Increasing data duplication for performance

Question 4: Which SQL function is used to compute the total number of unique values in a column?

COUNT()

SUM()

COUNT(DISTINCT)

UNIQUE()

Question 5: Which SQL command is used to remove a database from the system?

DELETE DATABASE

DROP DATABASE

REMOVE DATABASE

TRUNCATE DATABASE

Question 6: What is an Entity-Relationship Model (ERM) used for?

To store data in a database

To visualize database structures and relationships

To query data from a database

To enforce database constraints

Question 7: Which SQL keyword is used to specify a default value for a column?

DEFAULT

SET

ASSIGN

VALUE

Question 8: In SQL, which command is used to create a new view?

CREATE VIEW

NEW VIEW

DEFINE VIEW

ADD VIEW

Question 9: Which SQL function would you use to convert a string to uppercase?

UPPER()

UCASE()

CAPITALIZE()

TO_UPPER()

Question 10: What does the term 'referential integrity' refer to in databases?

The uniqueness of data in a table

The accuracy and consistency of data between related tables

The organization of data within a single table

The redundancy of data across multiple tables

Question 11: Which SQL command is used to insert new data into a table?

ADD

INSERT

PUT

NEW

Question 12: What does the SQL statement ALTER TABLE table_name DROP COLUMN column_name; do?

Deletes the entire table

Removes a specific column from the table

Renames a column

Modifies a column's data type

Question 13: Which SQL clause is used to limit the number of records returned in a query?

LIMIT

TOP

RANK

FETCH

Question 14: What does the HAVING clause do in SQL?

Filters rows before grouping

Filters groups after aggregation

Sorts the results

Joins two tables

Question 15: Which SQL function retrieves the current date and time?

CURRENT_DATE()

NOW()

GETDATE()

SYSDATE()

Question 16: What is the purpose of the ORDER BY clause in a SQL query?

To sort the result set

To filter results

To limit the number of rows

To group rows with similar values

Question 17: Which SQL command is used to delete a table from a database?

REMOVE TABLE

DELETE TABLE

DROP TABLE

TRUNCATE TABLE

Question 18: What is the purpose of the GROUP BY clause in SQL?

To filter records

To aggregate data

To sort results

To define relationships

Question 19: Which SQL function can be used to find the average of a numeric column?

AVG()

MEAN()

AVERAGE()

TOTAL()

Question 20: Which SQL statement is used to remove specific records from a table?

REMOVE

DELETE

DROP

TRUNCATE

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