Computer Science
In the given query which keyword has to be inserted ?
INSERT INTO employee ............... (1002, Kausar, 2000) ;
- Table
- Values
- Relation
- Field
DDL & DML
3 Likes
Answer
Values
Reason — The syntax of INSERT INTO command is :
INSERT INTO <tablename> [<column List>]
Values (<value>, <value> ...............) ;
According to this syntax, Values keyword is used to specify the values that will be inserted into the specified columns of the table.
Answered By
3 Likes
Related Questions
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
Consider the following SQL statement. What type of statement is this ?
INSERT INTO instructor VALUES (10211, 'Shreya' , 'Biology', 66000 ) ;- Procedure
- DML
- DCL
- DDL
Which of the following is/are the DDL statements ?
- Create
- Drop
- Alter
- All of these
In SQL, which command(s) is(are) used to change a table's structure / characteristics ?
- ALTER TABLE
- MODIFY TABLE
- CHANGE TABLE
- All of these