
Ultimate access to all questions.
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*