PY4E: Chapter 15 (Part 1)

What happens if a DELETE command is run on a table without a WHERE clause?

All the rows in the table are deleted

Which of these is the right syntax to make a new table?

CREATE TABLE people;

In a typical online production environment, who has direct access to the production database?

Database Administrator

Structured Query Language (SQL) is used to (check all that apply)

Delete data Insert data Create a table

Which SQL command is used to insert a new row into a table?

INSERT INTO

What does this SQL command do? SELECT COUNT(*) FROM Users

It counts the rows in the table Users

Which keyword will cause the results of the query to be displayed in sorted order?

ORDER BY

Which command is used to retrieve all records from a table?

SELECT * FROM Users

Which of the following is the database software used in this class?

SQLite

Which of the following commands would update a column named "name" in a table named "Users"?

UPDATE Users SET name='new name' WHERE ...

In database terminology, another word for table is

relation