INF3703 CORE REVIEW ANSWERS AND QUESTIONS
SET A+
✔✔When is the implicit beginning of a transaction? - ✔✔When the first SQL statement
is encountered
✔✔It is one of the three most common data integrity and consistency problems -
✔✔Lost updates
✔✔The ____ manager is responsible for assigning and policing the locks used by the
transactions - ✔✔Lock
✔✔What is a rule that applies to the two-phase locking protocol? - ✔✔Two transactions
cannot have conflicting locks
✔✔This process generally makes of deferred write or deferred update - ✔✔Transaction
recovery procedure
✔✔It only backs up operations that are not reflected in a previous backup copy of the
database - ✔✔Transaction log backup
✔✔All data in a database are stored in ____ files - ✔✔Data
✔✔On the server side, the DBMS environment must be properly configured to respond
to clients requests in the fastest way possible, while making optimum use of existing
resources. The activities required to achieve that goal are commonly referred to as ____
tuning - ✔✔SQL Performance
✔✔The data cache is where the data read from the database data files are stored ____
the data have been read or ____ the data are written to the database data files -
✔✔After, before
, ✔✔The DBMS ____ the SQL query and chooses the most efficient access/execution
plan - ✔✔Parses
✔✔It refers to the number of different values a column could possibly have - ✔✔Data
sparsity
✔✔This process reads the entire table sequentially, thus, it is one of the slowest -
✔✔Table scan
✔✔It uses a set of pre-set rules and points to determine the best approach to execute a
query. The rules assign a fixed cost to each SQL operation - ✔✔A rule-based optimizer
✔✔This type of a cache is useful as a temporary storage for index-creation functions -
✔✔Sort cache
✔✔This term describes the process of database design and implementation -
✔✔Database development
✔✔It describes the general condition in which a company operates - ✔✔Company
situation
✔✔One of the actions performed in database initial study is - ✔✔Define scope and
boundaries
✔✔What impression does it give when a database designer is called in by
management? - ✔✔The database is not performing to expectations
✔✔The primary objective of database design is ____ - ✔✔to create complete,
normalized, non-redundant, and fully integrated conceptual, logical, and physical
database models
✔✔How many phases is the traditional SDLC divided into? - ✔✔Five
✔✔Coding, testing, and debugging are part of which phase in the SDLC -
✔✔Implementation
✔✔"Should the existing system be replaced?" is a question that is asked during the
____ stage of the SDLC - ✔✔Planning
✔✔Creating the conceptual design and selecting DBMS software are part of the ____
phase of the DBLC - ✔✔Database design
SET A+
✔✔When is the implicit beginning of a transaction? - ✔✔When the first SQL statement
is encountered
✔✔It is one of the three most common data integrity and consistency problems -
✔✔Lost updates
✔✔The ____ manager is responsible for assigning and policing the locks used by the
transactions - ✔✔Lock
✔✔What is a rule that applies to the two-phase locking protocol? - ✔✔Two transactions
cannot have conflicting locks
✔✔This process generally makes of deferred write or deferred update - ✔✔Transaction
recovery procedure
✔✔It only backs up operations that are not reflected in a previous backup copy of the
database - ✔✔Transaction log backup
✔✔All data in a database are stored in ____ files - ✔✔Data
✔✔On the server side, the DBMS environment must be properly configured to respond
to clients requests in the fastest way possible, while making optimum use of existing
resources. The activities required to achieve that goal are commonly referred to as ____
tuning - ✔✔SQL Performance
✔✔The data cache is where the data read from the database data files are stored ____
the data have been read or ____ the data are written to the database data files -
✔✔After, before
, ✔✔The DBMS ____ the SQL query and chooses the most efficient access/execution
plan - ✔✔Parses
✔✔It refers to the number of different values a column could possibly have - ✔✔Data
sparsity
✔✔This process reads the entire table sequentially, thus, it is one of the slowest -
✔✔Table scan
✔✔It uses a set of pre-set rules and points to determine the best approach to execute a
query. The rules assign a fixed cost to each SQL operation - ✔✔A rule-based optimizer
✔✔This type of a cache is useful as a temporary storage for index-creation functions -
✔✔Sort cache
✔✔This term describes the process of database design and implementation -
✔✔Database development
✔✔It describes the general condition in which a company operates - ✔✔Company
situation
✔✔One of the actions performed in database initial study is - ✔✔Define scope and
boundaries
✔✔What impression does it give when a database designer is called in by
management? - ✔✔The database is not performing to expectations
✔✔The primary objective of database design is ____ - ✔✔to create complete,
normalized, non-redundant, and fully integrated conceptual, logical, and physical
database models
✔✔How many phases is the traditional SDLC divided into? - ✔✔Five
✔✔Coding, testing, and debugging are part of which phase in the SDLC -
✔✔Implementation
✔✔"Should the existing system be replaced?" is a question that is asked during the
____ stage of the SDLC - ✔✔Planning
✔✔Creating the conceptual design and selecting DBMS software are part of the ____
phase of the DBLC - ✔✔Database design
