MEDIA-VIEW COMPUTERS

PRINCIPLES OF DATA BASE MANAGEMENT SYSTEM (CMP206)

[1] Which of the following represents the collection of interrelated data and
a set of programmes to access those data ?
Choice a Database
Choice b Database Management system
Choice c Records
Choice d None of the above
[] Data that is processed and is relevant
Choice a Database
Choice b !nformation
Choice c Data
Choice d "nowledge
[#] $$$$$$%% !a s collection of concept&al tools for describing
data'their relationships'semantics and consistency constraints

Choice a Data Model
Choice b Data
Choice c Data Consistency
Choice d None of the above

[(] $$$ enables &s to represent the real world entities in a form that can
be processed by the comp&ter

Choice a Database )dministrator
Choice b Database Design
Choice c Database Management
Choice d )ll of the above

[*] Which of the following are characteristics of a database management
system?
Choice a )llows the sharing of data between m&ltiple &sers
Choice b +tores the description of the data as well as the data
Choice c +&pports m&ltiple views of the data
Choice d )ll of the above
[,] -he .ang&age that enables the &ser to access or manip&late data is called
/age 1$%
MEDIA-VIEW COMPUTERS
PRINCIPLES OF DATA BASE MANAGEMENT SYSTEM (CMP206)

Choice a Data Defination .ang&age
Choice b Data Manip&lation .ang&age
Choice c Data Description .ang&age
Choice d +ystem .ang&age

[0] -he information stored in the catalog file is called

Choice a Data
Choice b +ystem Data
Choice c MetaData
Choice d Catalog Data

[1] $$$$$ is responsible for recovery from hardware or software
fail&res

Choice a Recovery Management
Choice b -ransaction Management
Choice c +ec&rity Management
Choice d None of the abive

[2] $$$$%% !s an ill&stration of the entire databse content

Choice a /hysical .evel
Choice b Concept&al .evel
Choice c 34ternal .evel
Choice d none of the above

[15] $$$$% !s the ability to change the concept&al schema witho&t
altering the e4ternal scheme or application programs

Choice a /hysical data !ndependence
Choice b .ogical Data !ndependence
Choice c 6oth 17
Choice d None of the above

[11] Data abo&t data is called as$$$$

Choice a MetaData
Choice b !nformation
/age $%
MEDIA-VIEW COMPUTERS
PRINCIPLES OF DATA BASE MANAGEMENT SYSTEM (CMP206)
Choice c +ystem Data
Choice d Data

[1] -he basic goal of database $$$$$$%% !s to ens&re that c&rrent
transactions operate correctly witho&t any loss of database consistency

Choice a +torage Management
Choice b -ransaction Management
Choice c Conc&rrency Control
Choice d .ang&age !nterface

[1#] $$$$% !s the ability to change the internal schema witho&t altering
the concept&al schemes

Choice a /hysical data !ndependence
Choice b .ogical Data !ndependence
Choice c 6oth 17
Choice d None of the above

[1(] $%% demarcates the physical aspects of data storage from the logical
aspects of data representation
Choice a +chema
Choice b Data
Choice c Relationship
Choice d Catalog

[1*] Components of Database +ystem

Choice a 8ardware
Choice b +oftware
Choice c Data
Choice d )ll of the above

[1,] D6) stands for$$%%

Choice a Data 6an9 )ccess
Choice b Database )ccess
Choice c Data 6an9 )dministration
Choice d Database )dministrator
/age #$%
MEDIA-VIEW COMPUTERS
PRINCIPLES OF DATA BASE MANAGEMENT SYSTEM (CMP206)

[10] $$$$%%%is a system database that contains MetaData

Choice a :ile
Choice b Catalog
Choice c Dis9s
Choice d -apes

[11] $$$ is a progarm that provides the interface between the data stored
in the database and the application programs and ;&eries given to the system

Choice a +ec&rity Manager
Choice b +torage Manager
Choice c -ransaction Manager
Choice d None of the above

[12] D6M+ is a general p&rpose software system that facilitates the process
of
Choice a Defining database
Choice b Constr&cting database
Choice c Manip&lating database
Choice d )ll of the above

[5] $$$$ implies that information sho&ld represent the real world
system correctly

Choice a Correctness
Choice b Realistic Representation
Choice c Completeness
Choice d Consistency

[1] $$$%%%is a se;&ence of operations that transforms the database from
one state to the other

Choice a -ransposition
Choice b -ransaction
Choice c +ystem operation
Choice d )ll of the above

/age ($%
MEDIA-VIEW COMPUTERS
PRINCIPLES OF DATA BASE MANAGEMENT SYSTEM (CMP206)
[] $$%%%implies the correctness and acc&racy of data stored in the
database

Choice a !ntegrity
Choice b Red&ndancy
Choice c 34tensibility
Choice d None of the above

[#] $$$$%% !mplies that the representation of the entity m&st be realistic

Choice a Correctness
Choice b Realistic Representation
Choice c Completeness
Choice d Consistency

[(] $$$%% !mplies that the defined entity sho&ld be complete i%e% no
attrib&te sho&ld be missing%

Choice a Correctness
Choice b Realistic Representation
Choice c Completeness
Choice d Consistency

[*] $$$conceals the details of physical storage str&ct&res and stresses
on describing data

Choice a !nternal +chema
Choice b Concept&al +chema
Choice c 34ternal +chema
Choice d )ll of the above

[,] $$$$% !s the individ&al &ser level which presents diverse views of
the apllication to the different &sers

Choice a /hysical .evel
Choice b .ogical .evel
Choice c 34ternal .evel
Choice d )ll of the above

[0] $%%depicts how data is stored physically
/age *$%
MEDIA-VIEW COMPUTERS
PRINCIPLES OF DATA BASE MANAGEMENT SYSTEM (CMP206)

Choice a !nternal +chema
Choice b Concept&al +chema
Choice c 34ternal +chema
Choice d )ll of the above

[1]$$is &sef&l to the &sers as it defines views of the database for
individ&al &sers

Choice a !nternal +chema
Choice b Concept&al +chema
Choice c 34ternal +chema
Choice d )ll of the above

[2] $$$$%%%transaction can be &sed to ma9e changes permanent in the
database

Choice a /ermanent -ransaction
Choice b Roll6ac9 -ransaction
Choice c Commit -ransaction
Choice d None of the above

[#5] $$$%% !mplies that the definition of an entity m&st cover all possible
val&es that it may ta9e

Choice a Correctness
Choice b Realistic Representation
Choice c Completeness
Choice d Consistency


/age ,$%