It is well known that there are often more than one way of solving any problem. Same is the case with Oracle SQL. It is possible almost to write any SQL query using the conventional SQL and we have something known as analytical functions that make life easier for the developer. In spite of this, I have encountered interviewers not stressing upon analytic and forcing one to write SQLs in conventional form.

How far do you think this is viable? Isn't it forcing us to adapt just one way of answering a question?