D427 Data Management Applications - Set 1 - 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 of the following SQL keywords is used to ensure that a column does not accept NULL values?

DEFAULT

NOT NULL

UNIQUE

PRIMARY KEY

Question 22: What SQL command is used to delete a database?

REMOVE DATABASE

DELETE DATABASE

DROP DATABASE

CLEAR DATABASE

Question 23: What is the purpose of the SQL JOIN clause?

To insert data from one table into another

To retrieve data from multiple tables

To delete data from multiple tables

To update data across multiple tables

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

ADD()

TOTAL()

SUM()

AGGREGATE()

Question 25: Which SQL statement is used to add a new column to an existing table?

ADD COLUMN

ALTER COLUMN

ALTER TABLE

MODIFY COLUMN

Question 26: Which SQL statement is used to delete a specific column from a table?

REMOVE COLUMN

ALTER TABLE DROP COLUMN

DROP COLUMN

DELETE COLUMN

Question 27: What is the function of the SQL operator BETWEEN?

Filters rows between two dates

Filters rows between two values

Filters rows between two columns

Filters rows between two tables

Question 28: What SQL keyword is used to select records where two values match?

COMPARE

MATCH

EQUAL

Question 29: How do you select records where a column value starts with 'A'?

WHERE Column STARTS WITH 'A'

WHERE Column LIKE 'A%'

WHERE Column = 'A'

WHERE Column BEGINS 'A'

Question 30: Which of the following constraints ensures that the value in a column is unique?

NOT NULL

PRIMARY KEY

UNIQUE

CHECK

Question 31: Which SQL statement is used to retrieve data from a database?

RETRIEVE

GET

SELECT

FETCH

Question 32: What does the SQL clause FROM specify in a query?

Specifies the table to retrieve data from

Specifies the table to delete data from

Specifies the table to update data in

Specifies the table to drop

Question 33: Which of the following operators tests for the existence of rows in a subquery?

EXISTS

BETWEEN

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

DISTINCT

DIFFERENT

UNIQUE

NONE

Question 35: What does the SQL clause ORDER BY do in a query?

Orders data in a specific sequence

Orders data in reverse

Orders data by the first column

Orders data by index

Question 36: What SQL command is used to add data to a table?

ADD TO

INSERT INTO

CREATE DATA

INCLUDE INTO

Question 37: Which SQL function returns the average value of a numeric column?

AVG()

MEAN()

MEDIAN()

SUM()

Question 38: Which SQL operator is used to compare two values for equality?

COMPARE

Question 39: What is the default sorting order when using ORDER BY in a query?

Ascending

Descending

Random

None

Question 40: Which SQL operator is used to exclude rows that do not meet a condition?

FILTER

NOT

EXCEPT

OMIT

Don't Want to Study?

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

Get Exam Support