D427 Data Management Applications - Set 4 - 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 keyword is used to ensure that a column cannot contain NULL values?

NOT NULL

UNIQUE

NO NULLS

VALID

Question 22: Which SQL keyword is used to ensure that all values in a column are unique?

UNIQUE

DISTINCT

DIFFERENT

CHECK

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

RENAME TABLE

ALTER TABLE RENAME TO

MODIFY TABLE

RENAME

Question 24: What is the result of the SQL expression: SELECT 15 % 4?

Question 25: Which SQL function is used to return the absolute value of a number?

ABS()

ROUND()

CEILING()

FLOOR()

Question 26: Which SQL clause is used to sort the result set?

ORDER BY

SORT BY

GROUP BY

FILTER BY

Question 27: What SQL function would you use to return the smallest integer greater than or equal to a given number?

CEILING()

FLOOR()

ROUND()

ABS()

Question 28: How do you select rows where a column value does not match a specified pattern in SQL?

WHERE column NOT LIKE pattern

WHERE column != pattern

WHERE column EXCLUDES pattern

WHERE column NOT EQUALS pattern

Question 29: Which SQL function is used to round a number to a specified number of decimal places?

ROUND()

FLOOR()

CEILING()

TRUNC()

Question 30: What is the purpose of the SQL NVL() function?

It replaces NULL values with a specified value

It checks if a column contains NULL values

It converts a string to a number

It returns the largest value in a column

Question 31: Which SQL clause is used to join two or more tables based on a related column?

JOIN

UNION

MERGE

COMBINE

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

WHERE

SELECT

FILTER

ORDER BY

Question 33: What SQL function would you use to return the length of a string?

LENGTH()

LEN()

SIZE()

COUNT()

Question 34: What does the SQL HAVING clause do?

It filters groups after they have been formed

It filters rows before they are grouped

It sorts the result set

It combines the results of two queries

Question 35: Which SQL keyword is used to select only rows where a column contains a specific value?

EQUALS

WHERE

Question 36: What SQL function would you use to return the current date?

CURDATE()

NOW()

CURRENT_DATE()

TODAY()

Question 37: Which SQL statement is used to change the structure of an existing table?

ALTER TABLE

MODIFY TABLE

CHANGE TABLE

UPDATE TABLE

Question 38: What SQL clause would you use to remove duplicate rows from a result set?

DISTINCT

UNIQUE

REMOVE

DELETE

Question 39: Which SQL function is used to calculate the sum of a numeric column?

TOTAL()

SUM()

ADD()

COUNT()

Question 40: How do you remove a table from a database in SQL?

DROP TABLE

DELETE TABLE

REMOVE TABLE

TRUNCATE TABLE

Don't Want to Study?

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

Get Exam Support