Question

CLASS 10
DATABASE MANAGEMENT SYSTEM
Answer the following questions.
1. How do you delete the entire table using an SQL query? Assume the name of the table to be PROBLEMS.
2. Write an SQL query to pick numbers from the field Number, display the Number in a column and its square in the
next column. The name of table is TO-BE-SQUARED.​

Answer 1

1. DELETE * FROM PROBLEMS

2. SELECT Numbers, Numbers*Numbers FROM TO-BE-SQAURED