

InterviewSolution
Saved Bookmarks
1. |
The wildcard in a WHERE clause is useful when?(a) An exact match is necessary in a SELECT statement(b) An exact match is not possible in a SELECT statement(c) An exact match is necessary in a CREATE statement(d) An exact match is not possible in a CREATE statementThis question was posed to me by my school teacher while I was bunking the class.My enquiry is from Data Entry, Query and Reporting topic in chapter Planning Oracle Applications of Oracle |
Answer» <html><body><p>Correct <a href="https://interviewquestions.tuteehub.com/tag/choice-915996" style="font-weight:bold;" target="_blank" title="Click to know more about CHOICE">CHOICE</a> is (<a href="https://interviewquestions.tuteehub.com/tag/b-387190" style="font-weight:bold;" target="_blank" title="Click to know more about B">B</a>) An exact match is not possible in a SELECT <a href="https://interviewquestions.tuteehub.com/tag/statement-16478" style="font-weight:bold;" target="_blank" title="Click to know more about STATEMENT">STATEMENT</a><br/><br/>Easy explanation: Wildcard <a href="https://interviewquestions.tuteehub.com/tag/useful-1441152" style="font-weight:bold;" target="_blank" title="Click to know more about USEFUL">USEFUL</a> only when an exact match is not possible in a SELECT statement.</p></body></html> | |