Answer-first summary for fast verification
Answer: The `SELECT` statement on `tv_channels` will display data from both tables, totaling 2 records.
Let's break down each statement: 1. `CREATE TABLE channels (name string, frequency float) LOCATION '/channels';` - Successfully creates the `channels` table. 2. `INSERT INTO channels VALUES ('DB', 101.2);` - Adds a record to `channels` with name 'DB' and frequency 101.2. 3. `CREATE TABLE tv_channels (name string, frequency float) LOCATION '/channels';` - Creates `tv_channels` in the same location as `channels`. 4. `INSERT INTO tv_channels VALUES ('FS', 10045.7);` - Adds a record to `tv_channels` with name 'FS' and frequency 10045.7. 5. `DROP TABLE channels;` - Drops the `channels` table, but data for both tables remains in `/channels`. 6. `SELECT * FROM tv_channels;` - Outputs all records in `/channels`, showing 2 records. This demonstrates that dropping an external table does not delete its data from the storage location.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
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.