Skip to content
Related Articles

Related Articles

Save Article
Improve Article
Save Article
Like Article

UGC-NET | UGC NET CS 2016 Aug – II | Question 16

  • Last Updated : 18 Oct, 2019

DBMS provides the facility of accessing data from a database through
(A) DDL
(B) DML
(C) DBA
(D) Schema


Answer: (B)

Explanation:
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 definition, Storage structure and access-method definition, Schema and physical-organization modification, 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

My Personal Notes arrow_drop_up
Recommended Articles
Page :