2024 INF3703 Assignment 1 solutions

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