Question : Identify the correct INSERT queries from the following :
(a) INSERT INTO Persons(‘xxx1’, ‘yyy1’);
(b) INSERT INTO Persons(LastName, FirstName) Values (‘xxx’, ‘yyy’);
(c) INSERT INTO Persons Values(‘xxx1’ , ‘yyy1’);
(d) INSERT INTO Persons Value(‘xxx1’ , ‘yyy1’);
Option 1: (a) & (b)
Option 2: (b) & (c)
Option 3: (a),(c) & (d)
Option 4: (a) & (d)
Correct Answer: (b) & (c)
Solution : Insert is a frequently used command in relational databases SQL Server and Oracle's Structured Query Language (SQL) data manipulation language (DML). The insert command is used to add one or more rows with certain table column values to a database table.
It is possible to write the INSERT INTO statement in two ways: 1. Specify both the column names and the values to be inserted: INSERT INTO table_name (column1, column2, column3, ...)
Hence the Correct answer is option 2.
Related Questions
Trending Articles/News
