Q61. What is the CASE function?
SQL's version of IF-THEN-ELSE. Two forms: simple and searched. ```sql -- Searched CASE (more flexible) SELECT name, CASE WHEN salary >= 100000 THEN 'Executive' WHEN salar...
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 (116 available).
Active:
Tag: dbms ×
Q62. Different types of SQL statements?
DDL (CREATE, ALTER, DROP, TRUNCATE), DML (INSERT, UPDATE, DELETE, SELECT), DQL (SELECT — sometimes grouped with DML), DCL (GRANT, REVOKE), TCL (COMMIT, ROLLBACK, SAVEPOIN...
Q63. Which statements are DDL?
**DDL** stands for **Data Definition Language**. DDL statements define, alter, and destroy database schema structures (tables, indexes, views, schemas, constraints): ### ...
Q64. DML includes?
**DML** stands for **Data Manipulation Language**. DML commands manage, insert, retrieve, and modify actual data rows stored inside database tables: ### Core DML Statemen...
Q65. GRANT and REVOKE are under?
`GRANT` and `REVOKE` belong to **DCL (Data Control Language)**. ### Purpose of DCL: DCL commands manage user security privileges, access rights, and permissions across da...
Q66. Which is NOT a DML statement?
Statements such as **`COMMIT`**, **`ROLLBACK`**, **`CREATE`**, **`ALTER`**, and **`DROP`** are **NOT** DML statements: - `COMMIT` and `ROLLBACK` are **TCL (Transaction Co...
Q67. Which statement inserts new data?
The **`INSERT INTO`** statement is used to add new rows of data into a database table: ```sql INSERT INTO Customers (first_name, last_name, email) VALUES ('John', 'Doe', ...
Q68. 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...
Q69. 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...
Q70. 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...