Q3-CPO PT

Which SQL keyword is used to filter the records?

• SORT BY

• WHERE

• ORDER BY

• GROUP BY

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

• SORT

• ORDER

• ORDER BY

• GROUP BY

Which SQL keyword is used to return records where column values fall within a specified range?

• WHERE

• BETWEEN

• LIKE

• IN

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

• Descending

• Ascending

• Random

• Random

In SQL, how do you select only distinct (different) values from a column?

• SELECT DIFFERENT column_name FROM table_name;

• SELECT DISTINCT column_name FROM table_name;

• SELECT UNIQUE column_name FROM table_name;

• SELECT column_name FROM table_name DISTINCT;

Which SQL operator is used to filter the records to include only those where the column value matches one of several specified values?

• BETWEEN

• LIKE

• IN

• OR

What SQL keyword is used to sort multiple columns?

• SORT BY

• ORDER BY

• GROUP BY

• ARRANGE BY

Display the output based on the scripts provided: SELECT * FROM Employees WHERE Salary > 90000;

• Display all columns from the Employees table where the Salary is greater than 90000.

• Display only the Salary column from the Employees table where the Salary is greater than 90000.

• Display all columns from the Employees table where the Salary is exactly 90000.

• Display an error message because the WHERE clause syntax is incorrect.

Display the output based on the scripts provided: SELECT Name, Position FROM Employees WHERE Position = 'HR' OR Position = 'Sales';

• Display all columns from the Employees table where the Position is either 'HR' or 'Sales'.

• Display only the Name and Position columns from the Employees table where the Position is either 'HR' or 'Sales'.

• Display an error message because the OR operator cannot be used in the WHERE clause.

• Display all columns from the Employees table where the Position is 'HR' and 'Sales'.

Display the output based on the scripts provided: SELECT * FROM Employees ORDER BY Salary DESC;

• Display all columns from the Employees table in ascending order of Salary.

• Display all columns from the Employees table in descending order of Salary.

• Display an error message because the ORDER BY clause cannot be used with SELECT *.

• Display all columns from the Employees table where the Salary is greater than or equal to 0.