Kritika did not use ASC or DESC keyword with ORDER BY clause. By default in which order will the result of the query be displayed?
Show Hint
Solution and Explanation
The sorting can be done either in ascending (ASC) or descending (DESC) order.
However, if neither ASC nor DESC is explicitly mentioned, the default sorting order is ascending.
This means that values will be arranged from smallest to largest — for numbers, lowest to highest; for text, alphabetically A to Z.
Therefore, even if Kritika omits ASC or DESC, the data will still be sorted in ascending order by default.
Top Questions on SQL
Consider the following relational schema:
Which of the following options is/are correct SQL query/queries to retrieve the names of the students enrolled in course number (i.e., courseno) 1470?- After establishing the connection to fetch the data from the table of a database in SQL into a DataFrame, which of the following function will be used?
(A) pandas.read__sql__query()
(B) pandas.read__sql__table()
(C) pandas.read__sql__query__table()
(D) pandas.read__sql()
- Match List-I with List-II.
List-I List-II (A) SUBSTR() (II) To extract a substring from a string. (B) TRIM() (IV) To remove spaces from both sides of the string. (C) INSTR() (I) To find the position of a substring in a string. (D) LEFT() (III) To extract characters from the left side of the string. Given the following table:
ENO SALARY A101 4000 B109 NULL C508 6000 A305 2000 State the output of the following query:
SELECT COUNT(SALARY) FROM EMPLOYEE;
- State the output of the following query: \[ \text{SELECT ROUND(9873.567,-2);} \]
Questions Asked in CBSE CLASS XII exam
A ladder of fixed length \( h \) is to be placed along the wall such that it is free to move along the height of the wall.
Based upon the above information, answer the following questions:(iii) (b) If the foot of the ladder, whose length is 5 m, is being pulled towards the wall such that the rate of decrease of distance \( y \) is \( 2 \, \text{m/s} \), then at what rate is the height on the wall \( x \) increasing when the foot of the ladder is 3 m away from the wall?
- CBSE CLASS XII - 2025
- Application of derivatives
- A meeting will be held only if all three members A, B and C are present. The probability that member A does not turn up is 0.10, member B does not turn up is 0.20 and member C does not turn up is 0.05. The probability of the meeting being cancelled is:
- CBSE CLASS XII - 2025
- Probability
- Vishesh, Manik and Amit were partners in the ratio 5 : 4 : 1. Amit retired on 31st March, 2024. Vishesh and Manik decided to share Amit’s share in the ratio 2 : 3. What will be the new profit sharing ratio between Vishesh and Manik?
- CBSE CLASS XII - 2025
- Retirement and Death of a Partner
- The electric field in a region is given by \( \vec{E} = 40x \hat{i} \, \text{N/C}. \) Find the amount of work done in taking a unit positive charge from a point (0, 3m) to the point (5m, 0).
- CBSE CLASS XII - 2025
- Electrostatics
- Consider the Linear Programming Problem, where the objective function \[ Z = x + 4y \] needs to be minimized subject to the following constraints: \[ 2x + y \geq 1000, \] \[ x + 2y \geq 800, \] \[ x \geq 0, \quad y \geq 0. \] Draw a neat graph of the feasible region and find the minimum value of $Z$.
- CBSE CLASS XII - 2025
- Linear Programming Problem