COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which SQL statement would add a record to the database?
|
|
INSERT INTO Designer VALUES (’SMI01’, ‘M Smith’, ‘mail@msmith.com’, ‘01224123456’)
|
|
|
INSERT VALUES (’SMI01’, ‘M Smith’, ‘mail@msmith.com’, 01224123456’) INTO Designer
|
|
|
INSERT (’SMI01’, ‘M Smith’, ‘mail@msmith.com’, ‘01224123456’) INTO Designer
|
|
|
INSERT Designer INTO VALUES (”SMI01’, ‘M Smith’, ‘mail@msmith.com’, ‘01224123456’)
|
Explanation:
Detailed explanation-1: -The INSERT INTO statement is used to insert new records in a table.
Detailed explanation-2: -The SELECT statement is used to select data from a database. The data returned is stored in a result table, called the result-set.
Detailed explanation-3: -The INSERT INTO statement of SQL is used to insert a new row in a table.
Detailed explanation-4: -The UPDATE statement is used to modify the existing records in a table.
There is 1 question to complete.