Which SQL statement is used to insert new data in a database?
-
INSERT NEW
-
ADD NEW
-
ADD RECORD
-
INSERT INTO
The correct SQL statement for inserting new data is 'INSERT INTO'. This is followed by the table name and VALUES clause. The other options (INSERT NEW, ADD NEW, ADD RECORD) are not valid SQL syntax.
To answer this question, you need to understand SQL statements for inserting new data into a database.
Let's go through each option to understand why it is correct or incorrect:
Option A) INSERT NEW - This option is incorrect because there is no SQL statement called "INSERT NEW" for inserting new data into a database.
Option B) ADD NEW - This option is incorrect because there is no SQL statement called "ADD NEW" for inserting new data into a database.
Option C) ADD RECORD - This option is incorrect because there is no SQL statement called "ADD RECORD" for inserting new data into a database.
Option D) INSERT INTO - This option is correct because the SQL statement "INSERT INTO" is used to insert new data into a database.
The correct answer is D) INSERT INTO. This option is correct because the "INSERT INTO" statement is commonly used in SQL to add new records to a database table.