Use app×
Join Bloom Tuition
One on One Online Tuition
JEE MAIN 2025 Foundation Course
NEET 2025 Foundation Course
CLASS 12 FOUNDATION COURSE
CLASS 10 FOUNDATION COURSE
CLASS 9 FOUNDATION COURSE
CLASS 8 FOUNDATION COURSE
0 votes
173 views
in Structured Query Language by (30.3k points)
closed by

Which are the components of SQL? How do they help to manage database?

1 Answer

+1 vote
by (30.5k points)
selected by
 
Best answer

The components of SQL are given below. 

DDL commands (3 commands) 

  • Create table: Used to create a table. 
  • Alter table: Used to modify existing column or add new column to an existing table. There are 2 keywords used ADD and MODIFY. 
  • Drop table: Used to remove a table from the memory. 

DML commands (4 commands) 

  • Select: Used to select rows from a table. The keyword From is used with this. Where clause is used to secify the conition. 
  • Insert: Used to insert new records into a table. So the keyword used is INTO. 
  • Delete: Used to delete records in a table.
  • Update: Used to modify the records in a table the keyword used is set. 

DCL (Data Control Language) commands 

  • Grant: It grants permission to the users to the database 
  • Revoke: It withdraws user’s rights given by using Grant command.

Welcome to Sarthaks eConnect: A unique platform where students can interact with teachers/experts/students to get solutions to their queries. Students (upto class 10+2) preparing for All Government Exams, CBSE Board Exam, ICSE Board Exam, State Board Exam, JEE (Mains+Advance) and NEET can ask questions from any subject and get quick answers by subject teachers/ experts/mentors/students.

...