Class 12 Computer Science: Advanced SQL and Database Concepts

Which of the following SQL clauses is used to retrieve data from multiple tables based on a related column between them?

In a relational database, what is the primary purpose of normalization?

Which of the following ACID properties ensures that either all operations within a transaction complete successfully, or none of them do?

Consider a table 'Employees' with columns 'EmpID' (PRIMARY KEY), 'EmpName', 'DeptID'. Another table 'Departments' with columns 'DeptID' (PRIMARY KEY), 'DeptName'. Which type of JOIN would typically be used to list all employees along with their department names, even if some departments have no employees?

Which SQL command is used to grant specific permissions to a user on a database object?

The process of breaking down a complex table into smaller, well-structured tables to eliminate data redundancy and improve data integrity is known as ____.

A ____ key is a set of one or more attributes that uniquely identifies a tuple in a table.

The SQL command to remove an entire database from the DBMS is ____.

Explain the difference between a primary key and a foreign key.

What is the purpose of the 'HAVING' clause in SQL?