UGC-NET | UGC NET CS 2016 Aug – II | Question 16
DBMS provides the facility of accessing data from a database through
1- DML stands for data manipulation language. The SQL commands that deals with the manipulation of data present in the database belong to DML or Data Manipulation Language including retrieving, storing, modification, deletion, insertion and updation of data in a database. Examples of DML: SELECT, INSERT, UPDATE, DELETE.
2- DDL – Data Definition Language – This commands in SQL includes the creation, deletion and modification of structure of database objects. Examples of DDL commands: CREATE, DROP, ALTER, TRUNCATE, COMMENT, RENAME. It provides the facility of accessing data from a database.
3- Functions of a DBA include: Schema deﬁnition, Storage structure and access-method deﬁnition, Schema and physical-organization modiﬁcation, Granting of authorization for data access, Routine maintenance.
4- Schema: The term “schema” refers to the organization of data as a blueprint of how the database is constructed (divided into database tables in the case of relational databases). The formal definition of a database schema is a set of formulas (sentences) called integrity constraints imposed on a database.
So, option (A) is correct.
Quiz of this Question