INF assignment 3 solutions

06/09/2023, 10:51 Assessment 3: Attempt review




INF3703-23-Y  Databases II (INF3703)  Assessment 3

QUIZ




Started on Wednesday, 6 September 2023, 8:36 AM
State Finished
Completed on Wednesday, 6 September 2023, 9:03 AM
Time taken 27 mins 34 secs
Marks 115.00/117.00
Grade 98.29 out of 100.00


Question 1

Correct

Mark 1.00 out of 1.00




A client-side extension is a program that interacts directly with the web server to
handle specific types of requests.


a. True
b. False 



The correct answer is: False




Question 2

Correct

Mark 1.00 out of 1.00




A data store is used by data analysts to create queries that access the database.


a. True
b. False 



The correct answer is: False




https://mymodules.dtls.unisa.ac.za/mod/quiz/review.php?attempt=13059463&cmid=671105 1/31

,06/09/2023, 10:51 Assessment 3: Attempt review

Question 3

Correct

Mark 1.00 out of 1.00




A data warehouse designer must define common business dimensions that will
be used by a data analyst to expand a search.


a. True
b. False 



The correct answer is: False




Question 4

Correct

Mark 1.00 out of 1.00




A database management system (DBMS) must have validation, transformation,
and mapping functions, as well as other functions, in order to be classified as
distributed.


a. True 
b. False



The correct answer is: True




Question 5

Correct

Mark 1.00 out of 1.00




A distributed database management system (DDBMS) governs the storage and
processing of logically related data over interconnected computer systems.


a. True 
b. False



The correct answer is: True




Question 6

Correct

Mark 1.00 out of 1.00




A distributed database management system (DDBMS) must be
communications-media-dependent.


a. True
b. False 



The correct answer is: False


https://mymodules.dtls.unisa.ac.za/mod/quiz/review.php?attempt=13059463&cmid=671105 2/31

,06/09/2023, 10:51 Assessment 3: Attempt review

Question 7

Correct

Mark 1.00 out of 1.00




A document type definition (DID) can be referenced by many Extensible Mark-up
Language (XML) documents of the same type.


a. True 
b. False



The correct answer is: True




Question 8

Correct

Mark 1.00 out of 1.00




A field-level lock allows concurrent transactions to access the same row, as long
as they require the use of different fields within that row.


a. True 
b. False



The correct answer is: True




Question 9

Correct

Mark 1.00 out of 1.00




A full backup, or database dump, produces a complete copy of the entire
database.


a. True 
b. False



The correct answer is: True




Question 10

Correct

Mark 1.00 out of 1.00




A good API makes it easy to develop a program by providing all of the building
blocks.


a. True 
b. False



The correct answer is: True



https://mymodules.dtls.unisa.ac.za/mod/quiz/review.php?attempt=13059463&cmid=671105 3/31

, 06/09/2023, 10:51 Assessment 3: Attempt review

Question 11

Correct

Mark 1.00 out of 1.00




A growing phase in a two-phase lock is when a transaction acquires all the
required locks without locking any data.


a. True
b. False 



The correct answer is: False




Question 12

Correct

Mark 1.00 out of 1.00




A lock guarantees the open use of a data item to multiple transactions.


a. True
b. False 



The correct answer is: False




Question 13

Correct

Mark 1.00 out of 1.00




A passive data dictionary is one that is updated automatically with every
database access to keep its access information up to date.


a. True
b. False 



The correct answer is: False




Question 14

Correct

Mark 1.00 out of 1.00




A plug-in is an external application that is automatically invoked by a web
browser when needed.


a. True 
b. False



The correct answer is: True




https://mymodules.dtls.unisa.ac.za/mod/quiz/review.php?attempt=13059463&cmid=671105 4/31