Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
Which SQL command correctly creates a session-scoped temporary view?
A
CREATE OR REPLACE LOCAL VIEW view_name AS SELECT * FROM table_name
B
CREATE OR REPLACE TEMPORARY VIEW view_name AS SELECT * FROM table_name
C
CREATE OR REPLACE VIEW view_name AS SELECT * FROM table_name
D
CREATE OR REPLACE GLOBAL TEMPORARY VIEW view_name AS SELECT * FROM table_name
E
CREATE OR REPLACE LOCAL TEMPORARY VIEW view_name AS SELECT * FROM table_name
