Question
A trader bought two laptops at a certain amount. He sold
the first laptop at a 50% profit and the second laptop at a 10% loss. If the selling price of each laptop is Rs. 22,000, find the overall profit/loss percentage faced by the trader in the transaction. (Correct up to two decimal places)Solution
ATQ, Let the cost price of the first laptop be Rs. '100e' and the second laptop be Rs. '100f'. 100e × 1.5 = 100f × 0.9 = 22,000 For the first laptop: 
For the second laptop: 
Total cost price: 14,667 + 24,444 = Rs.39,111 Total selling price: 22,000 × 2 = Rs.44,000 Total profit made by the trader: 44,000 − 39,111 = Rs.4,889 Profit percentage: 
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:
