DBMS – DATABASE MANAGEMENT SYSTEM FOR ADMINISTRATOR EXAM QUESTIONS WITH CORRECT ANSWERS

DBMS – DATABASE MAGAMENT SYSTEM FOR ADMINISTRATOR EXAM
QUESTIONS WITH CORRECT ANSWERS




File-Based OSystem O- OSOL O-A Ocollection Oof Oapplication Oprograms Othat Operform
Oservices Ofor Othe Oend-users Osuch Oas Othe Oproduction Oof Oreports.


File-Based OSystem O- OSOL O-It Ois Oconsidered Oas Othe Opredecessor Oof Odatabase
Osystem.


File-Based OSystem O- OSOL O-Each Oprogram Odefines Oand Omanages Oits Oown Odata.

File-Based OSystem O- OSOL O-File Osystem Owas Oan Oearly Oattempt Oto Ocomputerize
Othe Omanual Ofiling Osystem.


File-Based OSystem O- OSOL O-File OSystems Omay Ouse Oa Ostorage Odevice Osuch Oas Oa
Ohard Odisk Oor OCD-ROM.


File-Based OSystem O- OSOL O-A Ofile Osystem Ois Oa Omethod Ofor Ostoring Oand
Oorganizing Ocomputer Ofiles Oand Othe Odata Oto Omake Oit Oeasy Oto Ofind Oand Oaccess.


Characteristics Oof OFile OProcessing OSystem O- OSOL O-It Ois Ogroup Oof Ofiles Ostoring
Odata Oof Oan Oorganization.


Characteristics Oof OFile OProcessing OSystem O- OSOL O-Files Oare Odesigned Oby Ousing
Oapplication Oprograms Owritten Oin Oprogramming Olanguages Osuch Oas OCOBOL, OC,
OC++, Oetc....


Characteristics Oof OFile OProcessing OSystem O- OSOL O-Each Ofile Ocontained Oand
Oprocessed Oinformation Ofor Oone Ospecific Ofunction Olike Oaccounting Oor Oinventory.


Characteristics Oof OFile OProcessing OSystem O- OSOL O-Each Ofile Ois Ocalled Oflat Ofile.

Characteristics Oof OFile OProcessing OSystem O- OSOL O-Each Ofile Ois Oindependent Ofrom
Oone Oanother.


Flat Ofile O- OSOL O-A Oflat Ofile Ois Oa Ofile Ocontaining Orecords Othat Ohave Ono Ostructured
Ointerrelationship


Problems: OTraditional Oapproach O- OSOL O-Data OSecurity

Problems: OTraditional Oapproach O- OSOL O-Data ORedundancy

Problems: OTraditional Oapproach O- OSOL O-Data OIsolation

, Problems: OTraditional Oapproach O- OSOL O-Program/ OData ODependence

Problems: OTraditional Oapproach O- OSOL O-Concurrent OAccess OAnomalies

Data OSecurity O- OSOL O-The Odata Oas Omaintained Oin Oflat Ofiles Ois Oeasily Oaccessible
Oand Otherefore Onot Osecure.


Data ORedundancy O- OSOL O-Often Othe Osame Oinformation Ois Oduplicated Oin Otwo Oor
Omore Ofiles.


Data ORedundancy O- OSOL O-It Omay Olead Oto Oinconsistency

Data OIsolation O- OSOL O-Data Oisolation Omeans Othat Oall Othe Orelated Odata Ois Onot
Oavailable Oin Oone Ofile.


Data OIsolation O- OSOL O-Generally, Othe Odata Oscattered Oin Ovarious Ofiles, Oand Othe
Ofiles Omay Obe Oin Odifferent Oformats, Otherefore Owriting Onew Oapplication Oprograms Oto
Oretrieve Othe Oappropriate Odata Ois Odifficult.


Program/ OData ODependence O- OSOL O-Example: OBanking Osystem

Program/ OData ODependence O- OSOL O-Find Oout Othe Ocustomer's Oname, Oaddress O&
Opostal Oarea
Obtain Othe Olist Oof Ocustomers Oand Oextract Othe Oneeded Oinfo OManually.
Or OAsk Oa Osystem Oprogrammer Oto Owrite Othe Onecessary Oapplication Oprogram.

Concurrent OAccess OAnomalies O- OSOL O-Many Osystems Oallow Omultiple Ousers Oto
Oupdate Othe Odata Osimultaneously. OIn Osuch Oenvironment, Ointeraction Oof Oconcurrent
Oupdates Omay Oresult Oin Oinconsistent Odata.


Example: OBank Oaccount O(P10,000)
O
Two Otransactions Oof Owithdraw Ofunds
P500 O& OP1,000

Limitation Oof Othe OFile-Based OApproach O- OSOL O-Separation Oand Oisolation Oof Odata

Limitation Oof Othe OFile-Based OApproach O- OSOL O-Fixed OQueries/Proliferation Oof
Oapplication Oprograms


Limitation Oof Othe OFile-Based OApproach O- OSOL O-Duplication Oof Odata

Limitation Oof Othe OFile-Based OApproach O- OSOL O-Data Odependence

Limitation Oof Othe OFile-Based OApproach O- OSOL O-Incompatible Ofile Oformats