This download link is referred from the post: PTU B.Sc IT (BCA) Last 10 Years 2010-2020 Previous Question Papers || Punjab Technical University
Firstranker's choice
Roll No.
--- Content provided by FirstRanker.com ---
Total No. of Questions : 07
Total No. of Pages : 02
B.Sc. (IT) (2015 & Onwards) (Sem.-4)
DATABASE MANAGEMENT SYSTEM
Subject Code : BSIT-402
--- Content provided by FirstRanker.com ---
M.Code: 74084
Time: 3 Hrs.
Max. Marks : 60
INSTRUCTIONS TO CANDIDATES :
- SECTION-A is COMPULSORY consisting of TEN questions carrying TWO marks each.
- SECTION-B contains SIX questions carrying TEN marks each and students have to attempt any FOUR questions.
--- Content provided by FirstRanker.com ---
SECTION-A
- Answer briefly :
- What is the benefit of database? Explain
- What do you understand by Attribute? Explain
- What is atomicity of transaction?
- What do you understand by Relationship? Explain
- What are the features of DC
- Give example using SQL for the Retrieval with a group by clause.
- What is a select statement in SQL?
- Give example using SQL for the Retrieval with a sub query.
- What are the security needs of database?
- What is Client / Server Architecture?
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
SECTION-B
- Explain the following type of keys with example
- Primary Key
- Secondary Key
- Candidate key
- Super key
--- Content provided by FirstRanker.com ---
- What are the first three normalizations in relational database model?
- What is the architecture of a database? Explain with example.
- What are the various advantages of databases over the file system?
- Compare the features of relational, Hierarchical and network model.
- What are the security requirements of a database? Explain with example.
--- Content provided by FirstRanker.com ---
NOTE : Disclosure of identity by writing mobile number or making 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.Sc IT (BCA) Last 10 Years 2010-2020 Previous Question Papers || Punjab Technical University
--- Content provided by FirstRanker.com ---