Which of the following is a DML command in SQL?
Show Hint
DDL changes the structure.
- UPDATE
- CREATE
- ALTER
- DROP
The Correct Option is A
Solution and Explanation
DML (Data Manipulation Language) includes commands that modify data,
like INSERT, UPDATE, DELETE, and SELECT.
UPDATE is used to modify existing records in a table,
so it is a classic DML command.
CREATE and ALTER are DDL (Data Definition Language) commands,
which define or modify database structures like tables.
DROP is also a DDL command used to delete tables or databases.
Therefore, the only DML command here is UPDATE.
Top Questions on SQL
Consider the following relational schema:
Which of the following options is/are correct SQL query/queries to retrieve the names of the students enrolled in course number (i.e., courseno) 1470?- After establishing the connection to fetch the data from the table of a database in SQL into a DataFrame, which of the following function will be used?
(A) pandas.read__sql__query()
(B) pandas.read__sql__table()
(C) pandas.read__sql__query__table()
(D) pandas.read__sql()
- Match List-I with List-II.
List-I List-II (A) SUBSTR() (II) To extract a substring from a string. (B) TRIM() (IV) To remove spaces from both sides of the string. (C) INSTR() (I) To find the position of a substring in a string. (D) LEFT() (III) To extract characters from the left side of the string. Given the following table:
ENO SALARY A101 4000 B109 NULL C508 6000 A305 2000 State the output of the following query:
SELECT COUNT(SALARY) FROM EMPLOYEE;
- State the output of the following query: \[ \text{SELECT ROUND(9873.567,-2);} \]
Questions Asked in CBSE CLASS XII exam
- Three batteries E1, E2, and E3 of emfs and internal resistances (4 V, 2 \(\Omega\)), (2 V, 4 \(\Omega\)) and (6 V, 2 \(\Omega\)) respectively are connected as shown in the figure. Find the values of the currents passing through batteries E1, E2, and E3.
- CBSE CLASS XII - 2025
- Kirchhoff's Laws
- A thin pencil of length \( f/4 \) is placed coinciding with the principal axis of a mirror of focal length \( f \). The image of the pencil is real and enlarged, just touches the pencil. Calculate the magnification produced by the mirror.
- CBSE CLASS XII - 2025
- electrostatic potential and capacitance
- A proton moving with velocity \( V \) in a non-uniform magnetic field traces a path as shown in the figure. The path followed by the proton is always in the plane of the paper. What is the direction of the magnetic field in the region near points P, Q, and R? What can you say about relative magnitude of magnetic fields at these points?
- CBSE CLASS XII - 2025
- Motion of charged particles in a magnetic field
- Assertion (A): In a first order reaction, if the concentration of the reactant is doubled, its half-life is also doubled.
Reason (R): The half-life of a reaction does not depend upon the initial concentration of the reactant in a first order reaction.- CBSE CLASS XII - 2025
- Chemical Kinetics
Rishika and Shivika were partners in a firm sharing profits and losses in the ratio of 3 : 2. Their Balance Sheet as at 31st March, 2024 stood as follows:
Balance Sheet of Rishika and Shivika as at 31st March, 2024Liabilities Amount (₹) Assets Amount (₹) Capitals: Equipment 45,00,000 Rishika – ₹30,00,000
Shivika – ₹20,00,00050,00,000 Investments 5,00,000 Shivika’s Husband’s Loan 5,00,000 Debtors 35,00,000 Creditors 40,00,000 Stock 8,00,000 Cash at Bank 2,00,000 Total 95,00,000 Total 95,00,000 The firm was dissolved on the above date and the following transactions took place:
(i) Equipements were given to creditors in full settlement of their account.
(ii) Investments were sold at a profit of 20% on its book value.
(iii) Full amount was collected from debtors.
(iv) Stock was taken over by Rishika at 50% discount.
(v) Actual expenses of realisation amounted to ₹ 2,00,000 which were paid by the firm. Prepare Realisation Account.- CBSE CLASS XII - 2025
- Dissolution of Partnership Firm