Computer Science · MySQL
Which of the following MySQL queries will display all the values of 'NAME' from the table 'STUDENT' that have a maximum of five characters and start with the alphabet 'A'?
- 1SELECT NAME FROM STUDENT WHERE NAME LIKE 'A%%%%';
- 2SELECT NAME FROM STUDENT WHERE NAME = 'A%%%%';
- 3SELECT NAME FROM STUDENT WHERE NAME = 'A___';
- 4SELECT NAME FROM STUDENT WHERE NAME LIKE 'A';✓
Correct answer
SELECT NAME FROM STUDENT WHERE NAME LIKE 'A';
Download Single Question PDF
Save this question and verified answer as a clean study sheet with live clickable link.
Share with Friends & Study Groups
Challenge your peer aspirants on WhatsApp or Telegram to solve this question!
Preparing for Computer Science?
Practice full-length mock tests with real exam timers, instant score analysis, and all-India ranking.
Want more practice questions on MySQL?
Solve complete topic-wise tests with detailed solutions on GkGet.
Related Practice Questions
Recommended practice questions in Computer Science · MySQL