Characteristics of the Database Approach

In traditional file processing, each user defines and implements the files needed for a specific software application as part of programming the application

1 pts

volume_mute

True

False

note_alt Add notes

flag Flag

volume_mute

Correct Answer

Explanation

The main characteristics of the database approach versus the file-processing approach are the following

1 pts

volume_mute

Self-describing nature of a database system

Insulation between programs and data, and data abstraction

Support of multiple views of the data

Sharing of data and multiuser transaction processing

note_alt Add notes

flag Flag

volume_mute

Correct Answer

Explanation

The information stored in the catalog is called ______ and it describes the structure of the primary database

1 pts

volume_mute

Missing

note_alt Add notes

flag Flag

volume_mute

Correct Answer

Explanation

Newer types of database systems, known as NOSQL systems, do not require meta-data

1 pts

volume_mute

True

False

note_alt Add notes

flag Flag

volume_mute

Correct Answer

Explanation

The data in NOSQL systems is stored as self-describing data that includes the data item names and data values together in one structure

1 pts

volume_mute

True

False

note_alt Add notes

flag Flag

volume_mute

Correct Answer

Explanation

A general-purpose DBMS software package is written for a specific database application

1 pts

volume_mute

True

False

note_alt Add notes

flag Flag

volume_mute

Correct Answer

Explanation

The catalog is used by the DBMS software and also by database users who need information about the database structure

1 pts

volume_mute

True

False

note_alt Add notes

flag Flag

volume_mute

Correct Answer

Explanation

A general-purpose DBMS software may not work equally well with different database applications

1 pts

volume_mute

True

False

note_alt Add notes

flag Flag

volume_mute

Correct Answer

Explanation

Traditional file processing approach may entail the risk of changing all programs that access a file if the file structure is changed

1 pts

volume_mute

True

False

note_alt Add notes

flag Flag

volume_mute

Correct Answer

Explanation

The structure of data files is stored in the DBMS catalog separately from the access programs which do not require changing access programs most of the time.

1 pts

volume_mute

Missing

This is called program-data ____________

note_alt Add notes

flag Flag

volume_mute

Correct Answer

Explanation

Which one of these tables is likely to raise changes in its accessing programs?

1 pts

volume_mute

(Table A) Student record structure definition in a traditional file process application

Date Item Name	Starting Position in Record	Length in Characters (bytes)
Name	1	30
Student_Number	31	4
Class	35	1
Major	36	4

(Table B) Student record structure definition in DBMS

Column_Name	Data_type	Belongs_to_Relation
Name	Character(30)	Student
Student_number	Character(4)	Student
Class	Integer(1)	Student
Major	Major_type	Student

Table A

Table B

note_alt Add notes

flag Flag

volume_mute

Correct Answer

Explanation

Examples of database types that allow operations on data as part of the database definitions

1 pts

volume_mute

Object-oriented system

Object-relational system

note_alt Add notes

flag Flag

volume_mute

Correct Answer

Explanation

An operation in an object-oriented database is also called

1 pts

volume_mute

a method

a function

a method or a function

note_alt Add notes

flag Flag

volume_mute

Correct Answer

Explanation

Operation interface

1 pts

volume_mute

In an object-oriented database, an interface (or (1)) of an operation includes the operation name and the data types of its arguments (or parameters).

note_alt Add notes

flag Flag

volume_mute

Correct Answer

Explanation

Operation implementation

1 pts

volume_mute

In object-oriented database, the implementation (or (1)) of the operation is specified separately and can be changed without affecting the interface.

note_alt Add notes

flag Flag

volume_mute

Correct Answer

Explanation

Program-operation independence

1 pts

volume_mute

In object-oriented database, user application programs can operate on the data by invoking these operations through their names and (1), regardless of how the operations are implemented. This may be termed (2).

Please drag and drop the selected option in the right place or type it instead

arguments

program-operation independence

note_alt Add notes

flag Flag

volume_mute

Correct Answer

Explanation

The characteristic that allows program-data independence and program-operation independence is called

1 pts

volume_mute

data normalisation

data minimization

data analysis

data abstraction

note_alt Add notes

flag Flag

volume_mute

Correct Answer

Explanation

A DBMS provides users with ________ representation of data hiding most of the storage and implementation details

1 pts

volume_mute

Missing

note_alt Add notes

flag Flag

volume_mute

Correct Answer

Explanation

A type of data abstraction

1 pts

volume_mute

A _________ model is a type of data abstraction that is used to provide a conceptual representation of data that does not include many of the details of how the data is stored or how the operations are implemented.

data

information

knowledge

object

note_alt Add notes

flag Flag

volume_mute

Correct Answer

Explanation

A data model ________ storage and implementation details

1 pts

volume_mute

hides

shows

note_alt Add notes

flag Flag

volume_mute

Correct Answer

Explanation

A typical database user is concerned with the location of each data item within a record or its length in a database system

1 pts

volume_mute

True

False

note_alt Add notes

flag Flag

volume_mute

Correct Answer

Explanation

In the database approach, the detailed structure and organization of each file are stored in the _________

1 pts

volume_mute

Missing

note_alt Add notes

flag Flag

volume_mute

Correct Answer

Explanation

Only one data model can be used to provide data abstraction to database users

1 pts

volume_mute

True

False

note_alt Add notes

flag Flag

volume_mute

Correct Answer

Explanation

In object-oriented and object-relational databases, the abstraction process includes

1 pts

volume_mute

the data structure

the operations on the data

note_alt Add notes

flag Flag

volume_mute

Correct Answer

Explanation

CALCULATE_GPA operation

1 pts

volume_mute

A user using an object-oriented or object-relational database cares so much about the operation details of the CALCULATE_GPA operation over the STUDENT record

True

False

note_alt Add notes

flag Flag

volume_mute

Correct Answer

Explanation

Database Views

1 pts

volume_mute

A perspective or a (1) may be a (2) of the database or it may contain (3) that is derived from the database files but is not explicitly stored.

Please drag and drop the selected option in the right place or type it instead

view

virtual data

subset

note_alt Add notes

flag Flag

volume_mute

Correct Answer

Explanation

A multiuser DBMS whose users have a variety of distinct applications must provide facilities for defining multiple views

1 pts

volume_mute

True

False

note_alt Add notes

flag Flag

volume_mute

Correct Answer

Explanation

A multiuser DBMS, as its name implies, must allow multiple users to access the database at the same time

1 pts

volume_mute

True

False

note_alt Add notes

flag Flag

volume_mute

Correct Answer

Explanation

Moderating data access

1 pts

volume_mute

The DBMS must include ___________ software to ensure that several users trying to update the same data do so in a controlled manner so that the result of the updates is correct.

concurrency control

redundancy control

capacity control

access control

note_alt Add notes

flag Flag

volume_mute

Correct Answer

Explanation

Seat reservation in an airline flight

1 pts

volume_mute

Several reservation agents try to assign a seat on an airline flight, the DBMS should ensure that each seat can be accessed by _____________ for assignment to a passenger.

maximum two agents at a time

more than one agent at a time

only one agent at a time

note_alt Add notes

flag Flag

volume_mute

Correct Answer

Explanation

OLTP applications

1 pts

volume_mute

Multiuser DBMS software which ensures that concurrent transactions operate correctly and efficiently is generally called

order transaction processing

online transaction processing

omnipresence transaction processing

orchestrating transaction processing

note_alt Add notes

flag Flag

volume_mute

Correct Answer

Explanation

Executing program or process

1 pts

volume_mute

Missing

A _______ is an executing program or process that includes one or more database accesses, such as reading or updating of database records.

note_alt Add notes

flag Flag

volume_mute

Correct Answer

Explanation

The DBMS must enforce several transaction properties including

1 pts

volume_mute

isolation

atomicity

note_alt Add notes

flag Flag

volume_mute

Correct Answer

Explanation

A DBMS property executing a transaction independently and safely

1 pts

volume_mute

Missing

In DBMS, The _________ property ensures that each transaction appears to execute independently from other transactions, even though hundreds of transactions may be executing concurrently.

note_alt Add notes

flag Flag

volume_mute

Correct Answer

Explanation

The ___________ property ensures that either all the database operations in a transaction are executed or none are.

1 pts

volume_mute

Missing

note_alt Add notes

flag Flag

volume_mute