INF 3703 EVALUATION TEST ANSWERS AND
QUESTIONS SET A+
✔✔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.
[1] Atomicity
[2] Consistency
[3] Durability
[4] Isolation - ✔✔[4] Isolation
✔✔... has been enhanced with extensions that support OLAP type processing and data
generation.
[1] SQL
[2] DBMS
[3] DBLC
[4] SDLC. - ✔✔[1] SQL
✔✔Non- volatile data, which of the options below is considered to have a data
environment that is relatively static?
a. Operational database
b. Data warehouse
c. Data Processor - ✔✔b. Data warehouse
✔✔____ is a measurement of the density of the data held in the data cube.
A. Compactness
B. Concentration
C. Mass
D. Sparsity - ✔✔D. Sparsity
,✔✔____ are numeric measurements or values that represent a specific business aspect
or activity.
A. Tables
B. Schemas
C. Facts
D. Attributes - ✔✔C. Facts
✔✔When you ____ the data, you are aggregating the data to a higher level.
A. drill down
B. drill up
C. wrap up
D. roll up - ✔✔D. roll up
✔✔In most modern relational DBMSs, such as IBM DB2, Microsoft SQL Server, and
Oracle, a new database implementation requires the creation of special storage-related
constructs to house the end-user tables. These constructs include ____.
A. segments
B. constraints
C. indexes
D. table spaces - ✔✔D. table spaces
✔✔____ design is the process of selecting the data storage and data access
characteristics of the database.
A. Time
B. Network
C. Logical
D. Physical - ✔✔D. Physical
✔✔In the ________________ stage, data modelling is used to create an abstract
database structure that represents real-world objects in the most realistic way possible.
A. physical design
B. ER verification
C. conceptual design
D. logical design - ✔✔C. conceptual design
✔✔Data warehouse contains historical data over long time horizon
True
False - ✔✔True
, ✔✔Steps in developing the conceptual model include:
A. identifying the main business rules
B. identifying the main entities
C. identifying all relationships
D. all of the above - ✔✔D. all of the above
✔✔The aim of ________________ is to map the conceptual model into a form which
can then be implemented on a relational DBMS.
A. physical design
B. ER verification
C. conceptual design
D. logical design - ✔✔D. logical design
✔✔What is the first step in converting the ER model from the conceptual design phase
into a set of relations?
A. Create Relations for Strong Entities
B. Map multivalued attributes
C. Create Relations for Weak Entities
D. Map binary relations - ✔✔A. Create Relations for Strong Entities
✔✔___________________ requires the definition of specific storage or access
methods that will be used by the database.
A. logical design
B. conceptual design
C. Translation of logical relations into tables
D. physical design - ✔✔D. physical design
✔✔Selecting the most suitable _________________ is very important to ensure that the
data is stored efficiently and data can be retrieved as quickly as possible.
A. DBMS
B. file organization
C. indexes
D. logical relations - ✔✔B. file organization
✔✔Clustering is not a good idea when_______________________
A. database tables are frequently joined together
B. data is regular inserted or updated in a table
C. there is no cluster key
QUESTIONS SET A+
✔✔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.
[1] Atomicity
[2] Consistency
[3] Durability
[4] Isolation - ✔✔[4] Isolation
✔✔... has been enhanced with extensions that support OLAP type processing and data
generation.
[1] SQL
[2] DBMS
[3] DBLC
[4] SDLC. - ✔✔[1] SQL
✔✔Non- volatile data, which of the options below is considered to have a data
environment that is relatively static?
a. Operational database
b. Data warehouse
c. Data Processor - ✔✔b. Data warehouse
✔✔____ is a measurement of the density of the data held in the data cube.
A. Compactness
B. Concentration
C. Mass
D. Sparsity - ✔✔D. Sparsity
,✔✔____ are numeric measurements or values that represent a specific business aspect
or activity.
A. Tables
B. Schemas
C. Facts
D. Attributes - ✔✔C. Facts
✔✔When you ____ the data, you are aggregating the data to a higher level.
A. drill down
B. drill up
C. wrap up
D. roll up - ✔✔D. roll up
✔✔In most modern relational DBMSs, such as IBM DB2, Microsoft SQL Server, and
Oracle, a new database implementation requires the creation of special storage-related
constructs to house the end-user tables. These constructs include ____.
A. segments
B. constraints
C. indexes
D. table spaces - ✔✔D. table spaces
✔✔____ design is the process of selecting the data storage and data access
characteristics of the database.
A. Time
B. Network
C. Logical
D. Physical - ✔✔D. Physical
✔✔In the ________________ stage, data modelling is used to create an abstract
database structure that represents real-world objects in the most realistic way possible.
A. physical design
B. ER verification
C. conceptual design
D. logical design - ✔✔C. conceptual design
✔✔Data warehouse contains historical data over long time horizon
True
False - ✔✔True
, ✔✔Steps in developing the conceptual model include:
A. identifying the main business rules
B. identifying the main entities
C. identifying all relationships
D. all of the above - ✔✔D. all of the above
✔✔The aim of ________________ is to map the conceptual model into a form which
can then be implemented on a relational DBMS.
A. physical design
B. ER verification
C. conceptual design
D. logical design - ✔✔D. logical design
✔✔What is the first step in converting the ER model from the conceptual design phase
into a set of relations?
A. Create Relations for Strong Entities
B. Map multivalued attributes
C. Create Relations for Weak Entities
D. Map binary relations - ✔✔A. Create Relations for Strong Entities
✔✔___________________ requires the definition of specific storage or access
methods that will be used by the database.
A. logical design
B. conceptual design
C. Translation of logical relations into tables
D. physical design - ✔✔D. physical design
✔✔Selecting the most suitable _________________ is very important to ensure that the
data is stored efficiently and data can be retrieved as quickly as possible.
A. DBMS
B. file organization
C. indexes
D. logical relations - ✔✔B. file organization
✔✔Clustering is not a good idea when_______________________
A. database tables are frequently joined together
B. data is regular inserted or updated in a table
C. there is no cluster key
