Information Technology BS/MS Information Technology/MSc Information Technology 4/5 Semester/Term UOS — University of Sargodha 2024
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 paper-
BS ZOOLOGY first semester Animal diversity ZOOL 101 - university of Punjab 2025
0 replies Reply → -
Literary criticism
1 reply Reply → -
this paper consists of 60 marks but now we have 35 marks paper.
1 reply Reply → -
Can you please tell me more past papers please because my exams are starting from next week
1 reply Reply → -
Did you provide the past papers of the science of society uos?
1 reply Reply →
More Information Technology papers
See all
Information Technology AD/BS/MS Information Technology 3 Semester/Term PU — University of the Punjab 2025
Uploaded 8 hours ago · by Muskan
Download ↓
Information Technology BS/MS Information Technology/MSc Information Technology 4/5/8 Semester/Term UOS — University of Sargodha 2026
Uploaded 1 day ago · by Hifza
Download ↓
Information Technology
Uploaded 2 days ago · by Muskan
Download ↓
Information Technology AD/BS 3 Semester/Term PU — University of the Punjab 2023
Uploaded 4 days ago · by Mudassir
Download ↓
Information Technology BS 5/4 Semester/Term University Of Sargodha (UOS) 2024
Uploaded 1 year ago
Download ↓
Paper text
University of Sargodha
BS 8th/5th Intake (4th) Term Exam 2024
Subject:
Information Technology
Paper:
Database Administration & Management (ITCC-406/ITCC-4450)
Time Allowed: 02:30 Hours
Note: Objective part is compulsory. Attempt any three questions from subjective part.
Maximum Marks: 40
Objective Part
(Compulsory)
Q.1.
Write short answers of the following in 2-3 lines of each on your answer sheet.
i.
ii.
iii.
iv.
V.
vi.
vii.
viii.
What are Undo Data Statistics in Oracle?
How do you manage tables and users in Oracle?
What is the purpose of Indexes in Oracle?
How do you maintain data integrity using constraints in Oracle?
Difference between Oracle Net Manager and Oracle Enterprise Manager.
Explain Oracle Memory Structures.
What is System Global Area?
Elaborate Program Global Area.
(2*8)
Q.2.
Q.3.
Q.4.
Q.5.
Q.6.
Subjective Part
(3*8)
What are Initialization Parameters? Differentiate between static and dynamic parameters with
example of each.
Explain the role and functioning of Oracle Server and Oracle Instance.
Differentiate between system privileges and object privileges with example of each.
What is database schema? Explain different Schema objects in oracle databases.
Discuss backup and recovery strategies in Oracle, including instance and media recovery and
configuration of archive log mode.
