INF3703 Assignment solutions 2024

4-Y  This is Databases II – INF3703!  Assessment 1

QUIZ




Started on Friday, 15 March
2024, 9:01 PM
State Finished
Completed on Saturday, 16 March
2024, 6:42 PM
Time taken 21 hours 41 mins
Marks 43.00/50.00
Grade 86.00 out of 100.00


Question 1

Correct

Mark 1.00 out of 1.00




At which phase of the database life cycle
are the process of defining data
important?


a. Database design 
b. Testing and evaluation phase
c. Operation phase
d. Implementation phase




Question 2

Correct

Mark 1.00 out of 1.00




_____ Minimises the number of disk reads
necessary to retrieve a row of data.


a. Column-oriented database
b. Row-centric storage 
c. Column-family database
d. Column-centric storage

,Question 3

Correct

Mark 1.00 out of 1.00




_______is an advanced data definition
language that is used to describe the
structure of XML documents.


a. XSD schema
b. XHTML schema
c. XML schema 
d. XML schema definition




Question 4
Correct

Mark 1.00 out of 1.00




The primary objective of database design
is to______


a. create, normalized non-
redundant conceptual, logical
and physical database model.
b. create, complete, 
normalized, non-redundant
and fully integrated
conceptual, logical and
physical database model.
c. create normalize and redundant
conceptual, logical and physical
database model.
d. create redundant conceptual,
logical and physical database
model




Question 5
Correct

Mark 1.00 out of 1.00




A _________is a symbol that can be used
as a general substitute for other
characters or commands.


a. replacement character
b. substitute character
c. question mark character
d. wildcard character 

, Question 6

Correct

Mark 1.00 out of 1.00




At which stage of the database design
process do designers define database
and query execution parameters?


a. Physical design 
b. DBMS selection design
c. Logical design
d. Conceptual design