Question
A shopkeeper purchased 80 identical articles for a total
of ₹20,000. He sold 60% of these items at a 25% profit and the remaining at a 15% loss. Calculate the overall profit or loss percentage on the entire transaction.Solution
Cost of 1 article = 20,000/80 = 250 Cost of 60% (48) articles = 250×48 = 12000 Cost of 40% (32) articles = 250×32 = 8000 Selling price of 60% articles = 125% of 12,000 = 15,000 Selling price of 40% articles = 85% of 8,000 = 6,800 Total selling price = 15,000+6,800 = 21,800 
= 9%
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?
