D427 Data Management Applications - Set 2 - 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: Which SQL clause is used to group rows that have the same values?

GROUP BY

ORDER BY

HAVING

CLUSTER BY

Question 22: How do you retrieve the total number of rows in a table?

SELECT COUNT(*) FROM table

SELECT TOTAL ROWS FROM table

SELECT ROW_COUNT FROM table

SELECT NUMBER FROM table

Question 23: Which SQL operator is used to test for inequality?

BOTH A AND C

Question 24: What SQL function is used to remove leading and trailing spaces from a string?

STRIP()

TRIM()

LTRIM()

RTRIM()

Question 25: Which SQL keyword is used to limit the number of rows returned by a query in SQL Server?

LIMIT

TOP

MAX

RESTRICT

Question 26: What is the purpose of the SQL INNER JOIN clause?

It returns all records from both tables

It returns records where there is a match between tables

It returns records from the left table only

It returns records from the right table only

Question 27: Which SQL function is used to return a portion of a string starting at a specific position?

PART()

SUBSTRING()

SPLIT()

SLICE()

Question 28: Which SQL clause is used to filter records after the GROUP BY clause has been applied?

WHERE

FILTER

HAVING

ORDER BY

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

REMOVE TABLE

DELETE TABLE

DROP TABLE

ERASE TABLE

Question 30: What does the SQL function COUNT() return?

The sum of a column

The number of rows

The maximum value in a column

The length of a string

Question 31: Which SQL function returns the current date and time?

NOW()

TODAY()

CURRENT_DATE()

DATE()

Question 32: What is the SQL clause used to specify the conditions for joining two tables?

WHERE

USING

JOIN

Question 33: What does the SQL statement ALTER TABLE do?

It changes the structure of an existing table

It renames a table

It deletes a table

It adds data to a table

Question 34: Which SQL keyword is used to return only distinct values in a SELECT query?

DISTINCT

DIFFERENT

UNIQUE

NONE

Question 35: Which SQL function is used to return the average value of a column?

AVG()

MEAN()

MEDIAN()

SUM()

Question 36: How do you retrieve all rows where a column value is greater than or equal to 1000?

WHERE Column > 1000

WHERE Column >= 1000

WHERE Column = 1000

WHERE Column LESS THAN 1000

Question 37: Which SQL keyword is used to retrieve data from a database table?

GET

FETCH

SELECT

RETRIEVE

Question 38: What is the SQL clause used to specify the number of rows to return in SQL Server?

LIMIT

TOP

MAX

RESTRICT

Question 39: Which SQL keyword is used to combine rows from two tables based on a related column?

MERGE

JOIN

LINK

MATCH

Question 40: What SQL operator is used to test if two values are equal?

EQUALS

COMPARE

Don't Want to Study?

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

Get Exam Support