Q1. What is SQL?
Answer: SQL (Structured Query Language) is a standard programming language used to manage
and manipulate relational databases. It is used to store, retrieve, update, and delete data efficiently.
SQL is widely used in database systems like MySQL, Oracle, and SQL Server.
Q2. What is a Database?
Answer: A database is an organized collection of data that can be easily accessed, managed, and
updated. It allows users to store large amounts of information in a structured format.
Q3. What is a Table?
Answer: A table is a collection of related data organized in rows and columns. Each table
represents a specific entity in a database.
Q4. What is a Primary Key?
Answer: A primary key is a unique identifier for each record in a table. It ensures that no duplicate
or null values exist in that column.
Q5. What is a Foreign Key?
Answer: A foreign key is a column that creates a relationship between two tables. It refers to the
primary key of another table.
Q6. What is SELECT statement?
Answer: The SELECT statement is used to retrieve data from a database. It allows users to fetch
specific columns or all data from a table.
Q7. What is WHERE clause?
Answer: The WHERE clause is used to filter records based on specific conditions. It helps in
retrieving only relevant data.
Q8. What is JOIN?
Answer: JOIN is used to combine rows from two or more tables based on a related column. Types
include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.
Q9. What is Normalization?
Answer: Normalization is the process of organizing data in a database to reduce redundancy and
improve data integrity. It involves dividing tables into smaller related tables.
Q10. What is Index?
Answer: An index is used to improve the speed of data retrieval operations on a table. It works like
a pointer to quickly locate data.
Q1. What is SQL?
Answer: SQL (Structured Query Language) is a standard programming language used to manage
and manipulate relational databases. It is used to store, retrieve, update, and delete data efficiently.
SQL is widely used in database systems like MySQL, Oracle, and SQL Server.
Q2. What is a Database?
Answer: A database is an organized collection of data that can be easily accessed, managed, and
updated. It allows users to store large amounts of information in a structured format.
Q3. What is a Table?
Answer: A table is a collection of related data organized in rows and columns. Each table
represents a specific entity in a database.
Q4. What is a Primary Key?
Answer: A primary key is a unique identifier for each record in a table. It ensures that no duplicate
or null values exist in that column.
Q5. What is a Foreign Key?
Answer: A foreign key is a column that creates a relationship between two tables. It refers to the
primary key of another table.
Q6. What is SELECT statement?
Answer: The SELECT statement is used to retrieve data from a database. It allows users to fetch
specific columns or all data from a table.
Q7. What is WHERE clause?
Answer: The WHERE clause is used to filter records based on specific conditions. It helps in
retrieving only relevant data.
Q8. What is JOIN?
Answer: JOIN is used to combine rows from two or more tables based on a related column. Types
include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.
Q9. What is Normalization?
Answer: Normalization is the process of organizing data in a database to reduce redundancy and
improve data integrity. It involves dividing tables into smaller related tables.
Q10. What is Index?
Answer: An index is used to improve the speed of data retrieval operations on a table. It works like
a pointer to quickly locate data.
Q1. What is SQL?
Answer: SQL (Structured Query Language) is a standard programming language used to manage
and manipulate relational databases. It is used to store, retrieve, update, and delete data efficiently.
SQL is widely used in database systems like MySQL, Oracle, and SQL Server.
Q2. What is a Database?
Answer: A database is an organized collection of data that can be easily accessed, managed, and
updated. It allows users to store large amounts of information in a structured format.
Q3. What is a Table?
Answer: A table is a collection of related data organized in rows and columns. Each table
represents a specific entity in a database.
Q4. What is a Primary Key?
Answer: A primary key is a unique identifier for each record in a table. It ensures that no duplicate
or null values exist in that column.
Q5. What is a Foreign Key?
Answer: A foreign key is a column that creates a relationship between two tables. It refers to the
primary key of another table.
Q6. What is SELECT statement?
Answer: The SELECT statement is used to retrieve data from a database. It allows users to fetch
specific columns or all data from a table.
Q7. What is WHERE clause?
Answer: The WHERE clause is used to filter records based on specific conditions. It helps in
retrieving only relevant data.
Q8. What is JOIN?
Answer: JOIN is used to combine rows from two or more tables based on a related column. Types
include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.
Q9. What is Normalization?
Answer: Normalization is the process of organizing data in a database to reduce redundancy and
improve data integrity. It involves dividing tables into smaller related tables.
Q10. What is Index?
Answer: An index is used to improve the speed of data retrieval operations on a table. It works like
a pointer to quickly locate data.