SQL Online Quiz, SQL MCQ & SQL Test

Q .

What does SQL stand for?

Structured Query Language

Structured Question Language

Strong Question Language

None of the above

Correct Answer : Option (A)

Structured Query Language

Show Answer

Q .

With SQL, how do you select all the records from a table named "Persons" where the "FirstName" is "FreeTime" and the "LastName" is "FreeTime"?

SELECT FirstName='FreeTime', LastName='Learning' FROM Persons

SELECT * FROM Persons WHERE FirstName<>'FreeTime' AND LastName<>'Learning'

SELECT * FROM Persons WHERE FirstName='FreeTime' AND LastName='Learning'

None of the above

Correct Answer : Option (C)

SELECT * FROM Persons WHERE FirstName='FreeTime' AND LastName='Learning'

Show Answer

Q .

With SQL, how do you select all the records from a table named "Persons" where the "LastName" is alphabetically between (and including) "FreeTime" and "Learning"?

SELECT * FROM Persons WHERE LastName BETWEEN 'FreeTime' AND 'Learning'

SELECT LastName>'FreeTime' AND LastName<'Learning' FROM Persons

SELECT * FROM Persons WHERE LastName>'FreeTime' AND LastName<'Learning'

None of the above

Correct Answer : Option (A)

SELECT * FROM Persons WHERE LastName BETWEEN 'FreeTime' AND 'Learning'

Show Answer

Q .

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

OPEN

GET

EXTRACT

SELECT

Correct Answer : Option (D)

SELECT

Show Answer

Q .

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

UPDATE

SAVE AS

SAVE

Correct Answer : Option (A)

UPDATE

Show Answer

Q .

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

COLLAPSE

DELETE

REMOVE

All of above

Correct Answer : Option (B)

DELETE

Show Answer

Q .

Which SQL statement is used to return only different values?

SELECT DIFFERENT

SELECT DISTINCT

SELECT UNIQUE

None of the above

Correct Answer : Option (B)

SELECT DISTINCT

Show Answer

Q .

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

SORT

SORT BY

ORDER

ORDER BY

Correct Answer : Option (D)

ORDER BY

Show Answer

Q .

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 SORT 'FirstName' DESC

SELECT * FROM Persons SORT BY 'FirstName' DESC

SELECT * FROM Persons ORDER FirstName DESC

Correct Answer : Option (A)

SELECT * FROM Persons ORDER BY FirstName DESC

Show Answer

Q .

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

ADD NEW

ADD RECORD

INSERT INTO

INSERT NEW

Correct Answer : Option (C)

INSERT INTO

Show Answer

Finish Quiz