9. what is SQL 10. What is DBMS 11. What is rdbms 12. what is primary key , foreign key 13. Statements of SQL 14. what is join and it's syntax

Question

Accepted Answer

SQL is a programming language used to manage and manipulate relational databases.

DBMS is a software used to manage databases.
RDBMS is a type of DBMS that uses a relational model.
Primary key is a unique identifier for a record in a table.
Foreign key is a field in a table that refers to the primary key of another table.
SQL statements include SELECT, INSERT, UPDATE, DELETE, CREATE, and DROP.
Join is used to combine data from two or more tables based on a related column.
Syntax for join includes INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL OUTER JOIN.

Popular interview questions of Software Trainee