Database Management — SQL

Which SQL command is used to retrieve data from a database?

What will the following SQL query do? SELECT * FROM Students WHERE Marks >= 75;

Which SQL clause is used to sort the result-set?

Consider a table 'Employees' with columns (EmpID, Name, Salary). Which query will increase all employees' salary by 10%?

What is the result of the following SQL query? SELECT COUNT(DISTINCT City) FROM Students;

Which SQL command is used to remove a table and all its data permanently?

What does the following SQL query do? SELECT Dept, AVG(Salary) FROM Employees GROUP BY Dept HAVING AVG(Salary) > 50000;

Which of the following is TRUE about the PRIMARY KEY constraint?

In a table 'Books', which SQL query will display the second highest price of books?

What will the following SQL query return? SELECT Name FROM Students WHERE Name LIKE '_a%';