Which of the following is the correct expanded form of DML?
Which of the following is the correct expanded form of DML?
Show Hint
- Device Management Language
- Device Manipulation Language
- Data Management Language
- Data Manipulation Language
The Correct Option is D
Solution and Explanation
DML is a group of SQL commands. The letters D, M and L stand for Data, Manipulation and Language.
Step 2: Know what these commands do:
DML commands work on the data stored inside tables.
They add, change, remove or read rows.
The common ones are INSERT, UPDATE, DELETE and SELECT.
Step 3: Check each option:
Option 1 (Device Management Language) is not an SQL term.
Option 2 (Device Manipulation Language) is not an SQL term either.
Option 3 (Data Management Language) uses a wrong middle word. The standard term is Manipulation.
Option 4 (Data Manipulation Language) is the correct full form.
Final Answer:
DML stands for Data Manipulation Language. This is option 4.
Top CBSE CLASS XII Informatics Practices Questions
State whether the following statement is True or False:
In Pandas Series, the Positional index can be a string or an integer.
We can add a new row to a DataFrame
DFusing the ______ method.Naveen discarded various types of waste material without realizing that e-waste contains harmful substances that could pollute the environment. He wants to know which of the following will be considered as e-waste?
In which scenario is a bar chart preferred over a line chart?
Which of the following network topology uses a central cable (backbone) to connect all devices?
Top CBSE CLASS XII SQL Queries Questions
Define the following terms with respect to RDBMS:
a. Domain
b. Tuple
(i) Write an SQL statement to create a table named PRODUCTS with the following specifications:
Column Name Data Type Key PID Integer Primary Key PName Varchar of size 30 PCat Char of size 15 Price Decimal Number (ii) Write an SQL query to increase the price of all items by 100, whose product category is Grocery, in the table PRODUCTS.
Consider the table LIBRARY as given below.
BookId Title Genre Price 101 Python Basics Technology 278 201 The Silent Patient Fiction 340 301 Data Science Technology 291 401 Oceans Marine Life NULL (I) Which attribute(s) can be considered as the Candidate keys(s)? Justify your answer.
(II) Write an SQL query to insert a new record with the following values: BookId: 501, Title: AI for ALL, Genre: Technology, Price: 589
(III) Write an SQL query to add a new column Author that is a character data type of size 20.
Top CBSE CLASS XII Questions
- 2, b, c are in A.P. and the range of determinant $\begin{vmatrix}1&1&1\\ 2&b&c\\ 4&b^{2}&c^{2}\end{vmatrix}$ is [2, 16]. Then find range of c is
- A boy of mass 50 kg is standing at one end of a, boat of length 9 m and mass 400 kg. He runs to the other, end. The distance through which the centre of mass of the boat boy system moves is
- A capillary tube of radius r is dipped inside a large vessel of water. The mass of water raised above water level is M. If the radius of capillary is doubled, the mass of water inside capillary will be
- A circular disc is rotating about its own axis. An external opposing torque 0.02 Nm is applied on the disc by which it comes rest in 5 seconds. The initial angular momentum of disc is
- A circular disc is rotating about its own axis at uniform angular velocity \(\omega.\) The disc is subjected to uniform angular retardation by which its angular velocity is decreased to \(\frac {\omega}{2}\) during 120 rotations. The number of rotations further made by it before coming to rest is