Database Administration and Management M.Sc. 4 Semester/Term UOS — University of Sargodha 2017
Discussion
Ask a question about this paper, or help someone else with theirs. Answers are emailed to whoever asked.
No questions yet — be the first to ask.
Need a paper or stuck on a question? Ask here — students reply and you get an email.
Ask about a paperPaper text
University of Sargodha
M.Sc. 4th Term Examination 2017
Subject: Information Technology
Paper: Data Base Administration (IT-3441)
Time Allowed: 2.30 Hours
Maximum Marks: 80
Note: Objective part is compulsory. Attempt any Four questions from subjective part.
Objective Part (Compulsory)
Q. No.1. Write short answers of the following in 2-3 lines on your answer sheet.
i. Oracle server:
ii. Oracle instance:
iii. Global Area (SGA)
iv. background processes
v. Backup Compression
vi. Flash Recovery Area
vii. Validating Backups
viii. Recovery Operations
ix. Define different types of Data Encryption Standard?
x. Define system privileges and object privileges?
xi. Difference between SMON and PMON?
xii. What is Database object Metadata?
xiii. What is DATA BLOCK?
xiv. Define control file and redo file?
xv. How we maintain Data Integrity?
xvi. What is DATA PUMP?
Subjective Part (4*12=48)
Q. No.2. Explain different administration tools available in oracle 11 g.
Q. No.3. What is optimal flexible Architecture (OFA). Elaborate with an example?
Q. No.4. Write Steps for creating a database from template with Database configuration Assistant?
Q. No.5. Graphically draw the difference between manual and automatic Storage Management?
Q. No.6. Explain Backgrounds Process with its types?
Q. No.7. What is Data Block? Write the steps for moving data file with ALTER DATABASE & ALTER TABLESPACE