Roll No. EEEEEEEEEE Total No. of Pages : 02
Total No. of Questions : 18
--- Content provided by FirstRanker.com ---
B.Tech. (CSE) (2012 to 2017) (Sem.-6)
RDBMS-II
Subject Code : BTCS-602
M.Code : 71108
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 ---
Write briefly :
- Write advantages of databases over file oriented system.
- What do you mean by validation?
- What is the role of replication in distributed database system?
- What is 4NF?
- What do you mean by DDL?
- What are the features of mySQL?
- Describe shadow paging.
- Discuss the various components of DBMS environment and how do they relate to each other.
- What is OLTP?
- What is data mining?
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
SECTION-B
- What do you understand by transaction? What are the properties of transactions?
- How is cost estimated in query optimization?
- Compare OOD and ORD.
- What are the advantages and disadvantages of distributed database systems?
- What is the two-phase locking protocol? Explain with suitable example.
--- Content provided by FirstRanker.com ---
SECTION-C
- What do you mean by normalization? Explain with a suitable example showing normalization till 3NF.
- Compare the Deferred update technique and immediate update recovery technique.
- Describe the three schema architecture. How does the schema definition language support this structure?
--- 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.
--- Content provided by FirstRanker.com ---
This download link is referred from the post: PTU B.Tech Question Papers 2020 March (All Branches)