 |
DBA721S - DATABASE ADMINISTRATION - 2ND OPP - JULY 2025 |
|
|
1 Page 1 |
▲back to top |
nAm I BIA unlVERSITY
OF SCIEnCE Ano TECHnOLOGY
FACULTYOFCOMPUTINGAND INFORMATICS
DEPARTMENTOF COMPUTERSCIENCE
QUALIFICATION:Bachelor of Computer Science
-
QUALIFICATIONCODE:07BACS
LEVEL:7
COURSENAME: Database Administration
COURSECODE:DBA721S
OATEJ: u!y
PAPER:THEORY
DURATION: 3 HOURS
MARl<S:70
SECOND/SUPPLEMENTARYOPPORTUNITYEXAMINATION QUESTION PAPER
EXAMINER
MS. Albetina Shilongo
Mr. Ericky lipumbu
MODERATOR
Mr. Paulus Kautwima
THIS QUESTION PAPERCONSISTSOF 4 PAGES{Including this front page)
INSTRUCTIONS
1) Answer ALL the questions on the answer scripts provided.
2) Write dearly and neatly.
3) Be guidp,d by the number of marks allocated when answering th.e questions.
.
•,,
4) Show all .your calculations.
5) Number your questions clearly.
pg. 1
|
|
2 Page 2 |
▲back to top |
Question 1: Write down the question number and the correct answer next to it.
[10]
1. The ______
records changes made to the data
a) Redo log
b) Archive log
c) Both and B
d) Data file
2.
Which of the following is not a standard attribute of a database account?
a) A unique username
b) An authentication method
c) A default tablespace
d) A unique nickname
3. Which of th~ following privileges manages data encryption operations?
a) SYSDBA
b) SYSOPR
c) SYSIGVl
d) SYSBACKUP
4. Which is the preferred method to recover a database after a transaction in progress terminates
abnormally?
a) Rollback
b) Roll forward
c) Switch to duplicate database
d) Reprocess transactions
5. When is an Oracle database created, which user/sis automatically created and granted the DBA role?
a) SYS
b) SYSTEM
c) SGA
d) Both a and b
6. Which Oracle edition was the first edition to extend databases to be transformed into datacentres and
a shared pool of resources?
a) Ora'cle Database 9i
b) Oracle Database 10g
c) Oracle database 8i
d) Oracle database 12C
7. Which of the following commands is used to start listeners in Oracle?
pg.2
|
|
3 Page 3 |
▲back to top |
a) listeners start
b) lsnrctl start
c) Lis starts
d) None of the above
8. Multiple sessions can be created concurrently for a single Oracle database user using the same
username.
a) True
b) False
9. Oracle database physical storage can be managed without affecting the logical structure.
a) True
b) False
10. The instance consists of memory structures and background processes associated with that instance.
a) True
b) False
Question 2: Structured Questions
[40)
1. You were recently appointed Junior Database Administration in an organisation. You were presented
with a problem whereby the HR department needs to purchase an application that uses an Oracle
database as the repository for application data. Your job is to recommend a suitable application and
install and configure the Oracle Database 10g software on the server. As the OBA, how would you go
about this?
(8)
2. For a user to access the Oracle database, they need to have an account created and configured with
various settings/parameters. Distinguish between the following setting when administering Oracle
database account users and give an example of each.
(4)
a) Privilege:
b) A role:
3. List and explain two types of initialization parameter files in Oracle.
(4)
4. List and explain any 2 types of auditing in databases.
(8)
5. Upon creating a user account, Maria in Oracle, the DBAhas not granted the session privilege to this user.
However, she was still able to connect to the database. Explain why this is possible
(3)
6. One of the'·.keyduties of OBA is to protect the database from failure wherever possible. List and explain
any four (4) categories of database failure.
(8)
7. List and explain any four types of back-ups in databases.
(7)
pg.3
|
|
4 Page 4 |
▲back to top |
Question 3: Practical and LongQuestions
[18)
The disk on which your redo log file is located is corrupted. As a result, you have decided to relocate the redo
log files to a different disk.
a) After you shut down the database, what actions can you take to relocate the log file redo, and what
changes will you make to the database?
{10)
b) Write SQLcommands to create a user called l<ermit and assign a password to the user, grant the user a
profile called HRCLERKa, nd the user must be able to create a session.
(8)
(Write the code using the correct syntax)
Total Marks 70
pg.4