DBMS – DATABASE MANAGEMENT SYSTEM FOR ADMINISTRATOR RATIONALE WITH WELL EXPLAINATION SQL.

DBMS – DATABASE MANAGEMENT SYSTEM FOR ADMINISTRATOR RATIONALE
WITH WELL EXPLAINATION SQL




What Ois Oa Odatabase Omanagement Osystem? O- OSOL O-a Oprogram Ocontrolling Othe
Ostructure Oof Oa Odatabase Oand Oaccess Oto Othe Odata; Ocreates, Oprocesses, Oand
Oadministers Odatabase


What Oare Osome Oadvantages Oof Oa ODBMS? O- OSOL O--reduced Odata Oredundancy
-improved Odata Ointegrity
-more Oprogram Oindependence
-increased Ouser Oproductivity
-increased Osecurity

What Ois ODBMS Oused Ofor? O- OSOL O-to Ocreate Otables Oand Orelationships Oin
Odatabases


What Odo Oapplications Ouse ODBMS Ofor? O- OSOL O-to Oread, Oinsert, Omodify, Oand
Odelete Odata


What Ois Oa Ostructured Oquery Olanguage O(SQL)? O- OSOL O-SQL Ois Oan Ointernational
Ostandard Olanguage Ofor Omanipulating Orelational Odatabases


What Odo OSQL Oqueries Oconsist Oof? O- OSOL O-an Oaction, Odatabase Otable Oname, Oset
Oof Oparameters


What Oare OSQL Okeywords? O- OSOL O-they Oissue Oinstructions
-create, Odelete, Oinsert, Oetc.

What Oare Oboo Olean Ooperators? O- OSOL O-AND, OOR, ONOT Ofor Osearching

What Oare Oglobal Oupdates? O- OSOL O-based Oon Osome Ocriteria

What Oare Ojoining Otables? O- OSOL O-creating Orelationship

What Oare Osome Othings Othat Ogo Ointo Oselecting Oa ODBMS? O- OSOL O-database Osize
number Oof Oconcurrent Ousers
performance
integration
features