SQL Quiz

What is an index in a database schema?

• A:A way to find data in a database more quickly.

• B:A unique identifier for each row in a table.

• C:A security mechanism for restricting access to certain data.

• D:A data structure that organizes and enhances the speed of data retrieval.

Which SQL function is used to return the current date and time?

• NOW()

• GETDATE()

• CURRENT_TIMESTAMP

• DATE_FORMAT(NOW())

Which SQL keyword is used to filter the records?

• WHERE

• FIND

• FILTER

• SEARCH

What is the SQL keyword used to sort the results in ascending or descending order?

• ORDER BY

• SORT

• ARRANGE

• GROUP BY

What is the default sorting order of the "ORDER BY" clause in SQL?

• Ascending

• Descending

• Random

• Unspecified

What is the function used in SQL to convert a string to a number?

• TO_NUMBER

• CAST

• CONVERT

• PARSE

In SQL, which function is used to return a value if a condition is TRUE, and another value if it is FALSE?

• CASE

• IF

• SWITCH

• WHEN

Which SQL statement is used to create a new table in a database?

• CREATE TABLE

• ADD TABLE

• NEW TABLE

• INSERT TABLE

What is the SQL command to delete a table?

• DROP TABLE

• REMOVE TABLE

• DELETE TABLE

• DESTROY TABLE

Review the script. Determine whether or not it is erroneous or not. The goal of the script is to display all rows with Name having 'Doe" in it: SELECT * FROM Employees WHERE Name = 'Doe';

• The script is incorrect because it uses the wrong comparison operator for text matching.

• The script is correct if there is an employee with the exact name 'Doe'.

• The script is incorrect because it should use double quotes for string comparison.

• The script is incorrect because it should use the LIKE operator for partial text matching.