ЁЯТ╛ SQL Practice Answers – Part 1 (Basic Level)

роЗрои்родрок் рокродிро╡ு роЙроЩ்роХро│ுроХ்роХு рокропройுро│்ро│родாроХ роЗро░ுроХ்роХுроо். роЗродு рокропройுро│்ро│родாроХ роЗро░ுрои்родாро▓் роЙроЩ்роХро│் роирог்рокро░்роХро│் роЙро▒ро╡ிройро░்роХро│ுроЯрой் рокроХிро░ро╡ுроо்.

SQL Practice Questions – Part 1 (Answers)

ЁЯФ╣ Answer 1 – Create Database



CREATE DATABASE kalvi_maanam;

ЁЯФ╣ Answer 2 – Use Database



USE kalvi_maanam;

ЁЯФ╣ Answer 3 – Create Table



CREATE TABLE students (

    id INT,

    name VARCHAR(50),

    age INT

);

ЁЯФ╣ Answer 4 – Insert Data



INSERT INTO students VALUES (1, 'Santhosh', 17);

ЁЯФ╣ Answer 5 – Insert Multiple Records



INSERT INTO students VALUES

(2, 'Arun', 18),

(3, 'Karthik', 17),

(4, 'Vijay', 19);

ЁЯФ╣ Answer 6 – View Table Data



SELECT * FROM students;

ЁЯФ╣ Answer 7 – Select Specific Column



SELECT name FROM students;

ЁЯФ╣ Answer 8 – Filter Data



SELECT * FROM students

WHERE age = 18;

ЁЯФ╣ Answer 9 – Update Data



UPDATE students

SET age = 18

WHERE id = 1;

ЁЯФ╣ Answer 10 – Delete Record



DELETE FROM students

WHERE id = 4;

Kalvi Vaanam Note:
SQL Basics strong роЖроХ build рокрог்рог роЗрои்род queries daily practice рокрог்рогுроЩ்роХ ЁЯСН

Comments

Post a Comment

Popular Posts