
Ultimate access to all questions.
A data engineer is testing data for radio and TV channels with valid frequencies using the following SQL statements:
CREATE TABLE channels (name string, frequency float) LOCATION '/channels';
INSERT INTO channels VALUES ('DB', 101.2);
CREATE TABLE tv_channels (name string, frequency float) LOCATION '/channels';
INSERT INTO tv_channels VALUES ('FS', 10045.7);
DROP TABLE channels;
SELECT * FROM tv_channels;
CREATE TABLE channels (name string, frequency float) LOCATION '/channels';
INSERT INTO channels VALUES ('DB', 101.2);
CREATE TABLE tv_channels (name string, frequency float) LOCATION '/channels';
INSERT INTO tv_channels VALUES ('FS', 10045.7);
DROP TABLE channels;
SELECT * FROM tv_channels;
Assuming the /channels location was initially empty, what will be the outcome of executing these statements?*_
A
The tv_channels table will not be created due to sharing the same location as the channels table._
B
Dropping the channels table will result in the deletion of data from both tables.
C
The channels table cannot be dropped because its location contains data for both tables.
D
The SELECT statement on tv_channels will display data from both tables, totaling 2 records._
E
All commands will execute successfully, and the SELECT statement will show 1 record from the tv_channels table._