Data Management Applications Study Guide Rated A+

Which command eliminates a table? TRUNCATE TABLE DELETE TABLE REMOVE TABLE DROP TABLE {Ans: DROP TABLE}Which condition must be in effect to use the INSERT INTO ... VALUES syntax for an INSERT statement? The VALUES list must contain a value for each non-null valued column in the table. The VALUES list must contain a value for each row in the table. The INSERT INTO portion of the statement must generate a LOAD DATA statement. The INSERT INTO portion of the statement must refer to a sampdb database table. {Ans: The VALUES list must contain a value for each non-null valued column in the table.}Refer to the given information. CREATE TABLE 'test1' ( contact_id INT(10), name VARCHAR(10), event_id INT(5), Which command should be added to the end to make the event_id attribute the primary key within a CREATE TABLE statement? PRIMARY KEY = event_id); PRIMARY KEY (event_id)); (PRIMARY KEY: event_id); PRIMARY (event_id)' {Ans: PRIMARY KEY (event_id));}Refer to the given SQL statement. INSERT INTO student VALUES('John','S',NULL),('Mary','S',NULL); What do the parentheses denote? The data to be duplicated The attributes that are changeable The row values for two individual columns The column values for two individual rows {Ans: The column