INF3703 final exam with questions and valid answers
Explain the DATABASE INITIAL STUDY PHASE of the DBLS - ANSWER;1. Analyze
the company situation
2. Define the problems and constraints
3. Define the objectives
4. Define the scope and boundaries
Name the roles associated with a DBA in a technical role - ANSWER;1. Evaluate, select
and install the DBMS
2. Design and implement DB and APPS
3. Testing and evaluating DB and APPS
4. Training and support user
5. Maintain the DBMS, DB and APPS
Briefly explain the conceptual design phase of the DB design process - ANSWER;1.
Data analysis and requirements
2. Entity relationship modelling and normalization
3. Data model verification
4. Distributed database design
Name the steps required in the development of ER diagrams. - ANSWER;1. Identify,
analyze and refine the business rules
2. Identify the main entities.
3. Define the relationships among the entities.
4. Define the attributes, PK and FKs
5. Normalize the entities
Explain the flow of phases in a query. - ANSWER;1. Parsing phase
DBMS parses the SQL query and chooses the
most efficient execution plan
2. Execution phase
The DBMS execute the SQL query using the
execution plan
3. Fetching phase
The DBMS fetches the data and sends the
result set back to the client
Name all the transaction properties - ANSWER;1. Atomicity
, 2. Consistency
3. Isolation
4. Reliability
5. Serializability
What is concurrency control and why is it necessary. - ANSWER;It allows the
simultaneous execution of transactions in a multi-user database system.
Its objective is to yield consistent results
Name and explain 3 additional issues when designing DDBMS - ANSWER;1. Data
Fragmentation
2. Data replication
3. Data Allocation
Data Security, privacy and integrity are important functions in authorization
management. Name 7 activities that a DBA should do in his role as management. -
ANSWER;1. Assign users to the DB
2. Assign each user a password
3. Define user groups
4. Define user views
5. Control physical access to the network
6. Control access to the DBMS
7. Monitor DBMS usage
Identify the critical success factors in the development and implementation of a
successful data system. - ANSWER;1. Management commitment
2. Thorough company situation analysis
3. End-User involvement
4. Defined Standards
5. Training
6. Start with a small pilot project
Discuss the difference between the top down and bottom up strategies. - ANSWER;The
TOP DOWN strategy involves identifying the data sets first, then identifying the data
elements for those sets.
The BOTTOM UP strategy involves identifying the data elements first, then grouping
them together in data sets.
What is cloud computing and how does it relate to cloud services. - ANSWER;1. Cloud
computing refers to the delivering of applications, storage and other resources to users
over the web.
Explain the DATABASE INITIAL STUDY PHASE of the DBLS - ANSWER;1. Analyze
the company situation
2. Define the problems and constraints
3. Define the objectives
4. Define the scope and boundaries
Name the roles associated with a DBA in a technical role - ANSWER;1. Evaluate, select
and install the DBMS
2. Design and implement DB and APPS
3. Testing and evaluating DB and APPS
4. Training and support user
5. Maintain the DBMS, DB and APPS
Briefly explain the conceptual design phase of the DB design process - ANSWER;1.
Data analysis and requirements
2. Entity relationship modelling and normalization
3. Data model verification
4. Distributed database design
Name the steps required in the development of ER diagrams. - ANSWER;1. Identify,
analyze and refine the business rules
2. Identify the main entities.
3. Define the relationships among the entities.
4. Define the attributes, PK and FKs
5. Normalize the entities
Explain the flow of phases in a query. - ANSWER;1. Parsing phase
DBMS parses the SQL query and chooses the
most efficient execution plan
2. Execution phase
The DBMS execute the SQL query using the
execution plan
3. Fetching phase
The DBMS fetches the data and sends the
result set back to the client
Name all the transaction properties - ANSWER;1. Atomicity
, 2. Consistency
3. Isolation
4. Reliability
5. Serializability
What is concurrency control and why is it necessary. - ANSWER;It allows the
simultaneous execution of transactions in a multi-user database system.
Its objective is to yield consistent results
Name and explain 3 additional issues when designing DDBMS - ANSWER;1. Data
Fragmentation
2. Data replication
3. Data Allocation
Data Security, privacy and integrity are important functions in authorization
management. Name 7 activities that a DBA should do in his role as management. -
ANSWER;1. Assign users to the DB
2. Assign each user a password
3. Define user groups
4. Define user views
5. Control physical access to the network
6. Control access to the DBMS
7. Monitor DBMS usage
Identify the critical success factors in the development and implementation of a
successful data system. - ANSWER;1. Management commitment
2. Thorough company situation analysis
3. End-User involvement
4. Defined Standards
5. Training
6. Start with a small pilot project
Discuss the difference between the top down and bottom up strategies. - ANSWER;The
TOP DOWN strategy involves identifying the data sets first, then identifying the data
elements for those sets.
The BOTTOM UP strategy involves identifying the data elements first, then grouping
them together in data sets.
What is cloud computing and how does it relate to cloud services. - ANSWER;1. Cloud
computing refers to the delivering of applications, storage and other resources to users
over the web.
