D426 Data Management Foundations - Set 3 - 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 does the SQL keyword NULL represent?

A value of zero

A blank string

An unknown or missing value

A default value

Question 22: Which SQL statement is used to remove a column from a table?

DELETE COLUMN

REMOVE COLUMN

DROP COLUMN

ALTER COLUMN

Question 23: Which SQL operator is used to match a string against a specified pattern?

EXISTS

BETWEEN

Question 24: Which SQL function is used to return the total count of rows in a result set?

TOTAL()

COUNT()

SUM()

NUMBER()

Question 25: What is the purpose of the TRUNCATE command in SQL?

To remove a table from the database

To delete all rows from a table without removing the table structure

To drop a database

To delete specific rows based on a condition

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

ALTER TABLE ADD COLUMN

ADD COLUMN

UPDATE TABLE

MODIFY TABLE

Question 27: Which SQL clause is used to return only unique records from a query?

DISTINCT

UNIQUE

GROUP BY

HAVING

Question 28: Which SQL function returns the total sum of a numeric column?

TOTAL()

SUM()

AVG()

COUNT()

Question 29: What does a composite primary key consist of?

One column

Multiple columns

Foreign key relationships

Indexes

Question 30: Which SQL command is used to remove a table from a database?

DELETE TABLE

DROP TABLE

REMOVE TABLE

TRUNCATE TABLE

Question 31: Which SQL function is used to concatenate two strings?

CONCAT()

JOIN()

MERGE()

ADD()

Question 32: Which keyword is used in SQL to specify the condition that must be met for records to be selected?

WHERE

HAVING

ORDER BY

LIMIT

Question 33: What does the SQL keyword DEFAULT do?

Specifies a default value for a column

Removes a default value

Sets a default user

Creates a default table

Question 34: In SQL, which command is used to grant privileges to a user?

GRANT

ALLOW

PERMIT

ENABLE

Question 35: Which SQL statement is used to retrieve data from one or more tables?

SELECT

GET

FETCH

RETRIEVE

Question 36: Which SQL command is used to remove rows from a table?

DROP

REMOVE

DELETE

TRUNCATE

Question 37: Which SQL clause is used to define the table from which to retrieve data?

FROM

WHERE

SELECT

ORDER BY

Question 38: What does the term 'NULL' mean in a database?

A zero value

An unknown or missing value

A blank string

A default value

Question 39: Which SQL command is used to create an index on a table?

ADD INDEX

CREATE INDEX

NEW INDEX

DEFINE INDEX

Question 40: In SQL, which function returns the total number of rows in a result set, including NULL values?

COUNT()

SUM()

TOTAL()

ROWS()

Don't Want to Study?

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

Get Exam Support