Computer Science
Consider the following SQL statement. What type of statement is this ?
INSERT INTO instructor VALUES (10211, 'Shreya' , 'Biology', 66000 ) ;
- Procedure
- DML
- DCL
- DDL
DDL & DML
2 Likes
Answer
DML
Reason — The above SQL statement is Data Manipulation Language (DML) statement. DML statements are used to access and manipulate data in tables. The DML commands include SELECT, LOCK TABLE, UPDATE, INSERT INTO, DELETE. In this case, the INSERT INTO statement is used to insert a new row of data into the instructor table.
Answered By
1 Like
Related Questions
The data types
CHAR(n)andVARCHAR(n)are used to create ……………, and …………… length types of string/text fields in a database.- Fixed, equal
- Equal, variable
- Fixed, variable
- Variable, equal
A table Table1 has two text fields defined as below :
: Name1 varchar(20), Name2 char(20), :If Name1 stores value as 'Ana' and Name2 stores value as 'Anuj', then Name1 will consume ………….. characters' space and Name2 will consume …………… characters' space.
- 3, 20
- 20, 4
- 20, 20
- 3, 4
In the given query which keyword has to be inserted ?
INSERT INTO employee ............... (1002, Kausar, 2000) ;- Table
- Values
- Relation
- Field
Which of the following is/are the DDL statements ?
- Create
- Drop
- Alter
- All of these