If Attribute Fruit Stores Data As Apple Mango Banana In Table #230
If attribute “fruit” stores data as “apple, mango, banana” in table person then what will be the output of the following SQL command?</p> <pre><code class="language-sql"> SELECT fruit FROM person WHERE person_id=1 ORDER BY fruit; </code></pre>
This multiple choice question (MCQ) is related to the book/course gs gs113 MySQL. It can also be found in gs gs113 Using SQL to Manage Data - Populating and Modifying Tables - Quiz No.2.
If attribute “fruit” stores data as “apple, mango, banana” in table person then what will be the output of the following SQL command?
SELECT fruit FROM person WHERE person_id=1 ORDER BY fruit;
apple, mango, banana
apple, banana, mango
mango, apple, banana
none of the mentioned
Similar question(s) are as followings:
Online Quizzes of gs113 MySQL
MySQL Programs Using C - Using the Embedded Server Library - Quiz No.1
gs gs113 MySQL
Online Quizzes
System, Status and User Variables - User-Defined Variables - Quiz No.1
gs gs113 MySQL
Online Quizzes
Using SQL to Manage Data - Populating and Modifying Tables - Quiz No.1
gs gs113 MySQL
Online Quizzes
Using SQL to Manage Data - Populating and Modifying Tables - Quiz No.2
gs gs113 MySQL
Online Quizzes