Final Exam Flashcards
(24 cards)
The first step in the ER model verification process is to ____.
Planning
As long as two transactions, T1 and T2, access ____ data, there is no conflict, and the order of execution is irrelevant to the final outcome.
Unrelated
The ____ manager is responsible for assigning and policing the locks used by the transactions.
Lock
To ensure consistency of the database, every transaction must begin with the database in an unstable state.
False
Stored procedures help reduce code duplication by means of code isolation and code sharing.
True
When using a(n) ____ join, only rows that meet the given criteria are returned.
Inner
When you read from or update a database, you create a transaction.
True
The PL/SQL block starts with the ____ clause
Begin
The most useful feature of PL/SQL blocks is that they let you create code that can be named, stored, and executed by the DBMS.
True
The DBMS guarantees that the semantic meaning of a transaction truly represents the real-world event
False
The first step in the DBLC is ____.
Database Initial Study
“Should the existing system be replaced?” is a question that is asked during the ____ stage of the SDLC
Planning
The optimistic approach is based on the assumption that the majority of the database operations do not conflict.
True
The primary objective of database design is ____.
To create complete, normalized, nonredundant, and fully integrated conceptual, logical, and physical database models.
One of the major advantages of stored procedures is that they can be used to encapsulate and represent business transactions.
True
Systems analysis is used to determine the need for an information system and to establish its limits.
True
The ANSI standard defines ____ type(s) of outer join(s)
Three
A data warehouse can store data derived from many sources.
True
____ data exist in a format that does not lend itself to processing that yields information.
Unstructured
Oracle 12c is an example of a(n) ____.
XML/Hybrid data model
Accurate, relevant, and timely information is the key to ____.
Qualities of Good Decision Making
Metadata present a more complete picture of the data in the database than the data itself.
True
Business rules are derived from ____.
A detailed description of an organization’s operations.
One of the limitations of the ____ model is that there is a lack of standards.
Hierarchical
