SQL in Databases

Which SQL clause is used to choose which columns to show in the result?

• SELECT

• FROM

• WHERE

• ORDER BY

What does the FROM clause specify in an SQL query?

• The columns to display

• The table to get data from

• The order of the results

• The condition to filter rows

Which SQL statement will show all columns from a table named `Students`?

• SELECT * FROM Students;

• SHOW ALL FROM Students;

• GET * FROM Students;

• SELECT ALL Students;

How do you select only the "Name" and "Age" columns from a table called `Kids`?

• SELECT Name, Age FROM Kids;

• SELECT Kids FROM Name, Age;

• FROM Kids SELECT Name, Age;

• SELECT Name AND Age FROM Kids;

What does the query SELECT * FROM EMPLOYEES WHERE LOCATION = "PAOLA" or "COSPICUA"; output?

• All fields of those employees who reside in Paola only

• All fields of those employees who reside in Paola or Cospicua only

• Only the names of those employees who reside in Paola or Cospicua

• All fields of those employees who do not reside in Paola or Cospicua

What does this SQL query do? `SELECT * FROM Books WHERE Author = 'J.K. Rowling';`

• Shows all books by J.K. Rowling

• Shows only the Author column

• Shows all authors except J.K. Rowling

• Shows all books in the library

Which SQL query will show all students who are 10 years old from the `Students` table?

• SELECT * FROM Students WHERE Age = 10;

• SELECT Age = 10 FROM Students;

• SELECT * FROM Students ORDER BY Age = 10;

• SELECT 10 FROM Students;

What does the ORDER BY clause do in an SQL query?

• Filters the rows

• Sorts the results

• Selects the table

• Deletes rows

How do you sort the results by the "Score" column in descending order?

• ORDER BY Score DESC

• ORDER Score BY DESC

• SORT BY Score DESC

• ORDER Score DESC BY

Which SQL query will show the names of all students from the `Students` table, sorted alphabetically?

• SELECT Name FROM Students ORDER BY Name ASC;

• SELECT Name FROM Students WHERE Name ASC;

• SELECT Name ORDER BY Students ASC;

• SELECT Name FROM Students SORT BY Name;