Common RDBMS

Front

What is the full form of RDBMS?

Back

Relational DataBase Management System.

Front

What are some common RDBMS in use?

Back

Some common RDBMS include MySQL, PostgreSQL, Oracle Database, Microsoft SQL Server, and SQLite.

Front

What is the purpose of a primary key in a database?

Back

A primary key uniquely identifies each record in a database table, ensuring that no two records can have the same key value.

Front

What is a foreign key?

Back

A foreign key is a field (or collection of fields) in one table that uniquely identifies a row of another table, establishing a link between the two tables.

Front

What does the following statements in SQL do?
DROP TABLE student ;

Back

Deletes a table called student.

Front

What does BLOB in SQL stands for?

Back

Binary Large Objects.