Download PTU B.Sc IT (BCA) 2019 May 4th Semester 74084 DATABASE MANAGEMENT SYSTEM Question Paper

Download PTU (Punjab Technical University) BSc IT (BCA) 4th Semester 74084 DATABASE MANAGEMENT SYSTEM Last 10 Years 2020, 2019, 2018, 2017, 2016, 2015, 2014, 2013, 2012, 2011 and 2010 Previous Question Papers.

1 | M - 7 4 0 8 4 ( S 3 ) - 1 1 1 5
Roll No. Total No. of Pages : 02
Total No. of Questions : 07
B.Sc. (IT) (2015 & Onwards) (Sem.?4)
DATABASE MANAGEMENT SYSTEM
Subject Code : BSIT-402
M.Code : 74084
Time : 3 Hrs. Max. Marks : 60
INSTRUCTIONS TO CANDIDATES :
1. SECTION-A is COMPULSORY consisting of TEN questions carrying TWO marks
each.
2. SECTION-B contains SIX questions carrying TEN marks each and students have
to attempt any FOUR questions.

SECTION-A
1. Answer briefly :
a) What is the benefit of database? Explain
b) What do you understand by Attribute? Explain
c) What is atomicity of transaction?
d) What do you understand by Relationship? Explain
e) What are the features of DCL?
f) Give example using SQL for the Retrieval with a group by clause.
g) What is a select statement in SQL?
h) Give example using SQL for the Retrieval with a sub query.
i) What are the security need of database?
j) What is Client / Server Architecture?
FirstRanker.com - FirstRanker's Choice
1 | M - 7 4 0 8 4 ( S 3 ) - 1 1 1 5
Roll No. Total No. of Pages : 02
Total No. of Questions : 07
B.Sc. (IT) (2015 & Onwards) (Sem.?4)
DATABASE MANAGEMENT SYSTEM
Subject Code : BSIT-402
M.Code : 74084
Time : 3 Hrs. Max. Marks : 60
INSTRUCTIONS TO CANDIDATES :
1. SECTION-A is COMPULSORY consisting of TEN questions carrying TWO marks
each.
2. SECTION-B contains SIX questions carrying TEN marks each and students have
to attempt any FOUR questions.

SECTION-A
1. Answer briefly :
a) What is the benefit of database? Explain
b) What do you understand by Attribute? Explain
c) What is atomicity of transaction?
d) What do you understand by Relationship? Explain
e) What are the features of DCL?
f) Give example using SQL for the Retrieval with a group by clause.
g) What is a select statement in SQL?
h) Give example using SQL for the Retrieval with a sub query.
i) What are the security need of database?
j) What is Client / Server Architecture?
2 | M - 7 4 0 8 4 ( S 3 ) - 1 1 1 5
SECTION-B
2. Explain the following type of keys with example
a) Primary Key
b) Secondary Key
c) Candidate key
d) Super key
3. What are the first three normalization in relational database model?
4. What is the architecture of a database? Explain with example.
5. What are the various advantages of databases over the file system?
6. Compare the features of relational, Hierarchical and network model.
7. What are the security requirements of a database? Explain with example.










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.

FirstRanker.com - FirstRanker's Choice