This download link is referred from the post: PTU B.Tech Question Papers 2020 December (All Branches)
Roll No. [ ] [ ] [ ] [ ] Total No. of Pages : 02
Total No. of Questions : 18
--- Content provided by FirstRanker.com ---
B.Tech. (CSE) (2012 to 2017) (Sem.-5)
RELATIONAL DATABASE MANAGEMENT SYSTEM-I
Subject Code : BTCS-502
M.Code : 70535
Time : 3 Hrs. Max. Marks : 60
--- Content provided by FirstRanker.com ---
INSTRUCTIONS 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.
SECTION-A
--- Content provided by FirstRanker.com ---
Answer briefly :
- Define Data Independence and its types.
- Define and explain clustered index.
- Define Referential Integrity constraints.
- Explain Multi valued Functional Dependency.
- What is Deadlock during concurrent processing?
- Explain Variable Length Records and uses.
- Explain different joins.
- Explain two phase commit protocol.
- What are ACID properties for transactions?
- Explain digital signature.
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
SECTION-B
- Compare file system and data base management systems.
- Explain the different operations in Relational Algebra with the help of an example.
- Why is the concurrency control needed? Discuss with examples.
- What is the use of E-R model? Draw E-R diagram for student information system, student, subject, and course are three entities, consider suitable attributes, cardinalities, and degrees of the relationships in the E-R model.
- Discuss how serializability is used to enforce concurrency control in a database system? Why is serializability considered too restrictive as a measure of correctness for schedules?
--- Content provided by FirstRanker.com ---
SECTION-C
Consider the following relational database :
employee(employee-name, street, city)
--- Content provided by FirstRanker.com ---
works(employee-name, company-name, salary)
company(company-name, city)
manages(employee-name, manager-name)
Give an expression in SQL for each of the following queries :
- Find the names, street address, and cities of residence for all employees who work for ‘First Bank Corporation’ and earn-more than Rs.10,000.
- Find the names of all employees in the database who live in the same cities as the companies for which they work.
- Find the names of all employees in the database who live in the same cities and on the what different techniques are used for data encryption in Cloud Computing? Explain in detail.
--- Content provided by FirstRanker.com ---
- Discuss insertion, deletion, and modification anomalies. Why are they considered bad? Illustrate with examples?
- What is the difference between discretionary and mandatory access control? Explain with an example.
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.
--- Content provided by FirstRanker.com ---
This download link is referred from the post: PTU B.Tech Question Papers 2020 December (All Branches)
--- Content provided by FirstRanker.com ---