Advance Database System

Question 1

Process of describing the data, relationships between the data, and the constraints on the data.

Answer 1

Conceptual Database Design

Question 2

Iterative and progressive process of creating a specific data model
for a determined problem domain

Answer 2

Data modeling

Question 3

Simple representations of complex real-world data structures

Answer 3

Data models

Question 4

Abstraction of a real-world object or event

Answer 4

Model

Question 5

focuses on how the database structure will be used to store and manage end-
user data

Answer 5

Database design

Question 6

clearly defined
area within the real-world environment, with a well-defined scope and boundaries that will be
systematically addressed.

Answer 6

problem domain

Question 7

represents a particular type of object in the real world, which means an entity
is “distinguishable”—that is, each entity occurrence is unique and distinct

Answer 7

entity

Question 8

A characteristic of an entity.

Answer 8

attribute

Question 9

describes an association among entities

Answer 9

relationship

Question 10

a restriction placed on the data.

Answer 10

constraint

Question 11

a brief, precise, and unambiguous description
of a policy, procedure, or principle within a specific organization

Answer 11

business rule

Question 12

use data models to communicate with programmers and end
users.

Answer 12

Database designers

Question 13

an abstraction of a complex real-world data environment.

Answer 13

data model

Question 14

used to identify and define the basic modeling
components within a specific real-world environment.

Answer 14

Business rules

Question 15

Raw facts. Not yet been processed to reveal the meaning.

Answer 15

Data

Question 16

Generation, storage, and retrieval of data

Answer 16

Data management

Question 17

Produced by processing data. Reveals the meaning of data.

Answer 17

Information

Question 18

Shared, integrated computer structure that stores a collection of end-user
data and metadata.

Answer 18

Database

Question 19

Raw facts of interest to end user

Answer 19

End-user data

Question 20

Data about data, which the end-user data are integrated and managed.

Answer 20

Metadata

Question 21

Collection of programs. Manages the database
structure.

Answer 21

Database management system (DBMS)

Question 22

Raw facts of interest to end user

Answer 22

End-user data

Question 23

serves as the intermediary between the user and the database.

Answer 23

DBMS

Question 24

Supports one user at a time

Answer 24

Single-user database

Question 25

Supports multiple users at the same time

Answer 25

Multiuser database

Question 26

Data is located at a single site.

Answer 26

Centralized database

Question 27

Data is distributed across different sites.

Answer 27

Distributed database

Question 28

Created and maintained using cloud data services (internet powered), such as Microsoft Azure or Amazon AWS, that provide defined performance measures for the database.

Answer 28

Cloud database

Question 29

Contains a wide variety of data used in multiple disciplines.

Answer 29

General-purpose databases

Question 30

Contains data focused on specific subject areas.

Answer 30

Discipline-specific databases

Question 31

Designed to support a company’s day-to-day operations. It is also known as an online transaction processing (OLTP) database, transactional database, or production database

Answer 31

Operational database

Question 32

Stores historical data and business metrics used exclusively for tactical or strategic decision making.

Answer 32

Analytical database

Question 33

It is a specialized database that stores data in a format optimized for decision support.

Answer 33

Data warehouse

Question 34

It is a set of tools that work together to provide an advanced data analysis environment for retrieving, processing, and modeling data from the data warehouse.

Answer 34

Online analytical processing (OLAP):

Question 35

In recent times, this area of database application has grown in importance and usage, to the point that it has evolved into its own discipline:

Answer 35

Business intelligence

Question 36

It is a data that exists in its original (raw) state—that is, in the format in which it was collected

Answer 36

Unstructured data

Question 37

It is the result of formatting unstructured data to facilitate storage, use, and generation of information.

Answer 37

Structured data

Question 38

refers to the activities that focus on the design of the database structure that will be used to store and manage end-user data.

Answer 38

Database design

Question 39

Raw facts, such as telephone number, birth date, customer name, year-to- date (YTD) sales value.

Answer 39

Data

Question 40

A character or group of characters (alphabetic or numeric) that has a specific meaning

Answer 40

Field

Question 41

A logically connected set of one or more fields that describes a person, place, or thing.

Answer 41

Record

Question 42

A collection of related records.

Answer 42

File

Question 43

This anomaly happens when changes are made to a file with redundant data, and all other related data are not updated properly

Answer 43

Update Anomalies

Question 44

This anomaly happens when inserting vital data into the database is not possible because other data is not already there.

Answer 44

Insert Anomalies

Question 45

This anomaly happens when the deletion of unwanted information causes desired information to be deleted as well.

Answer 45

Delete Anomalies

Question 46

refers to an organization of components that define and regulate the collection, storage, management, and use of data within a database environment.

Answer 46

database system

Question 47

database system five major parts

Answer 47

hardware, software, people, procedures, and data.

Question 48

refers to all of the system’s physical devices.

Answer 48

Hardware.

Question 49

Three types of software

Answer 49

Operating system software DBMS software Application programs and utility software

Question 50

This component includes all users of the database system.

Answer 50

People

Question 51

the instructions and rules that govern the design and use of the database system.

Answer 51

Procedures

Question 52

Stores definitions of the data elements and their relationships

Answer 52

Data dictionary

Question 53

Ensures efficient performance of the database in terms of storage and access speed

Answer 53

Performance tuning

Question 54

Transforms entered data to conform to required data structures

Answer 54

Data transformation and presentation

Question 55

Enforces user security and data privacy.

Answer 55

Security management

Question 56

Sophisticated algorithms ensure that multiple users can access the database concurrently without compromising its integrity

Answer 56

Multiuser access control

Question 57

Enables recovery of the database after a failure

Answer 57

Backup and recovery management

Question 58

Minimizes redundancy and maximizes consistency

Answer 58

Data integrity management

Question 59

Lets the user specify what must be done without having to specify how

Answer 59

Query language

Question 60

De facto query language and data access standard supported by the majority of DBMS vendors

Answer 60

Structured Query Language (SQL)

Question 61

Accept end-user requests via multiple, different network environments

Answer 61

Database communication interfaces