Question
Cost of two types of pulses is Rs.12 and Rs, 17 per kg,
respectively. If both the pulses are mixed together in the ratio 2:3, then what should be the price of mixed variety of pulses per kg?Solution
(17 – x)/(x – 12) = 2/3 51 – 3x = 2x – 24x 5x = 75 x = 15 Therefore, price of mixed variety of pulses = Rs 15 per kg
Which SQL function returns the total number of rows in a table?
What is meant by 'cardinality' in data modeling?
Which of the following is a real-time data warehouse application?
What is the result of SELECT COALESCE(NULL, NULL, 5, 10);?
Which of these is not a typical data warehouse characteristic?
Which type of schema uses a central fact table connected to dimension tables?
Which of the following best describes the primary function of a database index?
Which type of slowly changing dimension (SCD) preserves full history by adding a new row for each change and using effective date ranges?
Which SQL keyword is used to combine results from two queries and remove duplicates?
In the context of a relational database, which of the following is NOT a characteristic of a candidate key ?