Introduction to SQL

What does SQL stand for?

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

• SELECT UNIQUE

• SELECT DIFFERENT

• SELECT

• SELECT DISTINCT

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

• MODIFY

• SAVE AS

• UPDATE    

• SAVE

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

• INSERT INTO   

• ADD NEW

• INSERT NEW

• ADD RECORD

How do you select a column named "FirstName" from a table named "Persons"?

• SELECT Persons.FirstName

• SELECT FirstName FROM Persons

• EXTRACT FirstName FROM Persons

How do you select all the columns from a table named "Persons"?

To select all the records from a table named "Persons" where the value of the column "FirstName" is "Peter", we use

• SELECT * FROM Persons WHERE FirstName<>'Peter'     

• SELECT [all] FROM Persons WHERE FirstName='Peter'

• SELECT * FROM Persons WHERE FirstName='Peter'

• SELECT [all] FROM Persons WHERE FirstName LIKE 'Peter'

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 LIKE '%a'

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

• SELECT * FROM Persons WHERE FirstName='a'

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

Which SQL statement is used to return only different values?

• SELECT UNIQUE

• SELECT DIFFERENT

• SELECT

• SELECT DISTINCT

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