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