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
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
Q) Which SQL sub language is used for creating and destroying table structure?