FirstRanker's choice
| Roll No. | Total No. of Questions : 09 |
| Total No. of Pages : 02 |
B.Tech.(Automation & Robotics) (DE-I 2011 & Onward)/ (ECE)/(ETE) (E-I 2011 Onwards) (Sem.-6)
--- Content provided by FirstRanker.com ---
RELATIONAL DATA BASE MANAGEMENT SYSTEM
Subject Code : BTEC-901
M.Code: 71125
| Time: 3 Hrs. | Max. Marks : 60 |
INSTRUCTION TO CANDIDATES :
- SECTION-A is COMPULSORY consisting of TEN questions carrying TWO marks each.
- SECTION-B contains FIVE questions carrying FIVE marks each and students have to attempt any FOUR questions.
- SECTION-C contains THREE questions carrying TEN marks each and students have to attempt any TWO questions.
--- Content provided by FirstRanker.com ---
SECTION-A
Q1. Answer briefly :
- Write advantages of DBMS.
- Write in brief about DBMS Layers.
- What is clustered index organization?
- Define Entity, Attributes, Entity set, relationship.
- Differentiate between Cartesian product and natural join operations used in relational algebra.
- Differentiate between SQL commands DROP TABLE and DROP VIEW.
- What is the need of normalization? Explain the first three steps involved in the normalization.
- Explain the classification of functional dependency
- Why is concurrency control needed?
- Explain in brief about Encryption and Digital Signatures.
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
1 MCode 71125
--- Content provided by FirstRanker.com ---
SECTION-B
Q2. Differentiate between File Systems and DBMS.
Q3. Explain the following terms in brief.
- Hashing
- B-trees
--- Content provided by FirstRanker.com ---
Q4. Explain in detail about Hierarchical Data Model.
Q5. Write a detailed note on Relational Algebra.
Q6. Explain in detail about Basic query Optimization Strategies.
SECTION C
Q7. a) Define BCNF. How does BCNF differ from 3NF? Explain with example.
--- Content provided by FirstRanker.com ---
b) What is meant by multivalued dependency? Explain with example.
Q8. a) Explain ACID properties of transaction management
b) Explain in detail about deadlock handling.
Q9. Explain in detail about following terms:
- Role Based Security
- Bell-la-Padula Model
--- Content provided by FirstRanker.com ---
NOTE : Disclosure of Identity by writing Mobile No. or Making of passing request on any page of Answer Sheet will lead to UMC against the Student.
2MCode 71125
--- Content provided by FirstRanker.com ---
This download link is referred from the post: PTU B.Tech 6th Semester Last 10 Years 2009-2019 Previous Question Papers|| Punjab Technical University