AD-402 · Database Management System/Unsolved PYQ Paper
DATABASE MANAGEMENT SYSTEM - DEC 2023 Question Paper
-
Unit 17 MarksaExplain any five major advantages of using a DBMS over conventional file system.
-
Unit 27 MarksbDefine Foreign key. Differentiate between Super key and Primary key.
-
Unit 27 MarksaExplain the working of following relational algebra operators with suitable examples: i) Projection ii) Selection iii) Natural Join
-
Unit 27 MarksbConsider the following database schema Emp(emp-id, name, address, age) Company(c-name, address, assets) Works_for(emp-id, c-name, salary) Write SQL statements for the following operations: i) Add column 'gender' to the Emp table ii) Add a new company named 'ABC' to the Company table iii) Find out names of all employees older than 30 years iv) Find out average salary provided by each company v) Remove the column 'assets' from the Company table vi) Find out salary of the employee named 'XYZ'
-
Unit 314 MarksExplain functional dependencies. Explain 1NF, 2NF and 3NF with suitable example(s).
-
Unit 47 MarksaExplain ACID properties of transactions. Also, define various states of transactions.
-
Unit 47 MarksbDefine Database logs and explain their importance in recovery.
-
Unit 27 MarksaExplain and provide SQL syntax of any three major DDL commands.
-
Unit 17 MarksbExplain the categories of various database users. List the tools used by each category of users.
-
Unit 114 MarksExplain the significance of ER diagrams (ERD). List the rules to reduce a given ERD into a relational schema. Show how the following constructs of an ERD are mapped into an equivalent relational schema: i) Weak entity set ii) One-to-many relationship iii) Composite attributes iv) Total participation
-
Unit 27 MarksaExplain integrity constraints in databases. Provide two example constraints and show how they are implemented in relational databases.
-
Unit 57 MarksbList the major advantages and disadvantages of using heap files as a storage structure in databases.
-
Unit 55 MarksiRAID
-
Unit 55 MarksiiHashing Techniques
-
Unit 54 MarksiiiBitmap indexing in DBMS
Go to where you left off?
Quick Add to Notes
Save questions, your own notes and screenshots into notes filed by unit. It takes a free account.
Create free accountHave an account? Log in
Notes Panel