MCQ – This section contains multiple choice questions on SQL Commands with answers and explanation. Many of the objective questions are asked in software jobs written interviews.
Q) Which SQL commands can be used to delete all records from the table in a sql database?
- Delete with where condition
Read difference between delete, truncate and drop sql commands.
Q) SQL Select statement to retrieve unique record from a table is
- SELECT DISTINCT
- SELECT UNIQUE
- SELECT UNION
- SELECT UNION ALL
Q) SQL Command to remove stored procedure SQL
NOTE: Stored procedure in SQL is also called stored function.
Q) Which SQL sub language is used for creating and destroying table structure?
Read detail of DDL and DML commands SQL interview questions