Which of the following is not a DDL command in SQL?
Show Hint
DROP
CREATE
UPDATE
ALTER
The Correct Option is C
Solution and Explanation
UPDATE is a Data Manipulation Language (DML) command used to modify data in existing rows of a table. On the other hand, DROP, CREATE, and ALTER are Data Definition Language (DDL) commands, which are used to define and modify the structure of a database.
Top Questions on Types of Functions
- \(\text{ If the function } f : \mathbb{N} \to \mathbb{N} \text{ is defined as } f(n) = \begin{cases} n - 1, & \text{if } n \text{ is even} \\ n + 1, & \text{if } n \text{ is odd} \end{cases} \text{, then:}\)
(A) f is injective
(B) f is into
(C) f is surjective
(D) f is invertible
Choose the correct answer from the options given below:- CUET (UG) - 2024
- Mathematics
- Types of Functions
Differentiate between 'w' and 'a' file modes in Python.
- CBSE CLASS XII - 2024
- Computer Science
- Types of Functions
- Consider the tables Admin and Transport given below:Table: AdminWrite SQL queries for the following:
\[ \begin{array}{|c|c|c|c|} \hline \textbf{S\_id} & \textbf{S\_name} & \textbf{Address} & \textbf{S\_type} \\ \hline S001 & Sandhya & Rohini & Day Boarder \\ S002 & Vedanshi & Rohtak & Day Scholar \\ S003 & Vibhu & Raj Nagar & NULL \\ S004 & Atharva & Rampur & Day Boarder \\ \hline \end{array} \]
Table: Transport\[ \begin{array}{|c|c|c|} \hline \textbf{S\_id} & \textbf{Bus\_no} & \textbf{Stop\_name} \\ \hline S002 & TSS10 & Sarai Kale Khan \\ S004 & TSS12 & Sainik Vihar \\ S005 & TSS10 & Kamla Nagar \\ \hline \end{array} \]
- Display the student name and their stop name from the tables Admin and Transport.
- Display the number of students whose S_type is not known.
- Display all details of the students whose name starts with 'V'.
- Display student ID and address in alphabetical order of student name, from the table Admin.
- CBSE CLASS XII - 2024
- Computer Science
- Types of Functions
Write a function, c_words(), in Python that separately counts and displays the number of uppercase and lowercase alphabets in a text file, Words.txt
- CBSE CLASS XII - 2024
- Computer Science
- Types of Functions
Ms. Veda created a table named Sports in a MySQL database, containing columns Game_id, P_Age, and G_name.
After creating the table, she realized that the attribute Category has to be added.
Help her to write a command to add the Category column.
Thereafter, write the command to insert the following record in the table: Game_id: G42 P\_Age: Above 18 G_name: Chess Category: Senior- CBSE CLASS XII - 2024
- Computer Science
- Types of Functions
Questions Asked in CBSE CLASS XII exam
- Find the general solution of the differential equation \[ y\log y\,\frac{dx}{dy}+x=\frac{2}{y}. \]
- CBSE CLASS XII - 2026
- Differential Equations
- A square loop of side 0.50 m is placed in a uniform magnetic field of 0.4 T perpendicular to the plane of the loop. The loop is rotated through an angle of 60° in 0.2 s. The value of emf induced in the loop will be:
- CBSE CLASS XII - 2026
- Electromagnetic induction
A racing track is built around an elliptical ground whose equation is given by \[ 9x^2 + 16y^2 = 144 \] The width of the track is \(3\) m as shown. Based on the given information answer the following:
(i) Express \(y\) as a function of \(x\) from the given equation of ellipse.
(ii) Integrate the function obtained in (i) with respect to \(x\).
(iii)(a) Find the area of the region enclosed within the elliptical ground excluding the track using integration.
OR
(iii)(b) Write the coordinates of the points \(P\) and \(Q\) where the outer edge of the track cuts \(x\)-axis and \(y\)-axis in first quadrant and find the area of triangle formed by points \(P,O,Q\).
- CBSE CLASS XII - 2026
- Integration
- Consider a cylindrical conductor of length \( l \) and area of cross-section \( A \). Current \( I \) is maintained in the conductor and electrons drift with velocity \( \vec{v}_d \, (|\vec{v}_d| = \frac{eE}{m} \tau) \), where symbols have their usual meanings. Show that the conductivity of the material of the conductor is given by \[ \sigma = \frac{n e^2 \tau}{m}. \]
- CBSE CLASS XII - 2026
- Current Density
- The painting Hazrat Nizamuddin Auliya and Amir Khusro belongs to which sub-school of Deccan Miniature?
- CBSE CLASS XII - 2026
- Indian Miniature Paintings and Museums