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

Roll No.

Total No. of Questions: 18

Total No. of Pages : 02

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

MCA (2015 to 2018) (Sem.-3)

DATABASE ADMINISTRATION

Subject Code : MCA-301

M.Code: 74073

Time: 3 Hrs.

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

Max. Marks : 60

INSTRUCTIONS TO CANDIDATES :

1. SECTIONS-A, B, C & D contains TWO questions each carrying TEN marks each and students has to attempt any ONE question from each SECTION.
2. SECTION-E is COMPULSORY consisting of TEN questions carrying TWENTY marks in all.

SECTION-A

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

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

1. What is database replication? What are the problems faced during this? Explain in detail.

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

2. a) Write notes on :
   1. Data Compression
   2. Business Policy Implementation
   b) Write a note on Data Compression and Business Policy Implementation

SECTION-C

1. What is RAID technology? How it is implemented? Explain its levels in detail.

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

2. Explain all steps how to create, modify and delete user roles. Also discuss roles of user.

SECTION-D

1. What is an Index? How it helps in improving database performance? Explain with example.
2. What is performance tuning in databases? Discuss its methodology.

SECTION-E

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

Write briefly :

1. Log Switch
2. RAID
3. Instance Vs. Schema
4. Stored Procedures

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

5. Tablespace
6. Partial Backup
7. a) Auditing
   b) On-line redo log
8. Data Encryption

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

9. Sub Query
10. 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.

For more information visit: FirstRanker.com

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