Characteristics of the Database Approach

Distinguishing the database approach from the much older approach of writing customized programs to access data stored in files

download Export
search_insights Statistics
stylus_note White Board
Quran
calculate Calculator
dictionary Dictionary
fullscreen Full Screen

QUESTION OF
Views #: 735
Questions #: 35
Time: 15 minutes
Pass Score: 80.0%
Style
Mode

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
note_alt Add notes
flag Flag

Correct Answer

Explanation

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

1 pts
volume_mute
note_alt Add notes
flag Flag

Correct Answer

Explanation

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

1 pts
Missing
note_alt Add notes
flag Flag

Correct Answer

Explanation

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

1 pts
volume_mute
note_alt Add notes
flag Flag

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
note_alt Add notes
flag Flag

Correct Answer

Explanation

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

1 pts
volume_mute
note_alt Add notes
flag Flag

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
note_alt Add notes
flag Flag

Correct Answer

Explanation

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

1 pts
volume_mute
note_alt Add notes
flag Flag

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
note_alt Add notes
flag Flag

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

This is called program-data ____________

Missing
note_alt Add notes
flag Flag

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
note_alt Add notes
flag Flag

Correct Answer

Explanation

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

1 pts
volume_mute
note_alt Add notes
flag Flag

Correct Answer

Explanation

An operation in an object-oriented database is also called

1 pts
volume_mute
note_alt Add notes
flag Flag

Correct Answer

Explanation

Operation interface

1 pts

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

Correct Answer

Explanation

Operation implementation

1 pts

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

Correct Answer

Explanation

Program-operation independence

1 pts

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

Correct Answer

Explanation

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

1 pts
volume_mute
note_alt Add notes
flag Flag

Correct Answer

Explanation

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

1 pts
Missing
note_alt Add notes
flag Flag

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.

note_alt Add notes
flag Flag

Correct Answer

Explanation

A data model ________ storage and implementation details

1 pts
volume_mute
note_alt Add notes
flag Flag

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
note_alt Add notes
flag Flag

Correct Answer

Explanation

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

1 pts
Missing
note_alt Add notes
flag Flag

Correct Answer

Explanation

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

1 pts
volume_mute
note_alt Add notes
flag Flag

Correct Answer

Explanation

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

1 pts
volume_mute
note_alt Add notes
flag Flag

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

note_alt Add notes
flag Flag

Correct Answer

Explanation

Database Views

1 pts

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

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
note_alt Add notes
flag Flag

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
note_alt Add notes
flag Flag

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.

note_alt Add notes
flag Flag

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.

note_alt Add notes
flag Flag

Correct Answer

Explanation

OLTP applications

1 pts
volume_mute

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

note_alt Add notes
flag Flag

Correct Answer

Explanation

Executing program or process

1 pts

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

Missing
note_alt Add notes
flag Flag

Correct Answer

Explanation

The DBMS must enforce several transaction properties including

1 pts
volume_mute
note_alt Add notes
flag Flag

Correct Answer

Explanation

A DBMS property executing a transaction independently and safely

1 pts

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

Missing
note_alt Add notes
flag Flag

Correct Answer

Explanation

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

1 pts
Missing
note_alt Add notes
flag Flag

Correct Answer

Explanation

Keywords
Year 11