SQL Insert
1.What is the purpose of the INSERT statement?
-
A. To remove data
-
B. To add data into a table
-
C. To change table name
-
D. To update values
To add data into a table
To add data into a table
2.Which is the correct basic syntax to insert values?
-
A. INSERT INTO table VALUES (val1, val2);
-
B. ADD INTO table (val1, val2);
-
C. PUT INTO table VALUES (val1, val2);
-
D. INSERT table val1, val2;
INSERT INTO table VALUES (val1, val2);
INSERT INTO table VALUES (val1, val2);
3.What happens if you skip a NOT NULL column in INSERT?
-
A. Null value is accepted
-
B. Default is inserted
-
C. Error is thrown
-
D. Data is ignored
Error is thrown
Error is thrown
4.Which command inserts data only into selected columns?
-
A. INSERT table VALUES (..);
-
B. INSERT INTO table SET col=value;
-
C. INSERT INTO table(col1, col2) VALUES(val1, val2);
-
D. None
INSERT INTO table(col1, col2) VALUES(val1, val2);
INSERT INTO table(col1, col2) VALUES(val1, val2);
5.Which clause can be used in PostgreSQL to avoid inserting duplicate records?
-
A. IGNORE
-
B. ON CONFLICT DO NOTHING
-
C. SKIP
-
D. CHECK
ON CONFLICT DO NOTHING
ON CONFLICT DO NOTHING