Question
A Shopkeeper gives 2 articles free on the purchase of
every 10 articles. He also allows a discount of 20% to customer and still earn 25% profit. Find the ratio of the cost price to the marked price of the article?Solution
Offer of the Shopkeeper: Buy 10 get 2 free = 12 articles Let the marked price of 1 article be Rs. 10 Marked Price of 12 articles = 10× 12 = 120 Selling Price of 10 articles = 10 × 10 = 100 Actual Selling Price of 10 articles (less discount) = 100 – 20 = 80 Profit % = 25 % ∴ Cost Price = 80 × 100/125 =64 Cost Price: Marked Price = 64: 120 = 8:15
Which type of index physically reorders the data rows in the table itself based on the index key, meaning the data is stored in the order of the index?
Recursive CTEs are mainly used for:
To rename a column in a SELECT query result, you use:
Which PL/SQL cursor attribute returns `TRUE` if the most recent `FETCH` statement returned a row, and `FALSE` otherwise?
Which of the following is a key characteristic that distinguishes a PL/SQL `FUNCTION` from a PL/SQL `PROCEDURE`?
Which SQL keyword prevents duplicate rows in result?
Which operator is used to combine results of two SELECT queries and remove duplicates?
What is the result of SELECT COUNT(NULL) on any table?
Which of the following SQL constructs avoids returning duplicate rows?
What is a 'stored procedure' in SQL?
Relevant for Exams:
