Q71. Must you specify columns when inserting?
No, if you provide values for ALL columns in the exact table order. But **best practice**: always specify columns. It prevents errors when schema changes and is self-docu...
Technical Question Bank · Peer-Reviewed
Job Interview Questions and Answers Directory
Search and filter frequently asked interview questions across technical, programming, and behavioral domains. Tailor your interview preparation by difficulty for freshers or experienced developers (119 available).
Active:
Tag: sql ×
Q72. Insert a new record into Customers?
To insert a new record into the `Customers` table, specify the column names followed by the `VALUES` clause: ```sql INSERT INTO Customers (id, first_name, last_name, emai...
Q73. Insert "Hawkins" as LastName in Customers?
To insert a row populating only the `LastName` column: ```sql INSERT INTO Customers (LastName) VALUES ('Hawkins'); ``` *Prerequisite:* This statement succeeds only if all...
Q74. How to create a temporary table in MySQL?
```sql CREATE TEMPORARY TABLE temp_top_customers SELECT * FROM customers WHERE total_spent > 10000; ``` It exists only for the current session/connection and is automatic...
Q75. Which statement updates data?
The **`UPDATE`** statement modifies existing data values in one or more rows of a table: ```sql UPDATE Customers SET email = 'new.email@example.com', updated_at = NOW() W...
Q76. Keyword in UPDATE to change values?
The keyword used in an `UPDATE` statement to specify new values for columns is **`SET`**: ```sql UPDATE employees SET salary = salary * 1.10, title = 'Senior Software Eng...
Q77. Change "Jackson" to "Hawkins" in LastName?
To update all customers with the last name "Jackson" to "Hawkins": ```sql UPDATE Customers SET LastName = 'Hawkins' WHERE LastName = 'Jackson'; ``` ### Production Best Pr...
Q78. Which statement deletes data?
The **`DELETE`** statement removes existing rows from a table based on a condition: ```sql DELETE FROM Customers WHERE is_active = 0 AND last_login < '2023-01-01'; ``` ##...
Q79. Delete records where FirstName is "John"?
To delete all rows where `FirstName` equals "John": ```sql DELETE FROM Customers WHERE FirstName = 'John'; ``` *Safety Warning:* If you accidentally omit `WHERE FirstName...
Q80. What is FROM used for?
The **`FROM`** clause defines the source table(s), views, joined datasets, or subqueries from which rows are read: ```sql SELECT u.username, p.title FROM users u INNER JO...