SQL Quiz

What does SQL stands for?

• Structured Query Language

• Strong Query Language

• Structure Question Language

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

• OPEN

• SELECT

• EXTRACT

• GET

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

• UPDATE

• SAVE

• SAVE AS

• MODIFY

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

• DELETE

• REMOVE

• COLLAPSE

• FORMAT

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

• ADD RECORD

• ADD NEW

• INSERT INTO

• INSERT NEW

With SQL, how do you select a column named “Firstname” from a table named “Persons”?

• SELECT Persons.Firstname;

• EXTRACT Firstname FROM Persons;

• SELECT Firstname FROM Persons;

• EXTRACT Persons.Firstname;

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

• SELECT [all] FROM Persons;

• SELECT *.Persons;

• SELECT * 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 “Peter”?

• SELECT [all] FROM Persons WHERE Firstname LIKE 'Peter';

• SELECT [all] FROM Persons WHERE Firstname = 'Peter';

• SELECT * FROM Persons WHERE Firstname = 'Peter';

• SELECT * FROM Persons WHERE Firstname <>'Peter';

With SQL, how do you select all the record 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';

With SQL, how do you select all the records from a table named ‘Persons’ where the ‘Firstname’ is ‘Peter’ and the ‘Lastname’ is ‘Jackson’?

• SELECT * FROM Persons WHERE Firstname <> 'Peter' AND Lastname <> 'Jackson';

• SELECT * FROM Persons WHERE Firstname = 'Peter' AND Lastname = 'Jackson';

• SELECT Firstname = 'Peter', Lastname = 'Jackson' FROM Persons;

• SELECT [all] FROM Persons WHERE Firstname = 'Peter' AND Lastname = 'Jackson';