Scribd
Upload
2 views2 pages

Introduction To SQL Questions Answers

The document provides an introduction to SQL, covering its definition, purpose, and common commands such as SELECT, INSERT, UPDATE, and DELETE. It explains key concepts like databases, tables, rows, columns, and SQL data types. Additionally, it mentions popular SQL databases and categorizes SQL commands into DDL and DML.

Uploaded by

surajthokalskm
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
2 views2 pages

Introduction To SQL Questions Answers

The document provides an introduction to SQL, covering its definition, purpose, and common commands such as SELECT, INSERT, UPDATE, and DELETE. It explains key concepts like databases, tables, rows, columns, and SQL data types. Additionally, it mentions popular SQL databases and categorizes SQL commands into DDL and DML.

Uploaded by

surajthokalskm
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Introduction to SQL – Questions & Answers

1. What is SQL?
SQL (Structured Query Language) is a standard language used to store, retrieve, manage, and
manipulate data in relational databases.

2. What does SQL stand for?


SQL stands for Structured Query Language.

3. Why is SQL used?


SQL is used to create, read, update, and delete data in databases.

4. What type of language is SQL?


SQL is a declarative (non-procedural) language.

5. What is a database?
A database is an organized collection of data stored electronically.

6. What is a table?
A table stores data in rows and columns.

7. What is a row?
A row represents a single record in a table.

8. What is a column?
A column represents a field or attribute.

9. Name popular SQL databases.


MySQL, Oracle, SQL Server, PostgreSQL, SQLite.

10. What is SELECT command?


SELECT retrieves data from a database.

11. What is INSERT command?


INSERT adds new records to a table.

12. What is UPDATE command?


UPDATE modifies existing records.

13. What is DELETE command?


DELETE removes records from a table.

14. What is CREATE command?


CREATE is used to create tables or databases.

15. What is DROP command?


DROP deletes table or database structure.

16. What is TRUNCATE?


TRUNCATE removes all records but keeps structure.

17. What is WHERE clause?


WHERE filters records based on conditions.

18. What is ORDER BY?


ORDER BY sorts the result set.
19. What is GROUP BY?
GROUP BY groups rows with same values.

20. What is DISTINCT?


DISTINCT removes duplicate records.

21. What are SQL data types?


They define the type of data stored in a column.

22. What is Primary Key?


A primary key uniquely identifies records.

23. What is DDL?


DDL includes CREATE, ALTER, DROP.

24. What is DML?


DML includes SELECT, INSERT, UPDATE, DELETE.

25. Which databases use SQL?


Relational databases use SQL.

You might also like