Database - Introduction to SQL - Discussion

Discussion :: Introduction to SQL - General Questions (Q.No.1)

1. 

You can add a row using SQL in a database with which of the following?

[A]. ADD
[B]. CREATE
[C]. INSERT
[D]. MAKE

Answer: Option C

Explanation:

No answer description available for this question.

Nithya said: (Oct 20, 2010)  
We can add rows using Insert keyword only.

Ankur said: (Nov 26, 2010)  
Insert into <table_name> values("&name",&age);

Ritu Singh said: (Dec 9, 2010)  
Create is a command to create a new table.

Navee said: (Mar 2, 2011)  
Insert is the only keyword to add a row in a table.

Piyush said: (Mar 16, 2011)  
Insert command can be used to easily add the complete row.

Aysha said: (Mar 25, 2011)  
Insert is the keyword to add all values into the table

Sangita said: (Aug 4, 2011)  
Insert into<table name> values(001,'rupali');

Saidareddy said: (Sep 17, 2011)  
Insert command is only add a row in a table.

Rani said: (Oct 2, 2011)  
Insert is the command used to add rows in a table.

Ahmed said: (Oct 5, 2011)  
Query:

Insert into <table_name>[(column names)] values(value1,value2,....);

In case of character input values must be written within single quotes.

Manche Shekhar said: (Nov 3, 2011)  
We can add a new row into table using insert command..

We can insert a row into table in two ways:
1)implicit insertion
2)explicit insertion

Shariff said: (Nov 11, 2011)  
What is implicit & explicit insertion?

Manche Shekhar said: (Nov 15, 2011)  
In implicit insertion we insert specific field values:
The syntax is:
insert into <tablename>(list of columns) values(list of values);

In explicit insertion we insert all field values:
The syntax is:
insert into <tablename>values(list of values);

Timir said: (Dec 24, 2011)  
Example of inserting a row as follows:

INSERT INTO table_name VALUES ('FOR STRINGS',FOR NUMERIC VALUES);

Srinivas said: (Jan 17, 2012)  
Insert into <table_name> values("&ColumnName1","&ColumnName2");

Kani said: (Jan 20, 2012)  
It's a keyword.

Raj said: (Feb 9, 2012)  
Insert command is only add a row in a table.

M G Balaji said: (Jun 2, 2012)  
Insert is a keyword in order to add the new row.

Vijayns said: (Jun 28, 2012)  
Add any row in a database by using INSERT key word accessing values by using & symbol it address the values of rows.

Naidu said: (Aug 30, 2012)  
We can add values into table using insert keyword.
ex:create table emp(name varchar2(20),age number(20)));
it will create emp table and now insert values into this table using fallowing insert query syntax:
insert into <tablename> values('if string or date',number);

Ex:insert into emp values('nani',25);

Deependera said: (Dec 1, 2012)  
We can use insert command to insert data in a table.

Syntax:
INSERT INTO <TABLE NAME> (FIELD1,FILED2,FIELD3) VALUES (VALUE1,VALUE2,VALUE3);

EXAMPLE:
INSERT INTO student(stu_id,name,total) values(101,'Jitu',120);

Aniley Belayneh said: (Dec 3, 2012)  
The INSERT INTO statement is used to insert a new row in a table.
SQL INSERT INTO Syntax

It is possible to write the INSERT INTO statement in two forms.

The first form doesn't specify the column names where the data will be inserted, only their values:
1.INSERT INTO table_name
VALUES (value1, value2, value3,...)
2.The second form specifies both the column names and the values to be inserted:
INSERT INTO table_name (column1, column2, column3,...)
VALUES (value1, value2, value3,...)

Kitty said: (Aug 13, 2013)  
We can add a row using the key word of insert.

Vanesha said: (Jul 12, 2014)  
The correct answer is insert keyword only because this keyword is add new row.

Prasanth said: (Mar 25, 2015)  
Yes, absolutely. I will use insert keyword to insert a row in a table. No options.

Mahesh Karbhal said: (Apr 28, 2015)  
INSERT command is use for inserting row in a table.

Prasu said: (Jun 30, 2015)  
Insert command is used insert new values into table.

Mounika Pallapu said: (Oct 27, 2015)  
INSERT is a keyword it is used for ADD the values to the table.

Bhavya said: (Oct 28, 2015)  
Insert command is used to add/create the row in the table.

INSERT into TABLE -NAME values('value1','value2','value3');

Pawan Kumar said: (Mar 9, 2016)  
If change the serial of value like (value1', ' value3', ' value2) ; then variable will execute or not?

Pawan Kumar said: (Mar 9, 2016)  
What is use of add and make?

Sacdiyo Nuur Maxamuud said: (Mar 26, 2016)  
You can add a row using INSERT keyword.

Haddad said: (Apr 3, 2016)  
The "insert" is the only keyword to add rows into table

insert into ( table_name ) values ( 'value1' , 'value2' , ...);

If the value is number don't put the quotes .

Mk Kashyap said: (Jul 7, 2016)  
INSERT is only keyword to add a row in database/table.

Suchithra said: (Oct 20, 2016)  
You can add a row using INSERT keyword.

Vramakrishna said: (Dec 7, 2016)  
Insert into <table_name>[(column names)] values(value1,value2,....); .

Kanimozhi said: (Dec 26, 2016)  
INSERT is for putting in a fresh record to a table.

Ajin_K said: (Jul 14, 2017)  
Queries explanation:

1] ADD : It is used to add the column in already created table using alter keyword.
ex. alter table table_name ADD (column_name data_type(size));

2] CREATE: it is used to create the new table .
ex. CREATE table table_name (column_name data_type(size) );

3] INSERT: it is used to insert the row values into the already created table.
ex. INSERT into table_name values (1 ,'XYZ', ....)
or INSERT into table_name values(&column1, '&column2()',.....);

Saikiran said: (Jul 20, 2018)  
"How to insert values into a table"?

Dksiva said: (Dec 1, 2019)  
insert into T.N values(1,2,3,4,5,....etc)

Murali Chavadi said: (Jul 5, 2020)  
insert into TABLENAME into VALUES(col1,col2,....);

Post your comments here:

Name *:

Email   : (optional)

» Your comments will be displayed only after manual approval.