Worked Examples · Example 11
Q.Predict the output of the following, assuming str = 'Bhubaneswar':
(i) LENGTH('Bhubaneswar'),
(ii) UPPER('das'),
(iii) CONCAT('Aarti', ' ', 'Behera'),
(iv) SUBSTR('Bhubaneswar', 1, 4),
(v) RIGHT('MySQL', 3).
ChseodishaTextbookSubjectiveImportance★★★★★est
81% · 13/16 Questions
You're viewing a preview — the full solution, concept, methods & PYQ mapping are locked.
Start your 14-day free trial to unlock the full solution →Each part uses a string function:
LENGTH('Bhubaneswar')returns the number of characters, which is 11 (B-h-u-b-a-n-e-s-w-a-r).UPPER('das')converts the text to capitals, giving'DAS'.CONCAT('Aarti', ' ', 'Behera')joins the three strings — the first name, a space, and the surname — into'Aarti Behera'. …
Unlock everything free for 14 days
- Full step-by-step solutions
- Concept-first explanations
- Methods, shortcuts & mistakes
- PYQ mapping + timed mock tests
Full access for 14 days. No credit card required.