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
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
