||True or false: The ALTER DATABASE statement is often used to modify an existing table's structure.|
||False. Most systems do not have an ALTER DATABASE command. The ALTER TABLE command is used to modify an existing table's structure.|
||True or false: The DROP TABLE command is functionally equivalent to the DELETE FROM <table_name> command.|
||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.|
||True or false: To add a new table to a database, use the CREATE TABLE command.|
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.