CIT427 TMA 2 Answers

Q1 Essentially, Objects contain data, and the __ to manipulate that data.

Event

Code

Float

Pointer

Q2 In database servers __ disk arrays are used for stable storage.

BETA

ALPHA

RAID

META

Q3 The __ component of DBMS software is the data query language.

Second

First

Fourth

Thiird

Q4 Generally in DBMS, entity has associated with it a set of __ describing it.

Statements

Methods

Attrinutes

Pointers

Q5 models which describe data at the conceptual and view levels are referred to as __based

logical

models.

Record

Key

Index

Code

Q6 In a relational model, each __ has a number of columns with unique\r\nnames.

File

Table

Component

Line

Q7 The overall design of the database is described as the __.

Database extension

Database system

Database map

Database scheme

Q8 Data at the lowest level are described by means of __ data models.

Stacked

Virtual

Physical

Active

Q9 In the event where the database is structured in fixedformat

records of several types, they are

described as recodbased

logical __.

Databases

Models

Systems

Structure s

Q10 An essential element of the ER

diagram is the __ of cardinalities,

Indexing

Sorting

Mappin g

Filering

Q11 Objectbased

logical models, describe data at the __ and view levels.

Hierarchical

Tabular

Aerial

Conce ptual

Q12 The DBMS maintainS the __ of the database by not allowing more than one user to update\r\nthe

same record at the same time.

Availability

Integrity

Durabilit y

Authentici ty

Q13 Basic runtime

entities in an objectoriented

system are commonly referred to as __.

Events

Classes

Objects

Types

Q14 The acronym DBMS represents the __

Database Management Style

Data Management System

Database Management Sys tem

Database Maintenance System

Q15 Hierarchical database management system stores data in a __ structure.

Tabular

Rotary

Treelike

Relationa l

Q16 The information in a database at a particular point in time is described as the __ of the database.

Class

Event

Instance

Method

Q17 Computers that hold the actual databases and run\r\nonly the database management system and

related software are called __.

Supercomputers

Database servers

Mainframes

System serv ers

Q18 Common forms of database management system can be found as all the following except __.

Objectoriented

Hierarchical

Relational

Formalistic

Q19 The process of requesting attribute information from various perspectives and combinations of

factors is described as __

Searching

Indexing

Querting

Filtering

Q20 __ database management system organises data in tabular files.

Hierarchical

Relational

Holonic

Structur al