DATABASE - Quiz 1

With the traditional file processing approach, each application shares data files, thus enabling much data sharing.

False

Data redundancy and Data Inconsistency is one of the major drawbacks of: File processing system File retrieval system File storage system File updating system

File processing system

Can store and analyze maps, weather data, and satellite images. Program - data Independence Geographic information systems (G I S) Operation interface Operators and maintenance personnel

Geographic information systems (G I S)

Which of the following is not involved in DBMS? End Users Data Application Request HTML

HTML

Which of the following in not a function of DBA Network Maintenance Schema Definition Authorization for data access Routine Maintenance

Network Maintenance

Which of the following is a navigational data model model? Network Model Object oriented model E-R Model None of these

Network Model

DBMS is a set of __________ to access the data. Codes Programs Information Metadata

Programs

Data Manipulation Language enables users to: Retrieval of information stored in database Insertion of new information into the database Deletion of information from the database All the above

All the above

It is better to use files than a DBMS when there are Stringent real-time requirements Multiple users wish to access the data Complex relationships among data All of the above

Stringent real-time requirements

DBMS manages the interaction between __________ and database. System Analysts Compilers End Users Stake Holders

End Users

Which of the following isn't a level of abstraction? physical logical user view

User

A(n) ____ model is independent of both hardware and software. conceptual external developmental Physical

conceptual

A data warehouse focuses primarily on storing data used to generate information required to make tactical or strategic decisions.

data warehouse

A level that describes data stored in a database and the relationships among the data. physical logical user view

logical

A level that describes how a record is stored. physical logical user view

physical

Data ____ exists when the same data are stored unnecessarily at different places. dependency redundancy inconsistency fragmentation

redundancy

A ......... is used to define overall design of the database schema application program data definition language code

schema

The hierarchical database model is based on a ____. tree structure lack of a parent segment lack of a child segment matrix

tree structure

A data model is a graphical system used to capture the nature and relationships among data. true or false

true

The ______level helps application programs hide the details of data types. physical logical user view

view

A type of data abstraction that is used to provide a conceptual representation Big data Data model Transaction Casual end users

Data model

Snapshot of the data in the database at a given instant of time is called: Database Instance All of the options Database Schema Database Snapshot

Database Instance

Logical design of database is called: All of the options Database Schema Database Instance Database Snapshot

Database Schema

_____ are considered database architects. Database administrators Systems administrators Database designers Systems analysts and programmers

Database designers

Which of the following is not a level of data abstraction? View Level Physical Level Logical Level Critical Level

Critical Level

File processing systems have important limitations Data is separated and isolated Data is often duplicated Application programs are dependent on file format All of the above None of the above

All of the above

The property / properties of a database is / are : It is an integrated collection of logically related records. It consolidates separate files into a common pool of data records. Data stored in a database is independent of the application programs using it All of the above

All of the above

Which of the following is Database Language? Data Definition Language Data Manipulation Language Data Query Language All of the above

All of the above

A Database System is: Collection of data describing one particular enterprise Collection of programs to access data Collection of interrelated data All of the above

All of the above

To allow users to manipulate the information, the system has a number of Application programs Application files Manipulation program Manipulation files

Application programs

A characteristic of an entity. Relation Attribute Parameter Constraint

Attribute

Data independence means Data is defined separately and not included in programs Programs are not dependent on the physical attributes of data. Programs are not dependent on the logical attributes of data Both (B) and (C)

Both (B) and (C)

DBMS helps achieve Data independence Centralized control of data Neither A nor B Both A and B

Both A and B

Data Manipulation Language (DML) is not to Insertion of new information into the Database Modification of information in the Database Create information table in the Database Deletion of information in the Database

Create information table in the Database

Database processing programs: Call the DBMS to access the stored data Cannot be used more than on process Require at least one didacated workstation Present problems with sorage space

Call the DBMS to access the stored data

The restrictions placed on the data. Relation Attribute Parameter Constraint

Constraint

They design and implement the DBMS modules and interfaces as a software package Real - time and active database technology Data warehouses and online analytical processing (0LAP) DBMS system designers and implementors System protection

DBMS system designers and implementors

The actual content in the database at a particular point. Schema Attribute Parameter Instance

Instance

A logical structure of the database. Schema Attribute Parameter Instance

Schema

____ command can be used to modify a column in a table alter update set create

alter