Question
1.
2.
3.
4.
Answer (Detailed Solution Below)
Option 3 : Bina, Divya / Bina, Divya
Advertisement
Detailed Solution
सही उत्तर Bina, Divya / Bina, Divya है।
Key Points
Helpful?
prepsnap.in • Part -AQuestion:
Names in table EMP are: Amit, Bina, Chetan, Divya, Esha. Which rows does SELECT Name FROM EMP WHERE Name LIKE '_i%'; return? / तालिका EMP में नाम हैं: Amit, Bina, Chetan, Divya, Esha। SELECT Name FROM EMP WHERE Name LIKE '_i%'; कौन-सी पंक्तियाँ लौटाता है?
1.
Amit / Amit
2.
Esha / Esha
3.
Bina, Divya / Bina, Divya
4.
Chetan, Divya / Chetan, Divya
Correct Answer: Bina, Divya / Bina, Divya
The pattern '_i%' means any first character, 'i' as the second character, then anything; only Bina (B-i-…) and Divya (D-i-…) satisfy it. / पैटर्न '_i%' का अर्थ है कोई भी पहला अक्षर, दूसरा अक्षर 'i', फिर कुछ भी; केवल Bina (B-i-…) और Divya (D-i-…) इसे संतुष्ट करते हैं।
Downloaded from PrepSnap (prepsnap.in)