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.