SQL_TERM_END_Test

What does SQL stand for?

•  Structured Query Language

•  Structured Question Language

•  Strong Question Language

•  Strong Query Language

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 insert new data in a database?

•  ADD NEW

•  ADD RECORD

•  INSERT NEW

•  INSERT INTO

With SQL, 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 can you insert a new record into the "Persons" table?

•  INSERT INTO Persons VALUES ('Ahmed');
  

•  INSERT VALUES ('Ahmed') INTO Persons;

•  INSERT ('Ahmed') INTO Persons;
  

• INSERT VALUES INTO ('AHMED');

What word is missing from the line below?
SELECT *
_______ CUSTOMER;

• FROM

• WHERE

• SELECT

• ORDER BY

What is the purpose of  *?

• Selects ALL fields from the table

• Selects only the first field in the table

• Selects the last field in the table

• Shows only the first row in the table

Return only the customers who have ER anywhere in their last name. 

• last_name LIKE "%er%"

• last_name = "%er"

• last_name = "%er%"

• last_name LIKE "%er"

To find the total dollar value of sales, use which? 

• SUM

• COUNT

• MAX

• MIN