MCQ online, Quiz Online, MCQ Computer, MS Office, MS Excel, MS Word, MCQ Iternet, MCQ Quiz Publish Service Commission, MCQ Science, MCQ NTS GAT, and all other categories by educatepk.com...!

MCQs on SQL

MCQs on SQL
MCQ and Quiz about SQL (Structured Query Language) are available.
Option image

Q No.1 of 10

What does SQL stand for?

Option 1

Strong Question Language

Option 2

Structured Question Language

Option 3

Structured Query Language

Option 4

Static Query Language

Q No.2 of 10

Which SQL statement is used to extract data from a database

Option 1

GET

Option 2

OPEN

Option 3

SELECT

Option 4

EXTRACT

Q No.3 of 10

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

Option 1

UPDATE

Option 2

MODIFY

Option 3

SAVE AS

Option 4

SAVE

Q No.4 of 10

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

Option 1

DELETE

Option 2

REMOVE

Option 3

COLLAPSE

Option 4

None of these

Q No.5 of 10

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

Option 1

INSERT INTO

Option 2

ADD NEW

Option 3

INSERT NEW

Option 4

ADD RECORD

Q No.6 of 10

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

Option 1

SELECT FROM Person COLUMN FirstName

Option 2

SELECT FirstName FROM Persons

Option 3

EXTRACT FirstName FROM Persons

Option 4

SELECT Persons.FirstName

Q No.7 of 10

With SQL, how can you delete the records where the "FirstName" is "Peter" in the Persons Table?

Option 1

DELETE ROW FirstName='Peter' FROM Persons

Option 2

DELETE FirstName='Peter' FROM Persons

Option 3

DELETE FROM Persons WHERE FirstName = 'Peter'

Option 4

Non of these

Q No.8 of 10

With SQL, how can you insert "Olsen" as the "LastName" in the "Persons" table?

Option 1

INSERT INTO Persons ('Olsen') INTO LastName

Option 2

INSERT INTO Persons (LastName) VALUES ('Olsen')

Option 3

INSERT ('Olsen') INTO Persons (LastName)

Option 4

Non of these

Q No.9 of 10

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

Option 1

SORT

Option 2

ORDER BY

Option 3

SORT BY

Option 4

ORDER

Q No.10 of 10

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

Option 1

SELECT * FROM Persons WHERE FirstName<>'Peter' AND LastName<>'Jackson'

Option 2

SELECT FirstName='Peter', LastName='Jackson' FROM Persons

Option 3

SELECT * FROM Persons WHERE FirstName='Peter' AND LastName='Jackson'

Option 4

All of these

Correct Answers