A database life cycle dblc b information life cycle

a. Database Life Cycle (DBLC).
b. Information Life Cycle (ILC).
c. Systems Life Cycle (SLC).
d. Systems Development Life Cycle (SDLC).
Answer: Database Life Cycle (DBLC).
303. The temporary table space is used………………….?
a. Fr transaction-recovery purposes.
b. To store indexes.
c. As a temporary storage area for merge, sort, or set aggregate operations.

d. To store the data dictionary tables.
Answer: As a temporary storage area for merge, sort, or set aggregate operations.
304. Before you use a new RDBMS, you must complete two tasks: create the database
structure and create ………………………... that will hold the end-user data.
a. Views
b. Indexes
c. Relationship
d. Tables
Answer: Tables
305. A …………………….is any attribute whose value determines other values within a row.
a. Determinant
b. Specialization
c. Granularity
d. Surrogate
Answer: Determinant
306. What is logical design.?
a. operates at the lowest level of abstraction.
b. depicts a specific representation of an internal model, using the database constructs
supported by the chosen database.
c. changes the internal model without affecting the conceptual model.
d. refers to the task of creating a conceptual data model that could be implemented in any
DBMS.
Answer: refers to the task of creating a conceptual data model that could be implemented in
any DBMS.
307. Which database table space is used to store the data dictionary tables?
a. temporary table space.
b. user data table space.
c. system table space.
d. rollback segment table space.

Answer: system table space.
308. Within the type of information classification, query optimisation algorithms can be
termed as?
a. Manual or automatic.
b. Static or dynamic.
c. Logical or physical.
d. Statistically based or rule-based.
Answer: Statistically based or rule-based.
309. What is a natural identifier?
a. a real-world, generally accepted identifier used to distinguish, that is, uniquely identify real-
world objects.
b. a primary key created by the database designer to simplify the identification of entity
instances.
c. occurs when you have one entity in two 1:M relationships to other entities.
d. occurs when a relationship is improperly or incompletely identified and is therefore
represented in a way that is not consistent with the real world.
Answer: a real-world, generally accepted identifier used to distinguish, that is, uniquely
identify real-world objects.
310. DBLC stands for...?
a. Data Building Life Cycle.
b. Design Base Life Cycle.
c. Database Life Cycle.
d. Drawback Life Cycle.
Answer: Database Life Cycle.
311. The main goal of normalization is to eliminate data anomalies by eliminating
unnecessary or unwanted data redundancies, this is achieved by using which concept?
a. Entity integrity
b. Aggregation
c. Denormalization

d. Functional dependency.
Answer: Functional dependency
312. Which of the following is a prevalent characteristics of cloud computing services?