1. Which SQL statement is used to extract data from a database?
GET
EXTRACT
OPEN
SELECT
2. Which SQL statement is used to update data in a database?
SAVE AS
UPDATE
MODIFY
SAVE
3. Which SQL statement is used to insert new data in a database table?
ADD NEW
ADD RECORD
INSERT INTO
INSERT NEW
4. 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
5. With SQL, how do you create a table named “Persons” with ID, “FirstName”, and “LastName” as columns?
Create table Persons
(
ID int not null,
FirstName varchar(20),
LastName varchar(20)
)