Question
Harry paid a total of Rs. 800 for a set of different
mock tests. How many of the mock tests cost Rs. 40? I. Each Mock Test costs either 25 or 40 II. More than 4 Mock Tests cost Rs. 40Solution
From I, we get Let number of mock tests for Rs. 25 be x And number of mock tests for Rs. 40 be y Then, 25x + 40 y = 800 5x + 8y = 160 X = 32 - 8y/5 Since x is the number of mock tests for Rs. 25, it has to be a positive integer Thus, y can take the values 0, 5, 10, 15, 20 According to statement II, more than 4 mock Tests cost Rs. 40. Values of y more than 4 are: 5,10,15 and 20. Thus, we cannot find out the exact number of mock tests costing Rs. 40.
Which of the following statements about SQL `INDEXES` is generally TRUE?
Which of the following can be used to avoid duplicate entries in a column?
Which SQL clause is used to filter records based on aggregate functions?
In PL/SQL, what type of parameter allows a procedure to both receive a value from the calling environment and return a modified value back to it?
In SQL, the ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW clause applies to:
Which SQL constraint ensures that a column’s values are unique across the table?
Which SQL operator is used to search for a pattern in a column?
Which operator is used to combine results of two SELECT queries and remove duplicates?
Which SQL statement combines the results of two queries and removes duplicates?
In PL/SQL, what type of parameter allows a procedure to both receive a value from the calling environment and return a modified value back to it?