DBMS provides the facility of accessing data from a database through

2016

DBMS provides the facility of accessing data from a database through

  1. A.

    DDL

  2. B.

    DML

  3. C.

    DBA

  4. D.

    Schema

Attempted by 1071 students.

Show answer & explanation

Correct answer: B

Answer: DML

Explanation: A DBMS provides the facility for accessing and manipulating the data through Data Manipulation Language (DML). DML contains the commands used to retrieve and change the data stored in database tables.

  • SELECT: retrieve data (queries).

  • INSERT: add new rows.

  • UPDATE: modify existing rows.

  • DELETE: remove rows.

Why other choices are incorrect:

  • DDL defines and alters the database structure (for example CREATE or DROP TABLE) but does not retrieve or manipulate data.

  • DBA refers to the database administrator role, not to a language or facility for accessing data.

  • Schema describes the organization and structure of the database objects; it is not itself a mechanism to access data.

Tip: To fetch data from a table use a SELECT statement, for example: SELECT * FROM table_name;

A video solution is available for this question — log in and enroll to watch it.

Explore the full course: Mppsc Assistant Professor