D427 Data Management Applications - Set 5 - Part 2

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

Question 21: What SQL statement is used to add a new column to an existing table?

ALTER TABLE ADD COLUMN

MODIFY TABLE ADD COLUMN

INSERT COLUMN

ADD COLUMN

Question 22: Which SQL function would you use to count the number of distinct values in a column?

COUNT()

DISTINCT()

COUNT(DISTINCT)

TOTAL()

Question 23: Which SQL function is used to concatenate two or more strings?

CONCAT()

COMBINE()

JOIN()

CONCATENATE()

Question 24: Which SQL clause is used to filter records after they have been grouped?

WHERE

HAVING

GROUP BY

ORDER BY

Question 25: How do you calculate the total sum of a numeric column in SQL?

SUM()

ADD()

TOTAL()

COUNT()

Question 26: Which SQL keyword is used to ensure that a column cannot contain duplicate values?

NOT NULL

DISTINCT

UNIQUE

PRIMARY KEY

Question 27: Which SQL keyword is used to rename a column in a table?

MODIFY COLUMN

RENAME COLUMN

ALTER COLUMN

CHANGE COLUMN

Question 28: What is the result of the SQL expression SELECT 5 + 3?

Question 29: Which SQL function is used to extract a portion of a string?

SUBSTRING()

LEFT()

MID()

RIGHT()

Question 30: Which SQL function returns the length of a string?

LENGTH()

LEN()

SIZE()

COUNT()

Question 31: What does the SQL clause ORDER BY do?

Sorts rows in the result set

Filters rows based on a condition

Groups rows based on column values

Limits the number of rows returned

Question 32: Which SQL keyword is used to specify a condition that must be true for a row to be included in the result set?

WHERE

SELECT

FILTER

GROUP BY

Question 33: What SQL function would you use to return the current time?

CURRENT_TIME()

NOW()

TIME()

GETDATE()

Question 34: How do you delete rows from a table in SQL?

DELETE FROM

REMOVE FROM

DROP ROW

TRUNCATE

Question 35: What SQL clause would you use to filter rows based on a condition?

WHERE

GROUP BY

FILTER BY

LIMIT

Question 36: Which SQL function would you use to calculate the average value of a numeric column?

SUM()

AVG()

COUNT()

MEDIAN()

Question 37: Which SQL clause is used to combine rows from two or more tables?

JOIN

UNION

MERGE

COMBINE

Question 38: What does the SQL operator BETWEEN do?

Filters rows within a range of values

Combines two queries into one result set

Joins two tables based on a related column

Groups rows based on column values

Question 39: What SQL keyword is used to remove all rows from a table without removing the table itself?

DELETE

TRUNCATE

DROP

REMOVE

Question 40: What is the purpose of the SQL function LENGTH()?

Returns the length of a string

Returns the number of rows in a table

Returns the size of a table

Returns the total number of distinct values in a column

Don't Want to Study?

Save Time on Studies, Spend More with Family & Friends! Pay-After-you-Pass!

Get Exam Support