d427 Data Management Applications - Set 2 - Part 1

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

Question 1: Which SQL function is used to retrieve the length of a string?

LENGTH()

SIZE()

CHAR_COUNT()

COUNT()

Question 2: How do you write a SQL statement to update the value of the "Name" column to 'John' where the "ID" is 100?

CHANGE Name TO 'John' WHERE ID = 100

UPDATE Employees SET Name = 'John' WHERE ID = 100

MODIFY Name = 'John' WHEN ID = 100

SET Name 'John' WHERE ID = 100

Question 3: Which SQL statement is used to remove an existing column from a table?

REMOVE COLUMN

DELETE COLUMN

ALTER TABLE DROP COLUMN

DROP FIELD

Question 4: What SQL operator is used to select rows that match a specified pattern?

MATCH

PATTERN

Question 5: Which SQL keyword is used to select records based on a range of values?

BETWEEN

LIMIT

RANGE

FROM

Question 6: What does the SQL keyword IS NULL do?

It checks if a value is blank

It checks if a value is equal to zero

It checks if a value is NULL

It replaces NULL values

Question 7: Which SQL function returns the first non-NULL value from a set of arguments?

IFNULL()

COALESCE()

NULLIF()

NVL()

Question 8: Which SQL statement is used to delete all data from a table but not the table itself?

DELETE ALL

REMOVE DATA

TRUNCATE TABLE

DROP TABLE

Question 9: How do you limit the number of rows returned by a query to 10 in MySQL?

SELECT TOP 10

SELECT * FROM table LIMIT 10

SELECT * FROM table MAX 10

SELECT * FROM table WHERE ROWNUM <= 10

Question 10: Which SQL clause is used to filter the result set after grouping?

WHERE

GROUP BY

HAVING

ORDER BY

Question 11: 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 12: Which SQL function is used to find the minimum value in a column?

LEAST()

MIN()

SMALL()

LOWER()

Question 13: Which SQL function is used to return the current time?

CURRENT_TIME()

GETTIME()

NOW()

TIME()

Question 14: What does the SQL statement DROP INDEX do?

It removes a column from an index

It removes an index from a table

It deletes rows in a table

It renames an index

Question 15: Which SQL function is used to round a numeric value to the nearest whole number?

ROUND()

CEILING()

FLOOR()

TRUNCATE()

Question 16: How do you select all rows where the value of the "Salary" column is greater than 5000?

SELECT * FROM Employees WHERE Salary >= 5000

SELECT * FROM Employees WHERE Salary > 5000

SELECT ALL FROM Employees WHERE Salary > 5000

SELECT * FROM Employees WHERE Salary == 5000

Question 17: What SQL clause is used to filter rows based on a specific condition?

HAVING

WHERE

FILTER

GROUP BY

Question 18: Which SQL clause is used to order the result set in ascending or descending order?

SORT BY

ORDER BY

ARRANGE

ALIGN

Question 19: Which SQL function is used to return the largest value in a column?

MAX()

GREATEST()

BIGGEST()

LARGE()

Question 20: How do you remove duplicates from the result set in a SELECT query?

SELECT DISTINCT

SELECT UNIQUE

SELECT EXCEPT DUPLICATES

SELECT NO DUPLICATES

Need Guaranteed Results?

Our exam support service guarantees you'll pass your OA on the first attempt. Pay only after you pass!

Get Exam Support