INF3703 EXAM PACK 2024/2024
______ 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 - Correct answer-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 - Correct answer-c. Implementation and loading
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 - Correct 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 - Correct 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. - Correct 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 - Correct answer-b. CPU processing power
What differences can be established between a decision support database and an operational
database?
Time span
Granularity
Dimensionality
Provide the benefit of implementing a business intelligence (BI) tool for an organisation
BI is a framework that allows a business to transform
data into information, information into knowledge, and knowledge into wisdom. BI has the potential to
,positively affect a company's culture by creating continuous business performance improvement
through active decision support at all levels in an organization.
Discuss the need for a Hadoop ecosystem and identify its key components.
Most organizations
that use Hadoop also use a set of other related products that interact and complement
each other to produce an entire ecosystem of applications and tools. Like any ecosystem,
the interconnected pieces are constantly evolving and their relationships are changing.
Flume
Pig
Hive
HBase
Define the term Database connectivity.
Database connectivity refers to the mechanisms through which application programs connect and
communicate with data repositories
Describe the type of interfaces used to facilitate communication between database and application.
. A data layer - where the data resides.
2. A middle layer - that manages multiple connectivity and data
3. A top layer - that interfaces with the actual external application.
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 - Correct 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 - Correct 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 - Correct 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 - Correct answer-c. Data fragmentation
The _____ object is the in-memory representation of the data in the database.
a. DataReader
b. DataSet
c. DataAdapter
d. Command - Correct answer-b. DataSet
When setting optimizer hints, _____ instructs the optimizer to minimize the overall execution time, that
is, to minimize the time it takes to return the total number of rows in the query result set. This hint is
generally used for batch mode processes.
______ 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 - Correct answer-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 - Correct answer-c. Implementation and loading
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 - Correct 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 - Correct 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. - Correct 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 - Correct answer-b. CPU processing power
What differences can be established between a decision support database and an operational
database?
Time span
Granularity
Dimensionality
Provide the benefit of implementing a business intelligence (BI) tool for an organisation
BI is a framework that allows a business to transform
data into information, information into knowledge, and knowledge into wisdom. BI has the potential to
,positively affect a company's culture by creating continuous business performance improvement
through active decision support at all levels in an organization.
Discuss the need for a Hadoop ecosystem and identify its key components.
Most organizations
that use Hadoop also use a set of other related products that interact and complement
each other to produce an entire ecosystem of applications and tools. Like any ecosystem,
the interconnected pieces are constantly evolving and their relationships are changing.
Flume
Pig
Hive
HBase
Define the term Database connectivity.
Database connectivity refers to the mechanisms through which application programs connect and
communicate with data repositories
Describe the type of interfaces used to facilitate communication between database and application.
. A data layer - where the data resides.
2. A middle layer - that manages multiple connectivity and data
3. A top layer - that interfaces with the actual external application.
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 - Correct 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 - Correct 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 - Correct 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 - Correct answer-c. Data fragmentation
The _____ object is the in-memory representation of the data in the database.
a. DataReader
b. DataSet
c. DataAdapter
d. Command - Correct answer-b. DataSet
When setting optimizer hints, _____ instructs the optimizer to minimize the overall execution time, that
is, to minimize the time it takes to return the total number of rows in the query result set. This hint is
generally used for batch mode processes.
