 |
DBA712S - DATABASE ADMINISTRATION - 2ND OPP - JULY 2024 |
|
|
1 Page 1 |
▲back to top |
nAm I BI A u n IVE RSITY
OFSCIEnCEAno TECHno LOGY
FACULTY OF COMPUTING AND INFORMATICS
DEPARTMENTOF COMPUTERSCIENCE
QUALIFICATION:BACHELOROF COMPUTER SCIENCE(SYSTEMSADMINISTRATION)
QUALIFICATIONCODE:07BCMS
LEVEL:7
COURSE:Database Administration
COURSECODE:DBA712S
DATE:July 2024
SESSION:1
DURATION:3 hours
MARKS:100
SUPPLEMENTARY/SECONDOPPORTUNITYEXAMINATION QUESTIONPAPER
EXAMINER(S)
MS. NDESHIHAFELAKAKWAMBI
MODERATOR:
MR. MONDJILA NDINOMWENE
THIS QUESTIONPAPERCONSISTSOF 4 PAGES
(Excluding this front page)
INSTRUCTIONS
1. Answer ALL the questions.
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
1. Non programmable Scientific Calculator.
|
|
2 Page 2 |
▲back to top |
Section 1: Multiple choice questions
1. A SYSadmin user grant privileges to other normal users
a. Yes
b. No
2. The following is not an admin user
a. SYSDBA
b. SYSOPER
c. SYSBACKUP
d. None of the above
3. DBMS Advantages
a. Simplicity
b. Better Data Transferring
c. Faster data Access
d. All of the above
4. Which one of the following is a Database type?
a. Cloud databases
b. Conditional database
c. Administration database
d. None of the above
5. Which one of the following SQLcommands is a TCLcommand?
a. GRANT
b. SELECT
c. DROP
d. COMMIT.
(16 Marks]
[1]
[1]
[1]
[1]
[1]
6. When an Oracle database is installed, which user is created with admin privileges [1]
a. SYS
b. SYSTEM
c. SGA
d. Both a and b
|
|
3 Page 3 |
▲back to top |
7. Which of the following cannot be edited in the ORA file?
(1)
a. Database name
b. Service name
c. Host name
d. Host login credentials
8. Among this Database failure which one is not a Database Network Failure [1]
a. Listener fails
b. Network interface card fails
c. Network connection fail
d. User drops a table
9. Which of the following is not a database challenge in an organization?
[1]
a. Scalability
b. Modifiability
c. Adaptability
d. Data security
10. Which one of the following is not a database application?
[1]
a. Social media sites
b. E-commerce websites
c. Static websites
d. Online Banking systems
11. In space segment management Compression options is used to compress data to solve
disk space.
[1]
a. True
b. False
12. False logging is a safe method to make sure that database is captured and available for
recovery in redo logs
[1]
a. True
b. False
13. Table space needs to be offline before dropping it
[1]
a. True
b. False
14. A system privileges are not required to drop a tablespace
[1]
a. True
b. False
|
|
4 Page 4 |
▲back to top |
15. The instance only consists of background processes.
[1]
c. True
d. False
16. In Oracle database server architecture user processes usually take place in the server.[1]
a. True
b. False
Section B Structured Question
(56 Marks)
Question 1
a) Mention four Database failures categories and what happens to the database during these failures
[8]
b) In Oracle database backup is very important, we have Full backup, incremental backup and
cumulative backup, what does each type of backup achieve?
[6]
c) Mention four typical problems that cause database statement failure and for each problem what
could be the solution.
[8]
Question 2
a) In the database storage architecture there are different types of database files. Mention and
discuss five database files
[10]
b) During installation, which component or section of the computer will the Database and
Instance be allocated to?
[4]
c) Oracle provides a range of tools to manage and work with Oracle databases. Mention at least
five tools and task associated to each tool in oracle database
[10]
d) Discuss the following ways to access and manipulate data from database
DDL, DQL and DCL
[6)
e) Distinguish the following oracle database terms.
[4]
System privileges and Object privileges
|
|
5 Page 5 |
▲back to top |
SectionC: PracticalQuestions
[28 marks]
Question 1
Describe what each of the following DBA SQLStartup Options commands achieve
(8)
1. SQL> start-up
2. SQL> startup nomount
3. SQL> alter database mount
4. SQL> alter database open
Question 2
You are asked to create a database name 'KULIMA' this database is for Marketing farmers products, this
database consist of 2 tables. The first table is Farmsand it has the following fields, Farm_owner_lD,
Farm_Owner_name,Farm_Name, Produce_type,Prices_per_Kg,Client_lD. The second table name is
Clientsand it has the following fields, Client_lDand Client_name.
a) Write an SQLthat can give all information of the clients
(2)
b} Write a query that can only give results of Farm_owner_lD, Farm_Name, Produce_type,
Prices_per _ Kg.
(2)
c) The department of Agriculture asks you to give information about Farm_owner_name,
Produce_type, Prices_per_ Kg and Client name.
(6)
d) You were asked by the famers Union to increase the prices of fame rs produces by 10% write an
SQL query to provide this information.
[4)
e) The Famers union faced criticism to reverse back the farm produce prices write an SQL
statement to reverse back the prices
[4)
f) The clients stopped buying from the fame rs, Write a SQL code to delete the table Clients (2)
<««<« END>>»»»