SQL Quiz - Basic

What does SQL stand for?

• Structured Query Language

• Structured Question Language

• Strong Question Language

• Simplified Query Language

Which SQL statement is used to create a table in a database?

• CREATE DATABASE TAB

• CREATE TABLE

• CREATE DATABASE TABLE

• CREATE DB

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

• OPEN

• GET

• EXTRACT

• SELECT

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

• MODIFY

• SAVE AS

• UPDATE

• SAVE

Which SQL statement is used to remove an unwanted record from a table in a database?

• ERASE

• DELETE

• DROP

• REMOVE

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

• ADD NEW

• ADD RECORD

• INSERT RECORD

• 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

• DISPLAY FirstName FROM Persons

With SQL, how do you select all the columns from a table named "Persons"?

• SELECT all Persons

• SELECT * FROM Persons

• SELECT all FROM Persons

• SELECT *.Persons

With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is “RAMAN"?

• SELECT * FROM Persons WHERE FirstName<>‘RAMAN‘

• SELECT all FROM Persons WHERE FirstName LIKE ‘RAMAN‘

• SELECT * FROM Persons WHERE FirstName=‘RAMAN‘

• SELECT 'RAMAN' FROM Persons

With SQL, how do you 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='a‘

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

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

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