Bissoy.com
Doctors Medicines MCQs Q&A

The command to remove rows from a table 'CUSTOMER' is:

The command to remove rows from a table 'CUSTOMER' is: Correct Answer DELETE FROM CUSTOMER WHERE ...

The command to remove rows from a table in SQL is DELETE FROM CUSTOMER WHERE .... Option D is the correct choice for deleting rows from the 'CUSTOMER' table based on specific conditions specified in the WHERE clause. Options A, B, and C do not represent the standard SQL syntax for removing rows.

Related Questions

A customer purchased two units of the same item, one from a shopkeeper and one from a whole seller. The whole seller sold the items to the shopkeeper and customer at 15% profit while the shopkeeper sold the item to the customer at 20% profit. If the difference between the price of both units for the customer is Rs. 96.6, then what is the total cost of both the units for the customer?
The command to remove rows from a table ‘CUSTOMER’ is __________________
When all the students in a school are made to stand in rows of 54, 30 such rows are formed. If the students are made to stand in rows of 45, how many such rows will be formed ?
When they had a meeting seven company executives __ T, U, V, W, X, Y and Z ___ sit at a rectangular table .Three executives sit along one side of the table , and three sit along the other side, each directly opposite one of the other three. The seventh sits at the head of the table . There is no seat at the foot of the table . Ualways sits in one of te two seats farthest from the head of the table. Y and V always sit next to each other .V never sits next to Z . If Z does not sit at the head of the table, W sits there. If W sits directly opposite T, X must sit next to which of the following excutives?
The manufacturer of a table sells it to a wholesale dealer at a profit of 10%. The wholesale dealer sells the table to a retailer at a profit of 30%. Finally, the retailer sells it to a customer at a profit of 50%. If the customer pays Rs 4290 for the table, then its manufacturing cost (in Rs) is
The question given below consists of a statement, followed by three arguments numbered I, II and III. You have to decide which of the arguments is/are ‘strong’ arguments and which is/are ‘weak’ arguments and accordingly choose your answer from the alternatives given below each question. Statement: In an interview with ETCIO.COM, Kuruvilla Markose, Chief Digital Officer of Titan shares his perspective on how technology is serving the company’s digital vision and the various initiatives that he is spearheading to hone the competitive edge of Titan. He is the first CDO to be appointed by the software conglomerate Tata Group. He is the man who has put the Titan’s digital transformation on fast-track. Which of the following arguments support the fact that Kuruvilla Markose has put Titan’s digital transformation on fast-track? Arguments: I. Markose is a man with a vision. He is the first CDO to be appointed by the software conglomerate Tata Group. He has spent his entire two decade long career in Tata Group. He has been in customer facing roles across different group companies.  II. His CDO role is horizontal and supports Titan’s myriad business lines: watches, jewellery, bags, perfumes wallets, and eye-wear. But the man and his words are grounded. Diny, as he is popularly known, is a man of measured speech and bearing. III. “Digital innovation”, according to Markose, is all about creating value for the customer. To him, customer centricity is the road to longevity in the digital age. Under his stewardship, Titan has launched a panoply of digital initiatives aimed at improving customer centricity.
A shopkeeper marked an item 50% above the cost price and sold to customer A at a 10% discount. While he marked the same item 60% above the cost price and sold to customer B at a 20% discount. If customer A paid Rs. 56 more than customer B, then what is the profit amount earned by a shopkeeper after selling items to both the customers?
A company sold a bike worth Rs. 40000 to a dealer at a profit of 5%. The dealer sold it to a customer at a profit of 12%. After few years, the customer sold the bike back to the dealer at 25% loss. If the dealer sold the old bike to a new customer at 5% profit, at what price did the new customer bought the bike?
Phillip Kotler argues that the 4 Ps which represent the seller’s thinking more than buyer’s thinking can be translated into the 4 Cs. Match the following : 4 Ps of marketing Planning 4 Cs of Marketing Planning 1. Product (a) Customer Communication 2. Price (b) Customer value 3. Place (c) Customer costs 4. Promotion (d) Customer convenience Select the correct matching using the code given below :
The cost of servicing of a Maruti car at Maruti care Pvt. Ltd. is Rs. 400. Manager of service centre told me that for the second service within a year a customer can avail a 10% discount and further for third and fourth servicing he can avail 10% discount of the previous amount paid, within a year. Further if a customer gets more than 4 services within a year, he has to pay just 60% of the servicing charges on these services. A customer availed 5 services from the same servicing station, what is the total percentage discount fetched by the customer?