Data management with SQL statements

12 questions

1. Which SQL statement is used to retrieve all columns from a table?
2. Which SQL keyword is used to add new data to a table?
3. What is a primary key in a database table?
4. What does the WHERE clause do in an SQL statement?
5. What is a foreign key?
6. Match each SQL keyword to its function:
7. Which of these is True about SQL?
8. What does the SQL CREATE command do?
9. What must you always follow when writing SQL statements?
10. Which command would you use to change data in an existing record?
11. Put these steps in order to create and fill a new table in SQL:
12. Which SQL command correctly creates a table called tblStudents?

License: OGL