MCQ IN COMPUTER SCIENCE & ENGINEERING

Previous
Next

COMPUTER SCIENCE AND ENGINEERING

SQL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Use what to insert multiple values to a table?INSERT INTO TABLE ____ NAME (column1, column2, column3, ____ columnN) VALUES (value1, value2, value3, ____ valueN) ____ (value1, value2, value3, ____ valueN);
A
commas
B
periods
C
spaces
D
semicolons
Explanation: 

Detailed explanation-1: -If you want to add data to your SQL table, then you can use the INSERT statement. Here is the basic syntax for adding rows to your SQL table: INSERT INTO table name (column1, column2, column3, etc) VALUES (value1, value2, value3, etc); The second line of code is where you will add the values for the rows.

Detailed explanation-2: -INSERT-SELECT-UNION query to insert multiple records Thus, we can use INSERT-SELECT-UNION query to insert data into multiple rows of the table. The SQL UNION query helps to select all the data that has been enclosed by the SELECT query through the INSERT statement.

Detailed explanation-3: -The INSERT statement also allows you to insert multiple rows into a table using a single statement as the following: INSERT INTO table name(column1, column2…) VALUES (value1, value2, …), (value1, value2, …), … In this form, you need to provide multiple lists of values, each list is separated by a comma.

There is 1 question to complete.
Previous
Next