Skip to document
Welcome to StudocuSign in to access the best study resources
Guest user
0followers
HomeMy LibraryAsk AI
  • You don't have any recent items yet.
My Library
  • You don't have any courses yet.
  • You don't have any books yet.
  • You don't have any Studylists yet.

3764 ST1 2016 QQ - Test

Test
Course

Introduction to Databases and Databases Management Systems:Part 1 (CSIQ2634)

37 Documents
Students shared 37 documents in this course
Academic year: 2022/2023
Uploaded by:
Anonymous Student
This document has been uploaded by a student, just like you, who decided to remain anonymous.
University of the Free State

Comments

Please sign in or register to post comments.

Students also viewed

Related documents

Preview text

1 | P a g e

UNIVERSITY OF THE FREE STATE

UNIVERSITEIT VAN DIE VRYSTAAT

QWA QWA CAMPUS/KAMPUS

CSIQ 3714

DEPARTMENT OF COMPUTER SCIENCE AND INFORMATICS

DEPARTEMENT REKENAARWETENSKAP EN INFORMATIKA

Semester Test 1 2016 / Semester Toets 1 2016

ASSESSORS/

ASSESSORE:

1. Mr G. Dollman

MODERATOR/

MODERATOR:

1. Dr L. Barnard

MARKS/ PUNTE: 97

Instructions Answer all the questions. Number your answers clearly.

You have been hired as a DBA to manage a SQL Server database for company that supports an Android fitness application called AfricaFit. The company started with a single programmer but has grown to over twenty employees over the last few months. The database has remained unchanged since the release of the application from over a year ago.

Question 1 The forum has many posts with users complaining that their fitness data is not being saved correctly and the calorie reports are inaccurate. a) You troubleshoot the problem and discover that there are problems with simultaneous transactions within the database. What problems can this cause? (6)

You have discovered that no locking mechanism has been instituted for the AfricaFit database. b) Discuss the different lock types available and how they function. (7)

2 | P a g e

You have applied the locks but users are now reporting that their application occasionally gets “stuck” when trying to update their fitness information online. After a few queries you generate the table shown below:

ProcessID User Query Type Waiting for lock held by 125 Fit99 UPDATE 174 174 JonDOe SELECT 125 Fit99 INSERT 174 JonDOe INSERT 125 184 MaxxFit SELECT

c) Considering the table above, identify the problem and discuss the techniques available that could help minimise the problem. (7)

d) The business owner approaches you that she has heard about an “Optimistic Method” for concurrency control. Explain to her what this approach entails and whether it is suitable for the AfricaFit database. (11) Total [31]

Question 2 The AfricaFit database has been redesigned and implemented. During this process a feature has been added to allow users of the application to purchase additional premium features. An excerpt of the database is shown below:

Was this document helpful?

3764 ST1 2016 QQ - Test

Course: Introduction to Databases and Databases Management Systems:Part 1 (CSIQ2634)

37 Documents
Students shared 37 documents in this course

University: University of the Free State

Was this document helpful?
1 | P a g e
UNIVERSITY OF THE FREE STATE
UNIVERSITEIT VAN DIE VRYSTAAT
QWA QWA CAMPUS/KAMPUS
CS
IQ
3
7
14
DEPARTMENT OF COMPUTER SCIENCE AND INFORMATICS
DEPARTEMENT REKENAARWETENSKAP EN INFORMATIKA
Semester Test 1 2016 / Semester Toets 1 2016
ASSESSORS/
ASSESSORE:
1. Mr G.J. Dollman
MODERATOR/
MODERATOR:
1. Dr L. Barnard
MARKS/ PUNTE: 97
Instructions
Answer all the questions. Number your answers clearly.
You have been hired as a DBA to manage a SQL Server database for company that supports an Android fitness
application called AfricaFit. The company started with a single programmer but has grown to over twenty
employees over the last few months. The database has remained unchanged since the release of the application
from over a year ago.
Question 1
The forum has many posts with users complaining that their fitness data is not being saved correctly and the
calorie reports are inaccurate.
a) You troubleshoot the problem and discover that there are problems with simultaneous transactions
within the database. What problems can this cause?
(6)
You have discovered that no locking mechanism has been instituted for the AfricaFit database.
b) Discuss the different lock types available and how they function.
(7)

Students also viewed

Related documents