COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which command will execute properly?
|
|
INSERT INTO emp (101, ‘Melissa’, 300);
|
|
|
INSERT INTO emp VALUES (101, Melissa, 300);
|
|
|
INSERT INTO emp VALUES (101, ‘Melissa’, 300);
|
|
|
INSERT INTO emp VALUES (’101’, Melissa, ‘300’);
|
Explanation:
Detailed explanation-1: -Use the INSERT command to enter data into a table.
Detailed explanation-2: -Insert is a widely-used command in the Structured Query Language (SQL) data manipulation language (DML) used by SQL Server and Oracle relational databases. The insert command is used for inserting one or more rows into a database table with specified table column values.
Detailed explanation-3: -You want to change the mobile number to ‘92745612’ of Student ID ‘101’, on the emp table which command will execute correctly? UPDATE emp SET mobile number = ‘92745612’ WHERE student id = ‘101’;
Detailed explanation-4: -Insert command is used to insert data into a table.
There is 1 question to complete.