Question

The NAME column of a table SCHOOL is given below:
NAME
Rashmi
Rumi
Abhilasha
Sonam
Mumtak
Saya
Based on this information , find the output of the following queries :
(i) Select NAME from SCHHOL where NAME Like "%a";
Select NAME from SCHHOL where NAME Like "A%" or Length name 4​

Answer 1

name is Rashmi correct answer

Answer 2

The required answers are given below:

Explanation:

• % sign after the alphabet means, those names who are starting with a or any other letter.
• % sign before the alphabet means, those names who are ending with a or any other letter.
  Solution:

1. NAME
   Abhilasha
   Saya
2. NAME
   Rumi
   Abhilasha
   Saya