Question :
Which command is used to remove a table from the database in SQL?
Option 1: DELETE TABLE
Option 2: DROP TABLE
Option 3: ERASE TABLE
Option 4: UNATTACH TABLE
Correct Answer: DROP TABLE
Solution : DROP can be used to remove a single table or an entire database. A database, table, index, or view that is already in existence is destroyed by the DROP statement. A relational database management system component can be removed using the SQL DROP statement (RDBMS).
Hence the correct answer is option 2.
Related Questions
Question :
Calculate Operating ratio -
|
Particulars |
Amount |
|
Revenue from Operations |
600000 |
|
Gross profit |
20% |
|
Office Expense |
30000 |
|
Selling Expense |
48000 |
Option 1: 80%
Option 2: 95.33%
Option 3: 85%
Option 4: 93%
Question :
From the Following information what will be the amount of asset purchased during the year?
|
Particulars |
Closing |
Opening |
|
Machinery (At cost) |
690000 |
600000 |
|
Accumulated Depreciation |
90000 |
60000 |
Additional information: During the year a machine coating Rs.50,000 with accumulated depreciation Rs.32,000 was sold for Rs.20,000.
Option 1: Rs.1,40,000
Option 2: Rs.1,20,000
Option 3: Rs.1,65,000
Option 4: None of the above
