Final Exam

Question 1

The first step in the ER model verification process is to ____.

Answer 1

Planning

Question 2

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.

Answer 2

Unrelated

Question 3

The ____ manager is responsible for assigning and policing the locks used by the transactions.

Answer 3

Lock

Question 4

To ensure consistency of the database, every transaction must begin with the database in an unstable state.

Answer 4

False

Question 5

Stored procedures help reduce code duplication by means of code isolation and code sharing.

Answer 5

True

Question 6

When using a(n) ____ join, only rows that meet the given criteria are returned.

Answer 6

Inner

Question 7

When you read from or update a database, you create a transaction.

Answer 7

True

Question 8

The PL/SQL block starts with the ____ clause

Answer 8

Begin

Question 9

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.

Answer 9

True

Question 10

The DBMS guarantees that the semantic meaning of a transaction truly represents the real-world event

Answer 10

False

Question 11

The first step in the DBLC is ____.

Answer 11

Database Initial Study

Question 12

“Should the existing system be replaced?” is a question that is asked during the ____ stage of the SDLC

Answer 12

Planning

Question 13

The optimistic approach is based on the assumption that the majority of the database operations do not conflict.

Answer 13

True

Question 14

The primary objective of database design is ____.

Answer 14

To create complete, normalized, nonredundant, and fully integrated conceptual, logical, and physical database models.

Question 15

One of the major advantages of stored procedures is that they can be used to encapsulate and represent business transactions.

Answer 15

True

Question 16

Systems analysis is used to determine the need for an information system and to establish its limits.

Answer 16

True

Question 17

The ANSI standard defines ____ type(s) of outer join(s)

Answer 17

Three

Question 18

A data warehouse can store data derived from many sources.

Answer 18

True

Question 19

____ data exist in a format that does not lend itself to processing that yields information.

Answer 19

Unstructured

Question 20

Oracle 12c is an example of a(n) ____.

Answer 20

XML/Hybrid data model

Question 21

Accurate, relevant, and timely information is the key to ____.

Answer 21

Qualities of Good Decision Making

Question 22

Metadata present a more complete picture of the data in the database than the data itself.

Answer 22

True

Question 23

Business rules are derived from ____.

Answer 23

A detailed description of an organization’s operations.

Question 24

One of the limitations of the ____ model is that there is a lack of standards.

Answer 24

Hierarchical