Bird
0
0

Which SQL keyword is mandatory when defining a view?

easy📝 Conceptual Q2 of 15
SQL - Views
Which SQL keyword is mandatory when defining a view?
ADELETE
BINSERT
CUPDATE
DSELECT
Step-by-Step Solution
Solution:

  1. Step 1: Identify the core part of a view definition

    A view is defined by a SELECT query that specifies which data to show.

  2. Step 2: Match the keyword to the view definition

    Only SELECT is used to specify the data in a view. INSERT, DELETE, and UPDATE modify data and are not part of view creation.

  3. Final Answer:

    SELECT -> Option D

  4. Quick Check:

    CREATE VIEW requires SELECT keyword [OK]
Quick Trick: Views always use SELECT to define their data [OK]
Common Mistakes:
MISTAKES
  • Using INSERT or UPDATE in view creation
  • Omitting SELECT clause
  • Confusing view with table modification

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions
More SQL Quizzes
Aggregate Functions - SUM function - Quiz 6medium GROUP BY and HAVING - How GROUP BY changes query execution - Quiz 10hard GROUP BY and HAVING - GROUP BY with NULL values behavior - Quiz 7medium INNER JOIN - How the join engine matches rows - Quiz 14medium INNER JOIN - INNER JOIN with multiple conditions - Quiz 14medium LEFT and RIGHT JOIN - Why outer joins are needed - Quiz 10easy LEFT and RIGHT JOIN - Multiple LEFT JOINs in one query - Quiz 1easy Table Constraints - Foreign key ON UPDATE behavior - Quiz 4medium Table Constraints - FOREIGN KEY constraint - Quiz 7medium Table Relationships - Many-to-many with junction tables - Quiz 3easy