INF3703 2024 ASSIGNMENT 1 MCQ
Crystal Indigo!
Crystal Indigo!
Providing all solutions you need anytime
+27 76 626 8187
SOME QUESTIONS MAY BE DIFFERENT OR NOT AVAILABLE IN THIS PDF
, Question1 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 _____ 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 _______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 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 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 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
Crystal Indigo!
Crystal Indigo!
Providing all solutions you need anytime
+27 76 626 8187
SOME QUESTIONS MAY BE DIFFERENT OR NOT AVAILABLE IN THIS PDF
, Question1 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 _____ 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 _______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 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 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 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
