Class 12 Computer Science: Advanced SQL and Database Concepts
This worksheet challenges your understanding of advanced SQL queries, database normalization, transactions, and integrity constraints.
Class 12CBSEComputer SciencehardPractice
Preview · 10 questions
- Q1. Which of the following SQL clauses is used to retrieve data from multiple tables based on a related column between them?
- GROUP BY
- ORDER BY
- JOIN
- HAVING
- Q2. In a relational database, what is the primary purpose of normalization?
- To improve query performance by denormalizing data.
- To reduce data redundancy and improve data integrity.
- To increase the complexity of database schema for security.
- To allow faster data insertion without any constraints.
- Q3. Which of the following ACID properties ensures that either all operations within a transaction complete successfully, or none of them do?
- Atomicity
- Consistency
- Isolation
- Durability
- Q4. 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?
- INNER JOIN
- LEFT JOIN
- RIGHT JOIN
- FULL OUTER JOIN
- Q5. Which SQL command is used to grant specific permissions to a user on a database object?
- REVOKE
- GRANT
- DENY
- ALTER USER
+ 5 more in the printable PDF.