List of top Computer Applications Questions on Database Management Systems asked in PSEB XII

Explain the concepts of Primary Key, Foreign Key, and Candidate Key.
Write the syntax and use of SQL DDL commands (CREATE, ALTER, DROP) and DML commands (INSERT, UPDATE, DELETE).
Describe the use of built-in MySQL functions like COUNT(), SUM(), and MAX().
Define DBMS and list its advantages over a traditional file system.