INF3703 ACTUAL TEST PAPER 2026
QUESTIONS WITH SOLUTIONS GRADED A+
COMPLETE ANSWERS BUNDLE
●● Database Management System (DBMS) software and application
programs are installed at which database life-cycle phase?
a. Maintenance and evaluation
b. Database design
c. Implementation and loading
d. Operation.
Answer: c. Implementation and loading
●● UPDATE STUDENT
SET STUD_ASSIGNMENT 2 + 5
WHERE STUDENT_NUMBER = 355-678-0
Would you consider the above SQL code a database transaction? Why?
a. Yes - Because it UPDATE the database
b. Yes - Because it accesses the database
c. Yes - Because it INSERT a record to the database
d. No - Because it is a SELECT statement.
,Answer: a. Yes - Because it UPDATE the database
●● NoSQL database is developed to.
a. Better manage organisation relational data
b. Deal with the challenges of Big-Data
c. Enhance interaction with relational data
d. Deal with problems of NewSQL.
Answer: b. Deal with the challenges of Big-Data
●● Questions such as "what document does the system generate"? "How
does the existing system function"? and "How is the system output
used"? are questions asked at which action of database initial study?
a. Define objective
b. Define scope and boundaries
c. Analyse the company situation.
d. Define problems and constraints..
Answer: d. Define problems and constraints.
●● The performance of a typical DBMS is constrained by three main
factors: _______, available primary memory (RAM), and input/output
(hard disk and network) throughput.
,a. The query language used
b. CPU processing power
c. Disk access speed
d. Available disk space.
Answer: b. CPU processing power
●● The goal of database performance is to ______.
a. Identify bad database performance
b. Send the resulting query to the end-user
c. Execute end-user queries as fast as possible
d. Ensure end-user applications generate queries.
Answer: c. Execute end-user queries as fast as possible
●● SELECT STUD_NUMBER, STUD_MODULE
FROM STUDENT
WHERE STUD_MODULE = INF3703
Would you consider the above SQL code a database transaction? Why?
a. Yes - Because it accesses the database
b. Yes - Because it only update the database
, c. No - Because it only accesses the database
d. No - Because it only update the database.
Answer: a. Yes - Because it accesses the database
●● At which stage of database design process do designers define
fragmentation and allocation strategy?
a. Conceptual design
b. Physical design
c. Logical design
d. In all the stages.
Answer: a. Conceptual design
●● _____ allows you to break a single object into two or more segments
or fragments.
a. Process fragmentation
b. Transaction fragmentation
c. Data fragmentation
d. Performance Fragmentation.
Answer: c. Data fragmentation
QUESTIONS WITH SOLUTIONS GRADED A+
COMPLETE ANSWERS BUNDLE
●● Database Management System (DBMS) software and application
programs are installed at which database life-cycle phase?
a. Maintenance and evaluation
b. Database design
c. Implementation and loading
d. Operation.
Answer: c. Implementation and loading
●● UPDATE STUDENT
SET STUD_ASSIGNMENT 2 + 5
WHERE STUDENT_NUMBER = 355-678-0
Would you consider the above SQL code a database transaction? Why?
a. Yes - Because it UPDATE the database
b. Yes - Because it accesses the database
c. Yes - Because it INSERT a record to the database
d. No - Because it is a SELECT statement.
,Answer: a. Yes - Because it UPDATE the database
●● NoSQL database is developed to.
a. Better manage organisation relational data
b. Deal with the challenges of Big-Data
c. Enhance interaction with relational data
d. Deal with problems of NewSQL.
Answer: b. Deal with the challenges of Big-Data
●● Questions such as "what document does the system generate"? "How
does the existing system function"? and "How is the system output
used"? are questions asked at which action of database initial study?
a. Define objective
b. Define scope and boundaries
c. Analyse the company situation.
d. Define problems and constraints..
Answer: d. Define problems and constraints.
●● The performance of a typical DBMS is constrained by three main
factors: _______, available primary memory (RAM), and input/output
(hard disk and network) throughput.
,a. The query language used
b. CPU processing power
c. Disk access speed
d. Available disk space.
Answer: b. CPU processing power
●● The goal of database performance is to ______.
a. Identify bad database performance
b. Send the resulting query to the end-user
c. Execute end-user queries as fast as possible
d. Ensure end-user applications generate queries.
Answer: c. Execute end-user queries as fast as possible
●● SELECT STUD_NUMBER, STUD_MODULE
FROM STUDENT
WHERE STUD_MODULE = INF3703
Would you consider the above SQL code a database transaction? Why?
a. Yes - Because it accesses the database
b. Yes - Because it only update the database
, c. No - Because it only accesses the database
d. No - Because it only update the database.
Answer: a. Yes - Because it accesses the database
●● At which stage of database design process do designers define
fragmentation and allocation strategy?
a. Conceptual design
b. Physical design
c. Logical design
d. In all the stages.
Answer: a. Conceptual design
●● _____ allows you to break a single object into two or more segments
or fragments.
a. Process fragmentation
b. Transaction fragmentation
c. Data fragmentation
d. Performance Fragmentation.
Answer: c. Data fragmentation
