Long Exam #2

Question 1

it is the range of acceptable values than an attribute is capable of having.

Answer 1

Domain of Attributes

Question 2

Those database system which executes on the same operating system and use the same application process and carry the same hardware devices.

Answer 2

Homogeneous Distributed Database system

Question 3

It is used in high-end systems where performance is crucial.

Answer 3

In Memory Database System

Question 4

A database system that accommodates multiple users although the database management system and the database itself are entirely housed on a single machine.

Answer 4

Centralized Database System

Question 5

If we perform any operation over the data, its value before and after the operation should be preserved. This is called _________.

Answer 5

Consistency

Question 6

It is also called relational data model.

Answer 6

Record-Based Data Model

Question 7

It is the attribute which is unique for every entity instance.

Answer 7

Key attribute

Question 8

It is also referred to as passive DBMS

Answer 8

Program-Driven System

Question 9

An entity which doesn’t have any key attribute of its own.

Answer 9

Weak Entity

Question 10

DBMS products can be sold in the form of ________.

Answer 10

Licenses

Question 11

An attribute which can be calculated or derived based on other attributes.

Answer 11

Derived Attribute

Question 12

A database model wherein each entity has only one parent but can have several children.

Answer 12

Hierarchical Databases

Question 13

It supports a large number of transactions concurrently without any delay.

Answer 13

Online Transaction Processing

Question 14

An attribute that can take more than one value for each entity instance.

Answer 14

Multi-Valued Attribute

Question 15

A relationship which one entity can be related to more than one other entity.

Answer 15

One to Many Entity Relationship

Question 16

A person, object or event of importance to the organization.

Answer 16

Entity

Question 17

A type of database where data is stored in a virtual organization.

Answer 17

Cloud Databases

Question 18

Typically become fields in the entity’s database table.

Answer 18

Attributes

Question 19

A type of data repository system wherein DBA is allowed to describe and manage all data.

Answer 19

Stand Alone

Question 20

A database system that supports only one user at a time and are mostly used with personal computers.

Answer 20

Single User Database System

Question 21

It is also referred to as event driven systems

Answer 21

Active DBMS

Question 22

A database system that can have the actual database and DBMS distributed over many sites.

Answer 22

Distributed Database System

Question 23

It defines the physical and logical structure of a database.

Answer 23

Data Model

Question 24

In this system, the size of the database is large which increases the response time for fetching the data.

Answer 24

Centralized Database System

Question 25

In a hierarchical database model, it is the entity at the top of the hierarchy.

Answer 25

Parent

Question 26

It is also called data repository system.

Answer 26

Data Dictionary

Question 27

It is used to markup data so it can be processed by computers

Answer 27

Extensible Markup Language

Question 28

A combination of object oriented data model and semistructured data model

Answer 28

Hybrid Database Model

Question 29

In this model, all entities are regarded as objects

Answer 29

Object oriented database model

Question 30

A database system that supports multi users concurrently.

Answer 30

Multi User Database Model

Question 31

When multiple transactions occur at the same time, one transaction effects should not be visible to the other transactions in the database. this is called ______.

Answer 31

Isolation

Question 32

It is the collection of attribute values.

Answer 32

Tuples

Question 33

Those database system which executes on different operating systems under different application process and carries different hardware devices.

Answer 33

Heterogeneous Distributed Database System

Question 34

A database model in which some entities can be accessed through several paths.

Answer 34

Network Database

Question 35

This ensures the data operation will complete either with success or with failure.

Answer 35

Atomicity