Advertisements
Advertisements
प्रश्न
The command to delete a table is ______
पर्याय
DROP
DELETE
DELETE ALL
ALTER TABLE
Advertisements
उत्तर
The command to delete a table is DROP.
APPEARS IN
संबंधित प्रश्न
Differentiate Unique and Primary Key constraint.
Which component of SQL lets inserts values in tables and which lets to create a table?
What is a constraint?
Write any three DDL commands.
Write the use of the Savepoint command with an example.
Write the different types of constraints and their functions.
Consider the following employee table. Write SQL commands for the question.
| EMP CODE | NAME | DESIG | PAY | ALLO WANCE |
| S1001 | Hariharan | Supervisor | 29000 | 12000 |
| P1002 | Shaji | Operator | 10000 | 5500 |
| P1003 | Prasad | Operator | 12000 | 6500 |
| C1004 | Manjima | Clerk | 8000 | 4500 |
| M1005 | Ratheesh | Mechanic | 20000 | 7000 |
To display the details of all employees in descending order of pay.
Consider the following employee table. Write SQL commands for the question.
| EMP CODE | NAME | DESIG | PAY | ALLO WANCE |
| S1001 | Hariharan | Supervisor | 29000 | 12000 |
| P1002 | Shaji | Operator | 10000 | 5500 |
| P1003 | Prasad | Operator | 12000 | 6500 |
| C1004 | Manjima | Clerk | 8000 | 4500 |
| M1005 | Ratheesh | Mechanic | 20000 | 7000 |
To display the details of all employees who are operators.
Construct the following SQL statement in the student table-
SELECT statement using GROUP BY clause.
Construct the following SQL statement in the student table-
SELECT statement using ORDER BY clause.
