Download PTU I. K. Gujral Punjab Technical University (IKGPTU) MCA (Master of Computer Applications) 2020 December 3rd Sem 74073 Database Administration Previous Question Paper
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