INF3703 ANSWERS AND QUESTIONS SET A+
✔✔Several DBMS packages contain features that allow the creation of a(n)____, which
automatically records a brief description of the database operations performed by all
users - ✔✔Audit log
✔✔_______ has been enhanced with extensions that support OLAP type processing
and data generation - ✔✔DBMS
✔✔Data stored in the company database must be protected from access by
unauthorized users. Data measures include all of the following EXCEPT.... - ✔✔Top
down authentication
✔✔The following is NOT a factor that influences the choice of database design
strategies - ✔✔The company's market knowledge
✔✔What describes the extent to which modules are independent of one another? -
✔✔Module coupling
✔✔What are the three main types of indexes? - ✔✔Primary, Secondary, and Multi-level
index
✔✔The ____ lock allows concurrent transactions to access the same row as long as
they require the use of different fields within that row - ✔✔Field-level
✔✔The following are the deadlock control techniques - ✔✔Prevention, detection and
avoidance
✔✔Concurrency control with optimistic methods moves through which phases? -
✔✔Validation, write and read
✔✔_____________design is the process of selecting the data storage and data access
characteristics of the database - ✔✔Physical
, ✔✔In the ________________ stage, data modeling is used to create an abstract
database structure that represents real-world objects in the most realistic way possible -
✔✔Conceptual design
✔✔What is the first step in converting the ER model from the conceptual design phase
into a set of relations? - ✔✔Create Relations for Strong Entities
✔✔A ______ is often used on multidimensional data held in data warehouses -
✔✔Bitmap index
✔✔In the following relation, what is the primary key?
RENT_LINE (RENT_NUM*, RENT_LINE_NUM*, RENT_LINE_CHARGE,
DATE,COPY_CODE*) - ✔✔RENT_NUM and RENT_LINE_NUM
✔✔______ is a brief and precise narrative description of a policy, procedure or principle
within a specific organization's environment - ✔✔Business rule
✔✔Indexes should NOT be used when_______ - ✔✔Tables have low sparsity
✔✔If several concurrent transactions are executed over the same data set and the
second transaction updates the database before the first transaction is finished, the
____ property is violated and the database is no longer consistent - ✔✔Durability
✔✔When a program is abnormally terminated, the equivalent of a ____ command
occurs - ✔✔ROLLBACK
✔✔In _____ backup of the database, only the best modifications to the database are
copied - ✔✔Differential
✔✔All lock information is managed by a ____, which is responsible for assigning and
policing the locks used by the transactions - ✔✔Lock manager
✔✔What is considered in a database initial study regarding the organization's operating
environment and mission? - ✔✔Company situation analysis
✔✔______ is/are provided by the DBMS to check for access violations - ✔✔Audit trails
✔✔The DBA's _______ role is focused on personnel management and on interactions
with the end-user community - ✔✔managerial
✔✔Several DBMS packages contain features that allow the creation of a(n)____, which
automatically records a brief description of the database operations performed by all
users - ✔✔Audit log
✔✔_______ has been enhanced with extensions that support OLAP type processing
and data generation - ✔✔DBMS
✔✔Data stored in the company database must be protected from access by
unauthorized users. Data measures include all of the following EXCEPT.... - ✔✔Top
down authentication
✔✔The following is NOT a factor that influences the choice of database design
strategies - ✔✔The company's market knowledge
✔✔What describes the extent to which modules are independent of one another? -
✔✔Module coupling
✔✔What are the three main types of indexes? - ✔✔Primary, Secondary, and Multi-level
index
✔✔The ____ lock allows concurrent transactions to access the same row as long as
they require the use of different fields within that row - ✔✔Field-level
✔✔The following are the deadlock control techniques - ✔✔Prevention, detection and
avoidance
✔✔Concurrency control with optimistic methods moves through which phases? -
✔✔Validation, write and read
✔✔_____________design is the process of selecting the data storage and data access
characteristics of the database - ✔✔Physical
, ✔✔In the ________________ stage, data modeling is used to create an abstract
database structure that represents real-world objects in the most realistic way possible -
✔✔Conceptual design
✔✔What is the first step in converting the ER model from the conceptual design phase
into a set of relations? - ✔✔Create Relations for Strong Entities
✔✔A ______ is often used on multidimensional data held in data warehouses -
✔✔Bitmap index
✔✔In the following relation, what is the primary key?
RENT_LINE (RENT_NUM*, RENT_LINE_NUM*, RENT_LINE_CHARGE,
DATE,COPY_CODE*) - ✔✔RENT_NUM and RENT_LINE_NUM
✔✔______ is a brief and precise narrative description of a policy, procedure or principle
within a specific organization's environment - ✔✔Business rule
✔✔Indexes should NOT be used when_______ - ✔✔Tables have low sparsity
✔✔If several concurrent transactions are executed over the same data set and the
second transaction updates the database before the first transaction is finished, the
____ property is violated and the database is no longer consistent - ✔✔Durability
✔✔When a program is abnormally terminated, the equivalent of a ____ command
occurs - ✔✔ROLLBACK
✔✔In _____ backup of the database, only the best modifications to the database are
copied - ✔✔Differential
✔✔All lock information is managed by a ____, which is responsible for assigning and
policing the locks used by the transactions - ✔✔Lock manager
✔✔What is considered in a database initial study regarding the organization's operating
environment and mission? - ✔✔Company situation analysis
✔✔______ is/are provided by the DBMS to check for access violations - ✔✔Audit trails
✔✔The DBA's _______ role is focused on personnel management and on interactions
with the end-user community - ✔✔managerial
