SQL Basic Questions & Answers


What is SQL?
SQL is Structured Query Language. It is the database computer declarative language used for managing data in the relational database management system.

What is RDBMS?
RDBMS is relational database management system. In this data is structured in tables, fields & records. Each table contains database table rows & each row contains one or more database table fields (columns).
e.g. : SQL , Oracle ,MYSQL

What is DBMS?
Database Management System is software package which controls the creation, maintenance & use of the data.

Difference between DBMS & RDBMS

DBMS
RDBMS
1
No relationship Concept.
Relation concept between two database tables.
2
Only one user supported.
Multiple users supported.
3
Data is stored in files.
Data is stored in tables.
4
e.g.: FoxPro ,IMS
SQL ,Oracle

0 comments:

Post a Comment