6 Views

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)

 

 

 

 

 

 


Team Careers360 3rd Jan, 2024
Answer (1)
Team Careers360 23rd Jan, 2024

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

Amity University, Noida Law A...
Apply
700+ Campus placements at top national and global law firms, corporates and judiciaries
Amity University, Noida BBA A...
Apply
Ranked amongst top 3% universities globally (QS Rankings)
VIT Bhopal University | M.Tec...
Apply
M.Tech admissions open @ VIT Bhopal University | Highest CTC 52 LPA | Apply now
Amity University | M.Tech Adm...
Apply
Ranked amongst top 3% universities globally (QS Rankings).
Graphic Era (Deemed to be Uni...
Apply
NAAC A+ Grade | Among top 100 universities of India (NIRF 2024) | 40 crore+ scholarships distributed
Amity University Noida B.Tech...
Apply
Among Top 30 National Universities for Engineering (NIRF 2024) | 30+ Specializations | AI Powered Learning & State-of-the-Art Facilities
View All Application Forms

Download the Careers360 App on your Android phone

Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile

150M+ Students
30,000+ Colleges
500+ Exams
1500+ E-books