DBMS provides the facility of accessing data from a database through
2016
DBMS provides the facility of accessing data from a database through
- A.
DDL
- B.
DML
- C.
DBA
- 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.