SQL Questions

1. What is SQL?

Ans: Structured Query Language(SQL) is a programming language for implementing the database queries. SQL was first developed by IBM.

2. What is PL/SQL?

Ans: Programming Language/Structured Query Language(PL/SQL) is a programming language for database development.We can write  functions and stored procedures.It is dynamic programming language for database.

3. Where we use SQL and PL/SQL?

Ans: We can use SQL and PL/SQL with any programming language for back-end process(database).It will all the high-level programming languages.

4. What is the concepts in SQL?

Ans: SQL mainly for 4 statements.

Select : Get the content from the database based on our requirement.

Insert : Insert the new values into database.

Update : Update the past data with the present  data in the database.

Delete : Remove or delete the unnecessary data from the database.

These statements are possible only with queries execute against the database. SQL is not case-sensitive.

5. Statement types in SQL?

Ans : There 5 types of statements in SQL.

1.Data Definition Language(DDL)

2. Data Manipulation Language(DML)

3. Data Control Language(DCL)

4. Transaction Control Language(TCL)

5. Dynamic Query Language(DQL)