d427 Data Management Applications - Set 3 - 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 statement is used to remove all rows from a table without removing the table structure?

DELETE

DROP

TRUNCATE

REMOVE

Question 2: What is the default value for a column if no value is provided and no default is set?

NULL

'' (empty string)

-1

Question 3: Which SQL statement would you use to add a new column to an existing table?

INSERT COLUMN

MODIFY TABLE

ALTER TABLE ADD COLUMN

UPDATE TABLE

Question 4: Which SQL function is used to convert a string to uppercase?

UPPER()

TOUPPER()

CAPITALIZE()

CAPS()

Question 5: How do you rename an existing table in SQL?

MODIFY TABLE

ALTER TABLE RENAME

RENAME TABLE

CHANGE TABLE NAME

Question 6: Which SQL statement is used to combine rows from two or more tables based on a related column between them?

UNION

JOIN

LINK

MERGE

Question 7: What does the SQL clause LIMIT do?

Limits the number of columns returned

Limits the number of rows returned

Limits the size of the result set

Limits the execution time of a query

Question 8: How do you check if a column contains a NULL value in SQL?

WHERE column IS NULL

WHERE column = NULL

WHERE column == NULL

WHERE column IS EMPTY

Question 9: Which SQL function returns the number of characters in a string?

SIZE()

LEN()

LENGTH()

CHAR_COUNT()

Question 10: What is the result of the following expression: SELECT 7 % 3?

Question 11: How do you select the unique values from a column in SQL?

SELECT UNIQUE

SELECT DISTINCT

SELECT NO DUPLICATES

SELECT ONLY UNIQUE

Question 12: Which SQL clause is used to sort the result set in ascending or descending order?

ORDER BY

SORT BY

ARRANGE BY

FILTER BY

Question 13: What is the default sorting order for the ORDER BY clause?

Descending

Ascending

No default, order must be specified

Random

Question 14: Which SQL keyword is used to combine the results of two queries into a single result set?

JOIN

UNION

MERGE

COMBINE

Question 15: How do you select all columns from a table in SQL?

SELECT *

SELECT ALL

SELECT COLUMNS

SELECT *

Question 16: Which SQL statement is used to delete a table from a database?

DELETE TABLE

DROP TABLE

REMOVE TABLE

ERASE TABLE

Question 17: What does the SQL WHERE clause do?

Filters rows based on a condition

Joins tables based on a condition

Specifies columns to display

Sorts rows in ascending order

Question 18: Which SQL function returns the sum of all values in a numeric column?

ADD()

SUM()

TOTAL()

COUNT()

Question 19: Which SQL keyword is used to remove duplicates in a result set?

DISTINCT

UNIQUE

EXCLUDE

LIMIT

Question 20: How do you rename a column in SQL?

ALTER COLUMN RENAME

MODIFY COLUMN

RENAME COLUMN

ALTER TABLE RENAME COLUMN

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