Question
A marked an article 58% above the cost price and sold it
for Rs. 268.6 after giving a discount of 15%. Find the percentage profit earned by him if he sells the article for Rs. 250.Solution
Marked price of the article = 268.6/0.85 = Rs. 316 Cost price of the article = 316/1.58 = Rs. 200 Desired Profit percentage = [(250 – 200)/200] × 100 = 25%
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`?
