Sams Teach Yourself SQL in 21 Days, Fourth Edition

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 ...