ЁЯТ╛ SQL Practice Questions – Part 3(Basic Level)
ЁЯФ╣ Question 21 – Insert Multiple Records
Tamil:
students table-ро▓் роТро░ே query рокропрой்рокроЯுрод்родி
рокро▓ records insert роЪெроп்ропுроЩ்роХро│்.
English:
Insert multiple records into the students table using a single query.
ЁЯФ╣ Question 22 – Update Record
Tamil:
роТро░ு student-рой் age value-роР update роЪெроп்ропுроо் query роОро┤ுродுроЩ்роХро│்.
English:
Write a query to update the age of a student.
ЁЯФ╣ Question 23 – Delete Specific Record
Tamil:
роТро░ு роХுро▒ிрок்рокிроЯ்роЯ student record-роР delete роЪெроп்ропுроЩ்роХро│்.
English:
Write a query to delete a specific student record.
ЁЯФ╣ Question 24 – Delete All Records
Tamil:
students table-роЗро▓் роЙро│்ро│ роЕройைрод்родு records-роР delete роЪெроп்ропுроЩ்роХро│்.
English:
Write a query to delete all records from the students table.
ЁЯФ╣ Question 25 – Drop Table
Tamil:
students table-роР рооுро┤ுро╡родுрооாроХ delete роЪெроп்ропுроЩ்роХро│்.
English:
Write a query to drop the students table.
ЁЯФ╣ Question 26 – Select Distinct Values
Tamil:
students table-ро▓் роЙро│்ро│ name column-роЗро▓் duplicate роЗро▓்ро▓ாрооро▓் values-роР роХாроЯ்роЯுроЩ்роХро│்.
English:
Display unique names from the students table.
ЁЯФ╣ Question 27 – Between Condition
Tamil:
age 15 рооுродро▓் 18 ро╡ро░ை роЙро│்ро│ students-роР select роЪெроп்ропுроЩ்роХро│்.
English:
Select students whose age is between 15 and 18.
ЁЯФ╣ Question 28 – LIKE Operator
Tamil:
рокெропро░் 'S' роОрой்ро▒ роОро┤ுрод்родிро▓் родொроЯроЩ்роХுроо் students-роР select роЪெроп்ропுроЩ்роХро│்.
English:
Select students whose names start with the letter 'S'.
ЁЯФ╣ Question 29 – IN Operator
Tamil:
age 15, 17, 19 роЖроХிроп values роЙро│்ро│ students-роР select роЪெроп்ропுроЩ்роХро│்.
English:
Select students whose age is 15, 17, or 19.
ЁЯФ╣ Question 30 – NOT Condition
Tamil:
age 18 роЕро▓்ро▓ாрод students-роР select роЪெроп்ропுроЩ்роХро│்.
English:
Select students whose age is not 18.
Answer
Comments
Post a Comment