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

UPES B.Tech Admissions 2026
Apply
Ranked #43 among Engineering colleges in India by NIRF | Highest Package 1.3 CR , 100% Placements
UPES Integrated LLB Admission...
Apply
Ranked #18 amongst Institutions in India by NIRF | Ranked #1 in India for Academic Reputation by QS Rankings | 16 LPA Highest CTC
Presidency University MBA Adm...
Apply
NAAC A+ Accredited | Highest CTC 10 LPA | Top Recruiters : Amazon, Accenture, KPMG, EY, Capgemini & many more
Nirma University Law Admissio...
Apply
Grade 'A+' accredited by NAAC | Ranked 33rd by NIRF 2025
UPES M.Tech Admissions 2026
Apply
Ranked #45 Among Universities in India by NIRF | 1950+ Students Placed 91% Placement, 800+ Recruiters
UPES | BBA Admissions 2026
Apply
#36 in NIRF, NAAC ‘A’ Grade | 100% Placement, up to 30% meritorious scholarships
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