POS 410 Week 1 Quiz

Instructions: Highlight your selected answer, save, and upload the results in the assignments section.

1. Which SQL statement is used to extract data from a database?
2. GET
3. EXTRACT
4. OPEN
5. SELECT
6. Which SQL statement is used to update data in a database?
7. SAVE AS
8. UPDATE
9. MODIFY
10. SAVE
11. Which SQL statement is used to insert new data in a database table?
12. ADD NEW
13. ADD RECORD
14. INSERT INTO
15. INSERT NEW
16. With SQL, how do you select a column named “FirstName” from a table named “Persons”?
17. SELECT Persons.FirstName
18. EXTRACT FirstName from Persons
19. SELECT FirstName FROM Persons
20. With SQL, how do you create a table named “Persons” with ID, “FirstName”, and “LastName” as columns?