Question
A shopkeeper made a profit of 40% by selling an article
for Rs. 280. If he had sold it after allowing a discount of 15% on its selling price, then find the profit that the shopkeeper would’ve made in this transaction.Solution
Cost price of the article = 280 ÷ 1.40 = Rs. 200 New selling price of the article = 280 × 0.85 = Rs. 238 New profit = 238 – 200 = Rs. 38
Which type of trigger fires once for each row affected by the triggering DML statement?
What is the correct sequence of operations for using an explicit PL/SQL cursor?
Which SQL feature allows hierarchical queries (e.g., org chart traversal)?
Which operator is used for pattern matching in SQL?
Materialized views differ from normal views because:
Which SQL function returns the largest value in a column?
Which clause is used to sort query results in SQL?
Which join returns rows from the left table even when there is no matching row in the right table, filling with NULLs for the right side?
Which of the following statements about SQL `INDEXES` is generally TRUE?
What is an SQL `VIEW`?
Relevant for Exams:
