Database- SQL

What does SQL stand for?

• Strong Question Language

• Structured Question Language

• Structured Query Language

• Simplify Query Language

Which SQL statement is used to extract data from a database?

• SELECT

• EXTRACT

• GET

• OPEN

Which SQL statement is used to update data in a database?

• SAVE AS

• CHANGE

• UPDATE

• MODIFY

Which SQL statement is used to delete data from a database?

• REMOVE

• DELETE

• COLLAPSE

• DROP

Which SQL statement is used to insert new data in a database?

• ADD RECORD

• ADD NEW

• INSERT NEW

• INSERT INTO

With SQL, how do you select a column named "FirstName" from a table named "Persons"?

• EXTRACT FirstName FROM Persons

• SELECT FirstName FROM Persons

• SELECT Persons.FirstName

• Select Persons FROM FirstName

Select all the records from a table named "Persons" where the value of the column "FirstName" starts with an "a"?

• SELECT * FROM Persons WHERE FirstName LIKE 'a%'

• SELECT * FROM Persons WHERE FirstName LIKE '%a'

• SELECT * FROM Persons WHERE FirstName LIKE '%a%'

• SELECT * FROM Persons WHERE FirstName = 'a'

Which SQL statement is used to return only different values?

• SELECT DIFFERENT

• SELECT UNIQUE

• SELECT DISTINCT

• SELECT SPECIAL

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

• SORT BY

• ORDER BY

• ORDER

• SORT

With SQL, how can you return all the records from a table named "Persons" sorted descending by "FirstName"?

• SELECT * from Persons ORDER BY FirstName DESC

• SELECT * from Persons ORDER FirstName DESC

• SELECT * from Persons SORT BY FirstName DESC

• SELECT * from Persons SORT FirstName DESC