INF 3703 COMPREHENSIVE ANSWERS AND
QUESTIONS SET A+
✔✔Trojan horses are also small pieces of software that replicate themselves using any
form oftelecommunication networks or hole in security
True/false - ✔✔false
✔✔User ........ is a way of identifying the user and verifying that the user is allowed to
accessrestricted data or applications. This can be achieved through the use of
passwords and access rights:
a. Authentication
b. Authorization
c. Identification
d. Details - ✔✔a. Authentication
✔✔..... can be used to render data useless to unauthorised users who might have
violated some of the database security layers or security measures
a. Audit Trails
b. Security measures
c. Data encryption
d. Encryption algorithm - ✔✔c. Data encryption
✔✔Firewalls use one or more of three methods to control messages flowing in and out
of the organisations network, which of the following is NOT part of the methods used:
a. Packet filtering
b. Proxy server
c. Diskless workstation
d. Anti Virus software - ✔✔d. Anti Virus software
,✔✔Top-down design first identifies the data elements (items), then groups them
together in datasets.
T/F - ✔✔False
✔✔Centralized design is productive when the data component is composed of a
relatively small number of objects and procedures
T/F - ✔✔True
✔✔The person responsible for the control of the centralized and shared database is the
database administrator.
T/F - ✔✔True
✔✔Aggregation process requires the designer to create a single model in which various
aggregation problems must be addressed. Which of the following does not form part of
the problems to be addressed?
a. Entity and entity subtypes
b. Processes and constraints
c. Conflicting object definition
d. Synonyms and homonyms - ✔✔b. Processes and constraints
✔✔What is the data administrator also known as
a. System administrator
b. Information resource manager
c. Information system manager
d. Database administrator - ✔✔b. Information resource manager
✔✔Policies are written instructions that describe a series of steps to be followed during
the performance of a given activity
T/F - ✔✔False
✔✔A.... Backup, also known as a database dump, produces a complete copy of the
entire database
a. Incremental
b. Half
c. Concurrent
d. Full - ✔✔d. Full
,✔✔What are the most important security goals database designers should meet?
a. Integrity; Confidentiality; Availability
b. Availability; Integrity; Accuracy
c. Confidentiality; Accuracy; Integrity
d. Accuracy; Confidentiality; Availability - ✔✔a. Integrity; Confidentiality; Availability
✔✔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. CPU processing power
b. The query language used
c. Available disk space
d. Disk access speed - ✔✔a. CPU processing power
✔✔Having knowledge of ______ helps database designer define the required data
structures, types and number of entities as well as the physical size of the database
a. Database problem
b. Database design constraints
c. Database design scope
d. Database objectives - ✔✔c. Database design scope
✔✔The primary objective of database design is to.
a. Create, normalized non-redundant conceptual, logical and physical database model.
b. Create normalize and redundant conceptual, logical and physical database model.
c. Create complete normalized, nonredundant and fully integrated conceptual, logical
and physical db
d. Create redundant conceptual, logical and physical database model - ✔✔c. Create
complete normalized, nonredundant and fully integrated conceptual, logical and
physical db
✔✔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 scope and boundaries
b. Analyse the company situation
c. Define objective
d. Define problems and constraints - ✔✔d. Define problems and constraints
✔✔Which database design stage is hardware dependent?
a. Physical design stage
, b. Conceptual design stage
c. Logical design stage
d. Database selection stage - ✔✔a. Physical design stage
✔✔A single user database ensures _____ and _____ of the database.
a. Durability; Serialisability
b. Isolation; Serialisability
c. Consistency; Isolation
d. Atomicity; Consistency - ✔✔b. Isolation; Serialisability
✔✔NoSQL database is developed to
a. Deal with the challenges of Big-Data
b. Deal with problems of NewSQL
c. Enhance interaction with relational data
d. Better manage organisation relational data - ✔✔a. Deal with the challenges of Big-
Data
✔✔The process of _____ takes preselected data fields from a number of sources.
a. Data loading
b. Data optimization
c. Data extraction
d. Data manipulation - ✔✔c. Data extraction
✔✔_____ and _____ of transaction are guaranteed by the single-user database
management system?
a. Consistency; Atomicity
b. Atomicity; Durability
c. Isolation; Durability
d. Durability; Consistency - ✔✔b. Atomicity; Durability
✔✔Coordinating, monitoring, and allocating database administration resources is
included in a DBA's _____ role.
a. Operation
b. Managerial
c. Arbitration
d. Technical - ✔✔b. Managerial
✔✔______ describe a NoSQL database that stores data in tagged documents in key-
value pairs.
QUESTIONS SET A+
✔✔Trojan horses are also small pieces of software that replicate themselves using any
form oftelecommunication networks or hole in security
True/false - ✔✔false
✔✔User ........ is a way of identifying the user and verifying that the user is allowed to
accessrestricted data or applications. This can be achieved through the use of
passwords and access rights:
a. Authentication
b. Authorization
c. Identification
d. Details - ✔✔a. Authentication
✔✔..... can be used to render data useless to unauthorised users who might have
violated some of the database security layers or security measures
a. Audit Trails
b. Security measures
c. Data encryption
d. Encryption algorithm - ✔✔c. Data encryption
✔✔Firewalls use one or more of three methods to control messages flowing in and out
of the organisations network, which of the following is NOT part of the methods used:
a. Packet filtering
b. Proxy server
c. Diskless workstation
d. Anti Virus software - ✔✔d. Anti Virus software
,✔✔Top-down design first identifies the data elements (items), then groups them
together in datasets.
T/F - ✔✔False
✔✔Centralized design is productive when the data component is composed of a
relatively small number of objects and procedures
T/F - ✔✔True
✔✔The person responsible for the control of the centralized and shared database is the
database administrator.
T/F - ✔✔True
✔✔Aggregation process requires the designer to create a single model in which various
aggregation problems must be addressed. Which of the following does not form part of
the problems to be addressed?
a. Entity and entity subtypes
b. Processes and constraints
c. Conflicting object definition
d. Synonyms and homonyms - ✔✔b. Processes and constraints
✔✔What is the data administrator also known as
a. System administrator
b. Information resource manager
c. Information system manager
d. Database administrator - ✔✔b. Information resource manager
✔✔Policies are written instructions that describe a series of steps to be followed during
the performance of a given activity
T/F - ✔✔False
✔✔A.... Backup, also known as a database dump, produces a complete copy of the
entire database
a. Incremental
b. Half
c. Concurrent
d. Full - ✔✔d. Full
,✔✔What are the most important security goals database designers should meet?
a. Integrity; Confidentiality; Availability
b. Availability; Integrity; Accuracy
c. Confidentiality; Accuracy; Integrity
d. Accuracy; Confidentiality; Availability - ✔✔a. Integrity; Confidentiality; Availability
✔✔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. CPU processing power
b. The query language used
c. Available disk space
d. Disk access speed - ✔✔a. CPU processing power
✔✔Having knowledge of ______ helps database designer define the required data
structures, types and number of entities as well as the physical size of the database
a. Database problem
b. Database design constraints
c. Database design scope
d. Database objectives - ✔✔c. Database design scope
✔✔The primary objective of database design is to.
a. Create, normalized non-redundant conceptual, logical and physical database model.
b. Create normalize and redundant conceptual, logical and physical database model.
c. Create complete normalized, nonredundant and fully integrated conceptual, logical
and physical db
d. Create redundant conceptual, logical and physical database model - ✔✔c. Create
complete normalized, nonredundant and fully integrated conceptual, logical and
physical db
✔✔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 scope and boundaries
b. Analyse the company situation
c. Define objective
d. Define problems and constraints - ✔✔d. Define problems and constraints
✔✔Which database design stage is hardware dependent?
a. Physical design stage
, b. Conceptual design stage
c. Logical design stage
d. Database selection stage - ✔✔a. Physical design stage
✔✔A single user database ensures _____ and _____ of the database.
a. Durability; Serialisability
b. Isolation; Serialisability
c. Consistency; Isolation
d. Atomicity; Consistency - ✔✔b. Isolation; Serialisability
✔✔NoSQL database is developed to
a. Deal with the challenges of Big-Data
b. Deal with problems of NewSQL
c. Enhance interaction with relational data
d. Better manage organisation relational data - ✔✔a. Deal with the challenges of Big-
Data
✔✔The process of _____ takes preselected data fields from a number of sources.
a. Data loading
b. Data optimization
c. Data extraction
d. Data manipulation - ✔✔c. Data extraction
✔✔_____ and _____ of transaction are guaranteed by the single-user database
management system?
a. Consistency; Atomicity
b. Atomicity; Durability
c. Isolation; Durability
d. Durability; Consistency - ✔✔b. Atomicity; Durability
✔✔Coordinating, monitoring, and allocating database administration resources is
included in a DBA's _____ role.
a. Operation
b. Managerial
c. Arbitration
d. Technical - ✔✔b. Managerial
✔✔______ describe a NoSQL database that stores data in tagged documents in key-
value pairs.
