INF 3703 CORRECT EXAMS ANSWERS AND
QUESTIONS SET A+
✔✔The primary objective of database design is to.
a. Create, complete, normalized, non-redundant and fully integrated conceptual, logical
and physical database model.
b. Create normalize and redundant conceptual, logical and physical database model.
c. Create, normalized non-redundant conceptual, logical and physical database model.
d. Create redundant conceptual, logical and physical database model - ✔✔a. Create,
complete, normalized, non-redundant and fully integrated conceptual, logical and
physical database model.
✔✔Which component of Business Intelligence (BI) is optimised for decision support and
is generally represented by a data warehouse or a data mart.
a. Data store
b. Data analytics
c. Data query and reporting
d. Data visualisation - ✔✔a. Data store
✔✔Coordinating, monitoring, and allocating database administration resources is
included in a DBA's _____ role
a. Managerial
b. Arbitration
c. Technical
d. Operation - ✔✔a. Managerial
✔✔What does it mean that indexes are physically and logically independent of the data
in the associated table?
a. Indexes are placed on unique field
b. Indexes pointer are created for some the records
,c. Indexes are only used to access a table
d. Indexes require own storage space - ✔✔d. Indexes require own storage space
✔✔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 scope
c. Database design constraints
d. Database objectives - ✔✔b. Database design scope
✔✔A single user database ensures _____ and _____ of the database.
a. Atomicity; Consistency
b. Durability; Serialisability
c. Isolation; Serialisability
d. Consistency; Isolation - ✔✔c. Isolation; Serialisability
✔✔Which of the following is NOT a step performed at the conceptual stage of database
design
a. Data model verification
b. Distributed database design
c. Data analysis and requirements
d. Determine a suitable file organisation - ✔✔d. Determine a suitable file organisation
✔✔The main requirements for a decision support database are.
a. Data extraction and loading; Data manipulation and processing
b. Data storage improvement; Database schema
c. Database schema; Data extraction and loading
d. Data manipulation and processing; Database schema - ✔✔c. Database schema;
Data extraction and loading
✔✔The goal of database performance is to ______.
a. Send the resulting query to the end-user
b. Execute end-user queries as fast as possible
c. Identify bad database performance
d. Ensure end-user applications generate queries - ✔✔d. Ensure end-user applications
generate queries
✔✔Which of the following is not a stage in the database physical design?
,a. Determine a suitable file organisation; Analyse data volume and database usage;
Define users views
b. Define indexes; Determine a suitable file organisation; Determine database security
for users
c. Define users views; Determine database security for users; Analyse distributed
database
d. Determine a suitable file organisation; Define users views; Determine database
security for users - ✔✔c. Define users views; Determine database security for users;
Analyse distributed database
✔✔In the ADO.NET framework, the _____ is a disconnected, memory-resident
representation of the database.
a. Data Adapter
b. Data Reader
c. Command
d. Data Set - ✔✔d. Data Set
✔✔Which security goal is breached when a person gains unauthorized access to a
system and access decision document?
a. Practicality
b. Integrity
c. Confidentiality
d. Availability - ✔✔c. Confidentiality
✔✔Defining data is an important part of which phase of database life circle.
a. Testing and evaluation phase
b. Operation phase
c. Database design
d. Implementation phase - ✔✔c. Database design
✔✔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 design constraints
b. Database design scope
c. Database objectives
d. Database problem - ✔✔b. Database design scope
✔✔When modelling entity relationship, the database designer must.
a. Identify those relations that are similar and combine them.
b. Automatically include all relations.
, c. Create composite diagram.
d. Include all data elements definitions in the data dictionary. - ✔✔d. Include all data
elements definitions in the data dictionary.
✔✔Which database design stage is hardware dependent?
a. Logical design stage
b. Database selection stage
c. Conceptual design stage
d. Physical design stage - ✔✔d. Physical design stage
✔✔______ is the most important technique used in SQL performance optimization.
a. Sparsity
b. Indexes
c. Optimiser hints
d. Statistic - ✔✔b. Indexes
✔✔Database indexes are defined at which stage of physical design stage?
a. Stage 4
b. Stage 3
c. Stage 2
d. Stage 5 - ✔✔a. Stage 4
✔✔At which stage of the design database process do designers define database and
query execution parameters?
a. Conceptual design
b. Physical design
c. DBMS selection design
d. Logical design - ✔✔b. Physical design
✔✔The primary objective of database design is to.
a. Create, complete, normalized, non-redundant and fully integrated conceptual, logical
and physical database model.
b. Create redundant conceptual, logical and physical database model
c. Create, normalized non-redundant conceptual, logical and physical database model.
d. Create normalize and redundant conceptual, logical and physical database model. -
✔✔a. Create, complete, normalized, non-redundant and fully integrated conceptual,
logical and physical database model.
✔✔UPDATE STUDENT
SET STUD_ASSIGNMENT 2 + 5
QUESTIONS SET A+
✔✔The primary objective of database design is to.
a. Create, complete, normalized, non-redundant and fully integrated conceptual, logical
and physical database model.
b. Create normalize and redundant conceptual, logical and physical database model.
c. Create, normalized non-redundant conceptual, logical and physical database model.
d. Create redundant conceptual, logical and physical database model - ✔✔a. Create,
complete, normalized, non-redundant and fully integrated conceptual, logical and
physical database model.
✔✔Which component of Business Intelligence (BI) is optimised for decision support and
is generally represented by a data warehouse or a data mart.
a. Data store
b. Data analytics
c. Data query and reporting
d. Data visualisation - ✔✔a. Data store
✔✔Coordinating, monitoring, and allocating database administration resources is
included in a DBA's _____ role
a. Managerial
b. Arbitration
c. Technical
d. Operation - ✔✔a. Managerial
✔✔What does it mean that indexes are physically and logically independent of the data
in the associated table?
a. Indexes are placed on unique field
b. Indexes pointer are created for some the records
,c. Indexes are only used to access a table
d. Indexes require own storage space - ✔✔d. Indexes require own storage space
✔✔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 scope
c. Database design constraints
d. Database objectives - ✔✔b. Database design scope
✔✔A single user database ensures _____ and _____ of the database.
a. Atomicity; Consistency
b. Durability; Serialisability
c. Isolation; Serialisability
d. Consistency; Isolation - ✔✔c. Isolation; Serialisability
✔✔Which of the following is NOT a step performed at the conceptual stage of database
design
a. Data model verification
b. Distributed database design
c. Data analysis and requirements
d. Determine a suitable file organisation - ✔✔d. Determine a suitable file organisation
✔✔The main requirements for a decision support database are.
a. Data extraction and loading; Data manipulation and processing
b. Data storage improvement; Database schema
c. Database schema; Data extraction and loading
d. Data manipulation and processing; Database schema - ✔✔c. Database schema;
Data extraction and loading
✔✔The goal of database performance is to ______.
a. Send the resulting query to the end-user
b. Execute end-user queries as fast as possible
c. Identify bad database performance
d. Ensure end-user applications generate queries - ✔✔d. Ensure end-user applications
generate queries
✔✔Which of the following is not a stage in the database physical design?
,a. Determine a suitable file organisation; Analyse data volume and database usage;
Define users views
b. Define indexes; Determine a suitable file organisation; Determine database security
for users
c. Define users views; Determine database security for users; Analyse distributed
database
d. Determine a suitable file organisation; Define users views; Determine database
security for users - ✔✔c. Define users views; Determine database security for users;
Analyse distributed database
✔✔In the ADO.NET framework, the _____ is a disconnected, memory-resident
representation of the database.
a. Data Adapter
b. Data Reader
c. Command
d. Data Set - ✔✔d. Data Set
✔✔Which security goal is breached when a person gains unauthorized access to a
system and access decision document?
a. Practicality
b. Integrity
c. Confidentiality
d. Availability - ✔✔c. Confidentiality
✔✔Defining data is an important part of which phase of database life circle.
a. Testing and evaluation phase
b. Operation phase
c. Database design
d. Implementation phase - ✔✔c. Database design
✔✔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 design constraints
b. Database design scope
c. Database objectives
d. Database problem - ✔✔b. Database design scope
✔✔When modelling entity relationship, the database designer must.
a. Identify those relations that are similar and combine them.
b. Automatically include all relations.
, c. Create composite diagram.
d. Include all data elements definitions in the data dictionary. - ✔✔d. Include all data
elements definitions in the data dictionary.
✔✔Which database design stage is hardware dependent?
a. Logical design stage
b. Database selection stage
c. Conceptual design stage
d. Physical design stage - ✔✔d. Physical design stage
✔✔______ is the most important technique used in SQL performance optimization.
a. Sparsity
b. Indexes
c. Optimiser hints
d. Statistic - ✔✔b. Indexes
✔✔Database indexes are defined at which stage of physical design stage?
a. Stage 4
b. Stage 3
c. Stage 2
d. Stage 5 - ✔✔a. Stage 4
✔✔At which stage of the design database process do designers define database and
query execution parameters?
a. Conceptual design
b. Physical design
c. DBMS selection design
d. Logical design - ✔✔b. Physical design
✔✔The primary objective of database design is to.
a. Create, complete, normalized, non-redundant and fully integrated conceptual, logical
and physical database model.
b. Create redundant conceptual, logical and physical database model
c. Create, normalized non-redundant conceptual, logical and physical database model.
d. Create normalize and redundant conceptual, logical and physical database model. -
✔✔a. Create, complete, normalized, non-redundant and fully integrated conceptual,
logical and physical database model.
✔✔UPDATE STUDENT
SET STUD_ASSIGNMENT 2 + 5
