Question
In a shop, there are a total of 15,000 chip packets. Out
of these, 28% are Green Lays packets, and out of the remaining, 75% are Red Lays packets, and the rest are Blue Lays packets. If 20% of Green Lays packets, 10% of Red Lays packets, and 15% of Blue chip packets were rejected for quality, then how many chip packets, in total, were rejected for quality?Solution
ATQ, Number of Green lays packets in the shop = 15000 × 0.28 = 4200 Number of Red lays packets in the shop = (15000 – 4200) × 0.75 = 8100 Number of Blue lays packets in the shop = 10800 – 8100 = 2700 Number of Green lays packets rejected for quality = 4200 × 0.20 = 840 Number of Red lays packets rejected for quality = 8100 × 0.10 = 810 Number of Blue lays packets rejected for quality = 2700 × 0.15 = 405 So, total number of chips packets rejected for quality = (840 + 810 + 405) = 2055
Which SQL command is used to modify existing records in a table?
A materialized view differs from a normal view because it:
Which of the following is a key characteristic that distinguishes a PL/SQL `FUNCTION` from a PL/SQL `PROCEDURE`?
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 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?
SQL Injection can be prevented by all EXCEPT:
What is an SQL `VIEW`?
Deadlock in DBMS can be prevented using:
What is the primary purpose of a `SEQUENCE` in SQL?
Which SQL statement combines the results of two queries and removes duplicates?
Relevant for Exams:
