.png)
1.What is SQL?
SQL stands for Structured Query Language. It is a programming language designed for managing and querying data in relational database management systems (RDBMS).
2. What is a relational database?
A relational database is a collection of tables that are related to each other through a common field. These tables store data in a structured manner and are used to organize and manage large amounts of data.
3. What is a primary key?
A primary key is a unique identifier for a record in a database table. It is used to uniquely identify each record and prevent duplicates.
4. What is a foreign key?
A foreign key is a column in one table that refers to the primary key of another table. It is used to establish a relationship between two tables.
5. What is normalization?
Normalization is the process of organizing data in a database so that it is structured efficiently and without redundancy. It involves breaking down large tables into smaller, more manageable ones.
6.What is a join?
A join is a method of combining data from two or more tables into a single result set based on a common field.
7.What is a subquery?
A subquery is a query that is nested inside another query. It is used to retrieve data that will be used in the main query.
8. What is a view?
A view is a virtual table that is created by combining data from one or more tables. It is used to simplify complex queries and to provide an additional layer of security.
9. What is an index?
An index is a data structure used to improve the speed of data retrieval in a database. It provides a fast access path to data based on the values in one or more columns.
10. What is a trigger?
A trigger is a special type of stored procedure that is automatically executed in response to certain events, such as a change to a table. It is used to enforce business rules and data integrity constraints.
.png)
