Download PTU MCA 2020 Dec 3rd Sem 74073 Database Administration Question Paper

Download PTU I. K. Gujral Punjab Technical University (IKGPTU) MCA (Master of Computer Applications) 2020 December 3rd Sem 74073 Database Administration Previous Question Paper

Roll No.
Total No. of Pages : 02
Total No. of Questions : 18
MCA (2015 to 2018) (Sem.?3)
DATABASE ADMINISTRATION
Subject Code : MCA-301
M.Code : 74073
Time : 3 Hrs. Max. Marks : 60
INST RUCT IONS T O CANDIDAT ES :
1 .
SECT IONS-A, B, C & D c ontains TWO questions eac h carrying TEN marks each
and students has to a ttempt any ONE ques tion from eac h SECT ION.
2 .
SECT ION-E is C OMPULSORY consisting of T EN ques tions ca rryin g TWENTY
marks in all.
SECTION-A
1)
a) Describe client-server model.
b) Discuss the activities of database environment management.
2)
What is database package? Compare various database packages with market.
SECTION-B
3)
What is database replication? What are the problems faced during this? Explain in detail.
4)
a) Write notes on :
a. Data Compression
b. Business Policy Implementation
b) Write a note on Data Compression and Business Policy Implementation
SECTION-C
5)
What is RAID technology? How it is implemented? Explain its levels in detail.
6)
Explain all steps how to create, modify and delete user roles. Also discuss roles of user.
1 | M-74073
(S6)-579

SECTION-D
7)
What is an Index? How it helps in improving database performance? Explain with
example.
8)
What is performance tuning in databases? Discuss its methodology.
SECTION-E
Write briefly :
9)
Log Switch
10) RAID
11) Instance Vs. Schema
12) Stored Procedures
13) Tablespace
14) Partial Backup
15
a) Auditing
b) On-line redo log
16) Data Encryption
17) Sub Query
18) Nested Function
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.
2 | M-74073
(S6)-579

This post was last modified on 14 February 2021