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