State the output of the following query:
\[
\text{SELECT LENGTH(MID('INFORMATICS PRACTICES',5,-5));}
\]
Show Hint
- NOOUTPUT
- 5
- 0
- ERROR
The Correct Option is D
Solution and Explanation
- MID(string, start, length) extracts a substring from \textit{string}, starting at \textit{start}, of size \textit{length}.
- LENGTH(string) gives the number of characters in the string.
Step 2: Problem in query.
Here: \texttt{MID('INFORMATICS PRACTICES', 5, -5)}. The third argument (length) cannot be negative in SQL. Hence, this query is invalid.
Step 3: Conclusion.
Instead of producing a substring, the database will throw an error.
Final Answer: \[ \boxed{\text{ERROR}} \]
Top Questions on SQL
Give the output of the query: SELECT MONTH("2010-03-05");
- 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()
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;
- 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. - State the output of the following query: \[ \text{SELECT ROUND(9873.567,-2);} \]
Questions Asked in CUET exam
Rearrange the parts to form a coherent sentence:
A) when it is no longer fun.
B) stop doing something
C) if you're not growing
D) or learning from it
- CUET (UG) - 2025
- Sentence Arrangement
- Five people—A, B, C, D, and E—are sitting in a row facing north. A is to the immediate right of D. B is at one of the ends. C is sitting between E and A. Who is sitting exactly in the middle?
- CUET (UG) - 2025
- Ordering and Ranking
A consumer experiences the following total utility from consuming a certain good:
If the price per unit is ₹4, at what quantity does the consumer stop purchasing under the equilibrium condition where M U m = 5?
- CUET (UG) - 2025
- Consumer Behavior
The Darsanams of the Gosangi
Over the costumes, Gosangi wears various objects made up of leather, shells, metal and threads as ornaments. Traditionally, the prominent among them is known as Darsanam-s, which literally means vision or suggesting that which is visible. There are altogether seven Darsanams, which can be neither considered as costumes nor ornaments. But, for an outsider, they may look like ornaments. The first Darsanam that Gosangi wears,cover chest and the back. This is traditionally identified as Rommu Darsanam or Sanku Darsanam. The second one is tied around the neck and called as Kanta Darsanam. The third and fourth ones are tied around the arms of left and right hands. The fifth and sixth ones are tied to the left and right wrists. (For these specific names are mentioned by the performers). The seventh one is known as Siro Darsanam, and it is tied around the already tied hair (koppu). The performers also know all these Dasanam except the Rommu Darsanam and Dasthavejulu (records).- CUET (UG) - 2025
- Major Folk Dances of India
Percussive Musical Instruments of India
India is very rich in the number and variety of musical instruments. From time immemorial, musical instruments have been connected with various Gods and goddesses according to mythol ogy. Musical Instruments have been classified into Thata, Avanadha, Ghana and Sushira. We came across this classification first in Natyashastra. Thata variety, is an instrument with strings and played by plucking or bowing. The instruments like Veena, Sitar, violin, Sarangi etc. come under this category. The Avandha variety are instruments with skin-covered heads, and are played by beating on both sides or one side. Mridangam, Pakhawaj, Tabla etc. come under this category. Ghana vadyas are those made with metal content. Manjira, Ghatom etc. are some of the examples of Ghana Vadya. Sushira Vadya are those instruments with holes and make the sound by blowing air through the holes. Flute, Nagaswaram, Saxophone, Clarinet are some of the examples.- CUET (UG) - 2025
- Indian Music