Question
Which of the following SQL queries is used to remove a
table from a database?Solution
The DROP statement is used to permanently remove a table from the database. When a table is dropped, the table structure, along with its data, is deleted, and it cannot be recovered. a) DELETE : DELETE is used to remove rows from a table, not the table structure itself. c) TRUNCATE : TRUNCATE removes all rows from a table but retains the table structure. d) ALTER : ALTER is used to modify the structure of an existing table, not remove it. e) REMOVE : REMOVE is not a valid SQL command.
Marked price of an article is Rs.320 more than its cost price. If profit earned is equal to the discount given then find the profit earned?
- A merchant marked a product 30% above its cost price. If he sold the product at a 20% discount, what is the merchant's gain percentage?
A shopkeeper marked an article P% above its cost price and sold it for Rs. 748.8 after giving a discount of 20%. If the shopkeeper had a loss of 6.4% on...
A shopkeeper bought two articles for Rs. 200 each. If he sold one of them at 40% profit and the other at 25% loss, then find the difference between the ...
Item ‘X’ had a cost price of Rs. 800 and it was marked up by 25%. It was later sold after giving a discount of Rs. 40. Another item ‘Y’ was sold...
What will be the cost price of an Wheat bag if a shopkeeper initially marked it 75% above the cost price and then offered two successive discounts of 20...
If the cost price of 5 items is equal to the selling price of 8 items, then what will be the profit or loss percentage?
A shopkeeper sold a school bag at a profit of 42%. Had he sold the school bag at 22% profit he would have earned Rs.124 less. Find the cost price of the...
After selling 20 pens, a Shopkeeper earn a profit of the selling price of 6 books. While selling 20 books, a shopkeeper losses a selling price of 8 pens...
A shopkeeper sold an article for Rs. 600 after offering a discount of 40%. If he earned a profit of 50%, then find the ratio of cost price to the marked...