Welcome to your sql mcq- Select Statement
Which query selects both name and salary from the employees table?
Which query correctly creates the alias emp_name for the name column?
Which query correctly selects all columns from the employees table?
Which of the following is a valid SQL query?
Can a SELECT statement perform arithmetic calculations?
What will the following query return?
SELECT DISTINCT department
FROM employees;
Which query correctly returns the employee name and salary increased by 10%?
Which SQL statement is used to retrieve data from a table?
Which keyword is commonly used to give a temporary name to a column?
Which SQL keyword is used to remove duplicate values from the result?
What does the * symbol mean in a SELECT statement?
Which query selects only the name column from the employees table?
Which SQL statement correctly selects multiple columns from a table?
What will the following query return?
SELECT salary * 12
FROM employees;
What is the purpose of a column alias in SQL?
