DBMS Languages Flashcards
what is a DBMS language
a language used for specifying database schemas
A _________ defines how data is organized within a relational database
Database schema
Name the DBMS languages ?
DDL - Data definition Language
SDL - Storage Definition Languages
VDL - View Definition Language
DML - Data Manipulation Language
describe DDL
DDL allows the user to describe and name the entities, attributes and relationships.
the DDL describes the data in a database
In ______ the storage structure and access methods used by the database system is specified by set of statements
SDL storage definition language
is used to specify user’s views and their
mappings to the conceptual schema.
VDL - view definition language
Describe DML
it provides operations that manipulate data in a database
The part of DML that provides data retrieval is called
Query language
Name the operations that DML provides on a Database
Retrieve data
Insert data
Delete data/ records
Retrieve records sequentially in the key sequence
Retrieve records in the physically recorded sequence
Retrieve records that have been updated
Modify data or record in the database file
_______ helps in communicating with the DBMS.
Data manipulation Language
