DBMS provides the facility of accessing data from a database through

2016

DBMS provides the facility of accessing data from a database through

Answer: B. DMLAnswer: DML Explanation: A DBMS provides the facility for accessing and manipulating the data through Data Manipulation Language (DML). DML contains the…

  1. A.

    DDL

  2. B.

    DML

  3. C.

    DBA

  4. D.

    Schema

Attempted by 1328 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: Tpsc Assistant Technical Officer

Loading lesson…