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

Firstranker's choice

FirstRanker.com

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 :

1. SECTION-A is COMPULSORY consisting of TEN questions carrying TWO marks each.

--- Content provided by FirstRanker.com ---

2. SECTION-B contains SIX questions carrying TEN marks each and students have to attempt any FOUR questions.

SECTION-A

1. Answer briefly :
   1. What is the benefit of database? Explain
   2. What do you understand by Attribute? Explain
   3. What is atomicity of transaction?

   --- Content provided by FirstRanker.com ---

   4. What do you understand by Relationship? Explain
   5. What are the features of DC
   6. Give example using SQL for the Retrieval with a group by clause.
   7. What is a select statement in SQL?
   8. Give example using SQL for the Retrieval with a sub query.

   --- Content provided by FirstRanker.com ---

   9. What are the security needs of database?
   10. What is Client / Server Architecture?

SECTION-B

2. Explain the following type of keys with example
   1. Primary Key

   --- Content provided by FirstRanker.com ---

   2. Secondary Key
   3. Candidate key
   4. Super key
3. What are the first three normalizations in relational database model?

--- Content provided by FirstRanker.com ---

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.

--- Content provided by FirstRanker.com ---