One method to insert raw data into a table is to use an INSERT statement. What is another way that can be used to insert raw data into a table? ALTER TABLE statement LOAD DATA statement InnoDB engine SELECT statement A manager deletes the BUILDING MANAGEMENT row in a DEPARTMENT table. Deleting the row also sets the values of the GARDENING_TEAM and CLEANING TEAM columns from the referenced PERSONAL_TEAMS table to nothing. Which referential-integrity rule is in effect? The set-to-null delete rule The default delete rule The cascade delete rule The restrict delete rule A referential integrity restrict delete rule is in effect on the TEAM table, which includes the L02 team. When can the L02 team be deleted from this TEAM table? When the L02 team is set to a NULL value When the manager of the team leaves the team and hands off project responsibility to the manager's manager. When the TEAM table is deleted When the L02 team is no longer responsible for a project described by a dependent row in another table. An index was created with the following command: CREATE INDEX index_name ON inventory (partnum, supplier); What happens if the supplier column is dropped from the table? The index is dropped. The index generates a new index. The index continues referring to the remaining column. The index continues referring to both columns.