MySQL SQL Queries

What is the SQL keyword used to retrieve data from a database?

• FETCH

• RETRIEVE

• SELECT

• SEARCH

How do you select all columns from a table named 'users'?

• SELECT ALL FROM users;

• SELECT columns FROM users;

• SELECT users.*;

• SELECT * FROM users;

What is the SQL query to filter records where the 'age' column is greater than 18?

• SELECT * FROM table_name WHERE age > 18;

• SELECT * FROM table_name WHERE age = 18;

• SELECT * FROM table_name WHERE age < 18;

• SELECT * FROM table_name WHERE age >= 18;

By default, ORDER BY clause lists the results in _______________ order

• Descending

• Any

• Same

• Ascending

Consider the following query

select * from employee order by salary _________, name ________;

To display the salary from greater to smaller and name in alphabetical order which of the following options should be used?

• Ascending, Descending

• Asc, Desc

• Desc, Asc

• Descending, Ascending

select correct SQL query from below to find the temperature in increasing order of all cities.

• select city from weather order by temperature;

• select city, temperature from weather;

• select city, temperature from weather order by temperature;

• select city, temperature from weather order by city;

Which SQL function is used to count the number of rows in a SQL query?

• count( )

• number( )

• sum( )

• count(*)

Which of the following is not an aggregate function?

• avg

• sum

• with

• min

How do you delete a record from a table in SQL?

• DROP FROM table_name WHERE condition;

• REMOVE FROM table_name WHERE condition;

• DELETE * FROM table_name WHERE condition;

• DELETE FROM table_name WHERE condition;

What is the purpose of the ORDER BY clause in SQL?

• To update multiple columns simultaneously

• To delete data from the table

• To sort the result set based on specified column(s) in ascending or descending order.

• To create a new table