D426 Data Management Foundations - Set 5 - Part 3

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

Question 41: Which SQL keyword is used to define a unique constraint on a column?

UNIQUE

DISTINCT

PRIMARY KEY

NOT NULL

Question 42: Which SQL command is used to modify the data type of an existing column in a table?

CHANGE COLUMN

MODIFY COLUMN

ALTER COLUMN

UPDATE COLUMN

Question 43: What does the LIKE operator do in a SQL query?

Compares two values for equality

Matches a string against a pattern

Counts rows in a result set

Sorts results in ascending order

Question 44: Which SQL function can be used to extract a substring from a string?

SUBSTRING()

EXTRACT()

MID()

SPLIT()

Question 45: Which SQL command is used to define a relationship between tables?

CREATE RELATIONSHIP

DEFINE RELATION

FOREIGN KEY

LINK TABLES

Question 46: Which SQL function would you use to return the first character of a string?

LEFT()

FIRST()

SUBSTR()

CHAR()

Question 47: Which SQL command is used to grant access to a user?

GIVE

GRANT

ALLOW

PROVIDE

Question 48: What is the primary purpose of an index in a database?

To increase redundancy

To improve query performance

To enforce data integrity

To delete records

Question 49: Which SQL command is used to remove all rows from a table without removing the table itself?

DELETE

DROP

TRUNCATE

CLEAR

Question 50: What does the SQL function ROUND() do?

Converts a value to an integer

Rounds a numeric value to a specified number of decimal places

Calculates the square root of a number

Finds the maximum value in a column

Congratulations! You have completed all 5 question sets. Good job!

Go Back to Home

Struggling With Exams?

Less Time Studying, More Time Living – Finish Your Degree Faster! Pay-After-you-Pass!

Get Exam Support