Multiple choice

Which of the following is a valid statement to insert a new record in the doctor table?

  1. Insert into doctor values('Sam','Twain')

  2. Insert ('Sam','Twain') into doctors

  3. Insert values('Sam','Twain') into doctors

  4. Insert doctor values('Sam','Twain')
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The Insert statement in SQL has the following syntax Insert into tablename values(value1,value2,value3....) For example, in a table named Patients which has the following structure.  ||| |---|---| |Column |Datatype| |Patcd|number| |Patname|varchar2(10) | The statement to insert a new record will be Insert into patients values(1,'Sanjay') Make sure that all the VARCHAR and DATE columns are enclosed in a pair of single quotes.

Keep practicing — related questions