Examveda

In the following SQL query, what does "person" stands for?
INSERT INTO person
(person_id, fname, lname) 
VALUES (1,’S’,’P’);

A. Composite attributes

B. Multivalued attributes

C. Table name

D. None of the mentioned

Answer: Option C

Solution (By Examveda Team)

This question is about understanding the basic structure of an SQL query. Let's break down the code:
    `INSERT INTO person` - This part tells the database that we want to insert some data into a table.
    `person` - This is the name of the table where we're adding the data.
    `(person_id, fname, lname)` - These are the names of the columns (like fields in a spreadsheet) within the `person` table.
    `VALUES (1,’S’,’P’);` - These are the values we want to insert into the respective columns.

So, the answer is Option C: Table name.
    `person` represents the table where the data will be inserted.

This Question Belongs to MySQL >> MySQL Miscellaneous

Join The Discussion

Related Questions on MySQL Miscellaneous