INF 3703 GOOD EXAM
QUESTIONS AND CORRECT
ANSWERS
______ describe a NoSQL database that stores data in tagged
documents in key- value pairs.
a. Key-Value database
b. Document database
c. Graph database
d. Column-oriented database
b. Document database
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
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
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
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.
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
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
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
, 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
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
c. Data fragmentation
The _____ object is the in-memory representation of the data
in the database.
a. DataReader
b. DataSet
c. DataAdapter
d. Command
b. DataSet
QUESTIONS AND CORRECT
ANSWERS
______ describe a NoSQL database that stores data in tagged
documents in key- value pairs.
a. Key-Value database
b. Document database
c. Graph database
d. Column-oriented database
b. Document database
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
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
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
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.
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
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
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
, 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
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
c. Data fragmentation
The _____ object is the in-memory representation of the data
in the database.
a. DataReader
b. DataSet
c. DataAdapter
d. Command
b. DataSet
