-
Question of
What does SQL stand for?
-
Structured Language
-
Sequential Query Language
-
Structured Query Language
-
Systematic Query Language
Correct Wrong
Explanation: SQL stands for Structured Query Language, and it is a domain-specific language used for managing and manipulating relational databases.
-
-
Question of
Which SQL clause is used to filter the results of a query?
-
GROUP BY
-
ORDER BY
-
WHERE
-
HAVING
Correct Wrong
Explanation: The WHERE clause is used to filter the results of a query based on a specified condition.
-
-
Question of
Which SQL command is used to retrieve all the columns from a table named “employees”?
-
SELECT * FROM employees;
-
SHOW COLUMNS FROM employees;
-
DESCRIBE employees;
-
SELECT ALL FROM employees;
Correct Wrong
Explanation: The SELECT statement is used to retrieve data from a database. The asterisk (*) is used to select all columns, and "employees" is the name of the table.
-
-
Question of
In SQL, which data type is used to store a date?
-
VARCHAR
-
DATE
-
INT
-
FLOAT
Correct Wrong
Explanation: The DATE data type in SQL is used to store date values.
-
-
Question of
What is the purpose of the SQL JOIN clause?
-
To combine rows from different tables based on a related column between them
-
To filter rows based on a specified condition.
-
To sort the result set in ascending or descending order.
-
To group rows that have the same values in specified columns.
Correct Wrong
Explanation: The JOIN clause is used to combine rows from two or more tables based on a related column.
-
-
Question of
Which SQL statement is used to update data in a table?
-
ALTER
-
UPDATE
-
MODIFY
-
CHANGE
Correct Wrong
Explanation: The UPDATE statement is used to modify existing records in a table.
-
-
Question of
What is the function of the SQL GROUP BY clause?
-
To filter rows based on a specified condition.
-
To join tables based on a related column.
-
To group rows that have the same values in specified columns.
-
To sort the result set in ascending or descending order.
Correct Wrong
Explanation: The GROUP BY clause is used to group rows based on the values in specified columns.
-
-
Question of
Which SQL command is used to remove a table from the database?
-
REMOVE TABLE table_name;
-
DROP TABLE table_name;
-
DELETE TABLE table_name;
-
REMOVE FROM table_name;
Correct Wrong
Explanation: The DROP TABLE statement is used to remove a table from the database.
-
-
Question of
Which of the following is not a valid SQL aggregate function?
-
COUNT
-
AVG
-
TOTAL
-
SUM
Correct Wrong
Explanation: The ORDER BY clause is used to sort the result set in ascending or descending order based on one or more columns.
-
-
Question of
In SQL, what is the purpose of the ORDER BY clause?
-
To filter rows based on a specified condition.
-
To join tables based on a related column.
-
To sort the result set in ascending or descending order.
-
To group rows that have the same values in specified columns.
Correct Wrong
Explanation: The correct aggregate function is SUM, not TOTAL. SQL aggregate functions include COUNT, AVG, SUM, and others for performing operations on sets of values. "TOTAL" is not a recognized aggregate function in standard SQL.
-