Quiz for INSERT

Q1: What does the SQL INSERT statement do?

A. Modifies existing records in a table B. Deletes existing records from a table C. Adds new records into a table D. Changes the table structure

Q2: Which keyword is used to insert data into a specific table in SQL?

A. ADD B. INSERT INTO C. APPEND D. CREATE

Q3: Which of the following is a correct syntax for inserting a row?

A. INSERT (1, "John", 5000) INTO employees; B. INSERT INTO employees VALUES (1, "John", 5000); C. ADD INTO employees (1, "John", 5000); D. INSERT employees VALUES (1, "John", 5000);

Q4: Which clause is optional in an INSERT statement?

A. INTO B. VALUES C. Table Name D. Column List

Q5: What will happen if the number of values does not match the number of columns?

A. The row is inserted anyway B. An error is raised C. Remaining values are set to NULL D. Only matching values are inserted

Q6: How can you insert data into selected columns only?

A. Use SELECT statement instead B. Specify column names in INSERT clause C. Use ALTER TABLE D. It is not possible

Q7: What data type should string values be enclosed in for INSERT?

A. Single quotes B. Double quotes C. No quotes needed D. Backticks

Q8: Which command allows inserting multiple rows in one statement?

A. INSERT MULTI B. INSERT BATCH C. INSERT INTO with multiple VALUES D. INSERT ALL

Q9: Can you insert NULL in a NOT NULL column?

A. Yes, always B. Only if the column is primary key C. Only for foreign keys D. No

Q10: What happens if you try to insert a duplicate value into a PRIMARY KEY column?

A. SQL accepts the value B. The previous value is updated C. An error is thrown D. A warning is issued

Q11: Which keyword is used to insert values using a SELECT statement?

A. FROM B. INSERT SELECT C. INSERT INTO ... SELECT D. VALUES SELECT

Q12: How do you insert default values in all columns?

A. INSERT INTO table; B. INSERT INTO table VALUES (); C. INSERT INTO table DEFAULT; D. INSERT INTO table VALUES (DEFAULT);

Q13: Which of the following is true about INSERT?

A. It can insert into views B. It always requires a WHERE clause C. It deletes existing records D. It modifies existing records

Q14: What is the purpose of DEFAULT keyword in INSERT?

A. To skip columns B. To use default column values C. To ignore constraints D. To remove columns

Q15: Which of the following is valid?

A. INSERT employee VALUES (1, "Raj"); B. INSERT INTO employee (id, name) VALUES (1, "Raj"); C. INSERT VALUES employee (1, "Raj"); D. ADD INTO employee VALUES (1, "Raj");

Q16: What happens if you omit a NOT NULL column while inserting?

A. NULL is inserted B. The column is ignored C. Error occurs D. Default value is inserted

Q17: Which command will insert a record only if it doesn’t already exist?

A. INSERT OR REPLACE B. INSERT IGNORE C. INSERT DISTINCT D. INSERT UNIQUE

Q18: Which of the following supports inserting with RETURNING clause?

A. MySQL 5.6 B. SQL Server 2005 C. PostgreSQL D. SQLite 2.0

Q19: Which of the following is used to insert bulk records in PostgreSQL?

A. BULK INSERT B. INSERT ALL C. COPY D. LOAD DATA

Q20: How do you insert the current timestamp by default?

A. Use NOW() in insert B. Use CURRENT_TIMESTAMP as default C. Use GETDATE() in insert D. Use DATE() in default