Question

Write a significance of maintaining order of attribute while inserting values in table

Answer 1

Answer -

____________________________________

• For you to insert rows into a table, the table must be in your own schema or you free space in the table into which you are inserting and maintains referential integrity constraints.

____________________________________

→ Hope it will help you ❣️❣️

Answer 2

Significance of maintaining order of attribute while inserting values in table of database are :

Explanation:

Database is a place where all the information is maintained , either  updated, inserted , deleted and many operation.

It is important to handle the data in the database carefully. Having a better knowledge of SQL queries, and database management knowledge.

Whenever we insert some elements into a database. We need to always mention Table Name , not column name , where we are inserting in SQL query.

To maintain the order attributes while inserting values in database:

query used

insert into "tablename"

(first_colum,...last_colum)

 values (first_val,...last_val);

Example

insert into member

 (firstname , lastname , age, address, city, state)

 values ('Harry', 'shan', 35, '213 hno west ',  

         'Mumbai', 'Maharashtra');

Rule: Strings closed in a single string :

Harry is inserted in the list of member

entry