What Will Be The Output Of The Following Plsql Statementp Pre #506
What will be the output of the following PL/SQL statement?</p> <pre><code class="language-sql">SELECT * from student WHERE city NOT IN ('Delhi','Mumbai','Chennai');</code></pre>
This multiple choice question (MCQ) is related to the book/course
gs gs115 Structured Query Language.
It can also be found in
gs gs115 PL/SQL Constants and Operators - PL/SQL Operators - Quiz No.1.
What will be the output of the following PL/SQL statement?
SELECT * from student WHERE city NOT IN ('Delhi','Mumbai','Chennai');
Returns student’s data whose city is Delhi, Mumbai or Chennai
Returns student’s data whose city is Delhi but not Mumbai or Chennai
Returns student’s data whose city is Mumbai but not Delhi or Chennai
Returns student’s data whose city is not Delhi, Mumbai or Chennai