Day 9

Quiz

1: True or false: The ALTER DATABASE statement is often used to modify an existing table's structure.
A1: False. Most systems do not have an ALTER DATABASE command. The ALTER TABLE command is used to modify an existing table's structure.
2: True or false: The DROP TABLE command is functionally equivalent to the DELETE FROM <table_name> command.
A2: False. The DROP TABLE command is not equivalent to the DELETE FROM <table_name> command. The DROP TABLE command completely deletes the table along with its structure from the database. The DELETE FROM... command removes only the records from a table. The table's structure remains in the database.
3: True or false: To add a new table to a database, use the CREATE TABLE command.
A3: True.
4: What ...

Get Sams Teach Yourself SQL in 21 Days, Fourth Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.