Aspire Digital Technologies Consultant Interview Questions and Answers

Primary key uniquely identifies a record in a table, while foreign key establishes a link between two tables.

• Primary key ensures data integrity by enforcing uniqueness of each record

• Foreign key establishes a relationship between tables by referencing the primary key of another table

• Primary key is used to uniquely identify records within a table, while foreign key is used to link tables together

DBMS is a software system that manages databases, while RDBMS is a type of DBMS that stores data in a structured format using tables.

• DBMS stands for Database Management System, which is a software system that manages databases.

• RDBMS stands for Relational Database Management System, which is a type of DBMS that stores data in a structured format using tables with relationships between them.

• RDBMS uses Structured Query La...read more