🎴 Flashcard Mode
Database Space Management and Table Types
Card1 / 20
Mastered0
Review0
QuestionClick to flip
What is the maximum number of Nested SubQueries used in WHERE Clause?
AnswerClick to flip back
A
255
💡 Explanation:
Database management systems like Oracle support nesting of subqueries in the WHERE clause up to a maximum depth of 255 levels. Exceeding this limit results in a database compilation or execution error, making 255 the correct limit, while other options are incorrect.