MCQ IN COMPUTER SCIENCE & ENGINEERING

COMPUTER SCIENCE AND ENGINEERING

SQL

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]

Which statement allows us to add a record to a table?

A	Add To
B	Update To
C	Add Into
D	Insert Into

Explanation:

Detailed explanation-1: -The SQL INSERT statement is used to insert a one or more records into a table.

Detailed explanation-2: -The INSERT INTO statement of SQL is used to insert a new row in a table.

Detailed explanation-3: -To insert records into a table, enter the key words insert into followed by the table name, followed by an open parenthesis, followed by a list of column names separated by commas, followed by a closing parenthesis, followed by the keyword values, followed by the list of values enclosed in parenthesis.

Detailed explanation-4: -The ALTER TABLE statement is used to add, delete, or modify columns in an existing table. The ALTER TABLE statement is also used to add and drop various constraints on an existing table.

There is 1 question to complete.