🎴 Flashcard Mode
Java and SQL Programming Basics
Card1 / 8
Mastered0
Review0
QuestionClick to flip
Which one is true ?
AnswerClick to flip back
A
A view can be created as a join on two or more tables
💡 Explanation:
Views CAN be created as joins across multiple tables - this is a common use case for simplifying complex queries. Views can also include ORDER BY in some databases (with limitations), and GROUP BY is standard. Option A is correct. Option B directly contradicts A. Options C and D are false - views can include ORDER BY (with TOP/LIMIT in some DBs) and definitely support GROUP BY.