DBA712S - DATABASE ADMINISTRATION - 1ST OPP- NOV 2022


DBA712S - DATABASE ADMINISTRATION - 1ST OPP- NOV 2022



1 Pages 1-10

▲back to top


1.1 Page 1

▲back to top


nAmI BIA un IVERSITY
OF SCI En CE Ano TECH n OLOGY
FA CUL TY OF COMPUTING AND INFORMATICS
DEPARTMENT OF COMPUTER SCIENCE
QUALIFICATION : BACHELOROF COMPUTER SCIENCE
QUALIFICATION CODE: 07BAC, 07BCMS
LEVEL: 7
COURSE: DATABASEADMINISTRATION
COURSE CODE: DBA712S
DATE: NOVEMBER 2022
DURATION: 3 Hours
SESSION: 1
MARKS: 100
EXAMINER (S)
FIRST OPPORTUNITY EXAMINATION QUESTION PAPER
MR. ISAAC NHAMU
MODERATOR
DR. AMER DHEEDAN
THIS EXAM MEMORANDUM CONSISTS OF 6 PAGES
(Excluding this front page)
INSTRUCTIONS
1. Answer ALL the questions on the answer scripts.
2. Write clearly and neatly.
3. Number the answers clearly.
4. When answering questions you should be guided by the allocation of marks in [ ]. Do not give too
few or too many facts in your answers.
PERMISSIBLE MATERIALS
1. Non-programmable calculator.

1.2 Page 2

▲back to top


1.3 Page 3

▲back to top


Section A (Multiple Choice)
1. What is TRUE about a table space?
A. It cannot be assigned to more than one user
B. It can have more than one data file
C. It can only have one data file
D. It is related to a schema
E. It cannot be dictionary managed
2. A table has ... (Choose two)
A. An Extent
B. A User
C. A definition in the catalog
D. A segment of a tablespace
E. A pluggable database
3. Oracle Database Startup
A. Is one continuous process that cannot be interrupted
B. Proceeds in 3 phases, can be stopped after each phase
C. Uses the REDOlog files to find the data files for the DB on disk
D. Uses all available memory of the server
E. Connects all Oracle clients that run SQL*Plus
4. A Tables pace can be declared as ... (Choose two)
A. Unusable
B. Temporary
C. Log file
D. Data file
E. Undo
[20 marks]
Page 11

1.4 Page 4

▲back to top


1.5 Page 5

▲back to top


5. A view cannot be used for
A. Retrieving data from a database in a user-friendly format
B. Presenting data from a table join as if it was one table
C. Updating two or more related tables
D. Inspecting the indexes for a table
E. Updating one table
6. A User can ... (Choose two)
A. Be assigned multiple roles
B. Have multiple schemas
C. Have the privilege to access one or more table spaces
D. Have an authentication method that does not require a password
E. Have multiple concurrent sessions
7. A database is a collection of logical structures of data, or schema objects
A. True
B. False
8. Roles do include ... (Choose three)
A. Object privileges
B. Authentication to query the catalog
C. Resource Quota
D. System privileges
E. Other roles
9. The ______
A. Redo log
B. Archive log
C. Both a and b
D. Data file
records all changes made to data
Page I 2

1.6 Page 6

▲back to top


1.7 Page 7

▲back to top


10. What is needed to insure that data, which logically belong together, are correctly stored on the
database, before a shutdown occurs
A. Shutdown transactional
B. Shutdown immediate
C. Shutdown abort
D. A onscreen message to all users to save their data
E. Nothing special
11. When an Oracle database is created, which user is automatically created and granted the OBA
role
A. SYS
B. SYSTEM
C. SGA
D. Both a and b
12. Which of the following rule below is FALSEfor a database object?
A. Has a unique name within that schema
B. Object names cannot be longer than 30 bytes
C. Must begin with a letter
D. None of the above
13. Creating an Account does not require
A. A unique userid
B. A list of tables to be accessed
C. A user profile
D. An authentication method
E. One or more tablespaces to be used
Page I 3

1.8 Page 8

▲back to top


1.9 Page 9

▲back to top


14. The Enterprise Manager
A. Is always available when the database is started
B. Is a separate service running under the OS
C. When it is stopped, the database will automatically shut down
D. Is a project management tool
E. Is required to run database applications
15. To make a client- server connection the following are required in the client's NET configuration
file EXCEPT.
A. Host name
B. Port number
C. Protocol
D. Service name
E. Host login credentials
Section B (Structured Questions)
Question 1
Describe what each of the following is used for in Database Administration:
i. tnsnames.ora file
ii. Segment
iii. Listener
iv. Trigger
v. View
[55 marks]
[10]
Question 2
a. Identify which ones for the following database object names are valid and which are
invalid. Give reasons for your choice for invalidity.
[8]
i. "DBA Second Semester"
ii.
Two BrothersDB
iii.
First 1st national DB 4 NUST Sem2
iv. session
v. 2yeni DB
b. In a Database what is an SID and Database Global Name. Give an example of each.
Page I 4

1.10 Page 10

▲back to top


2 Pages 11-20

▲back to top


2.1 Page 11

▲back to top


[2]
c. Differentiate the following backup types:
[SJ
i.
Full backup
ii.
Incremental backup
iii. Differential backup
Question 3
Outline the 2 challenges and 3 opportunities presented to database administration by
current technological changes.
[10]
Question 4
Outline five benefit of using a multitenant container database that uses multiple pluggable
databases.
[10]
Question 5
In the process of managing a database, there are a number of management tools that enable
the DBA to interact with and manage the database. Amongst these are the Enterprise
Manager which works mostly with wizards and SQL*Plus which uses the Command line.
As a DBA compare the two interfaces mentioned above in terms of their benefits and
limitations in the database administration field.
[10]
Page I 5

2.2 Page 12

▲back to top


2.3 Page 13

▲back to top


Section C (SQLCommands}
[25 marks]
Question 1
Describe what each of the following SQLcommands achieve?
[10]
i. CONNECT Munya/Ruv@123 @nustpdb
ii.
ALTER SESSION SET CONTAINER= yournamepdb
iii.
SELECT name FROM v$database
iv.
SELECT name, space_limit
FROM v$recovery_file_dest;
v. SELECT log_mode FROM v$database;
Question 2
a. Write SQL commands to create a table called Salary_lnformation in the SYSTEM
schema to store information from a file called Salary_info.csv that contains
information shown inn Figure 1. The columns used are First_name, Surname and
Salary.
[4]
DANIEL, VANWYK, 13500
EMILIA, IIPillvlBU, 11320
JOSHUA, I\\.TJJAKOLOKO,15060
RACHEL,SHIMENE,13500
RUBEN, NGHIPULWA, 13500
ABEL TANGENI, NGULA, 12350
IMMANUEL, GAWISES, 12350
ANDREW SHUUVENI, MATEUS, 15060
BERTliA,ANDREAS,13500
OBERT FE.i'JNI, MARTINS, 12350
MATHE\\N, ITHil\\.TJJI,1350~
Figure 1
b. Create a suitable control file in the folder C:\\Export called Salary_lnfo.ctl to be used
by the SQL Loader for import the contents of the file Salary_info.csv into the table
Salary_lnformation.
[8]
c. Write the sqlldr command that will be used to load the data in Figure 1 into the table
Salary_information in the SYSTEM schema. Assume the password for the SYSTEM
user is Easy!Exam.
[3]
<<<<<<<<END>>>>>>>>
Page I 6

2.4 Page 14

▲back to top


!1P.nl!BIA
UlllVl:RSITY
OF SClEflCEAno
H:(HflOLOGY
P/BagB388
Wit1dhoek
NAMISIA
2022-10- 1 8
FACULTOYFCOMPUTING&!fJfm(~;,.t,ot:c:
DEPARTMEM((T1:1,.J:-;..·