Select one incorrect statement concerning the following SQL statement. CREATE OR REPLACE VIEW sales_view AS SELECT * FROM sales_table ORDER BY sales_date DESC LIMIT 10;

Question

Options

• ADefines the view called "sales_view".
• BReplaces "sales_view" if it already exists.
• CWhen you 'SELECT' the "sales_view", it displays the first 10 records from the "sales_table"
• DSome errors occur when "SELECT * FROM sales_table" is executed after the view is defined.
• EYou can confirm that the "sales_view" has been added by querying the view called "pg_views".

• B
  3% (1)
• C
  3% (1)
• D
  83% (24)
• E
  10% (3)

No community discussion yet for this question.