Question
Two motorists start together to travel to a certain
destination, one at the speed of 4 km/h and the other at the speed of 6 km/h. Find the distance travelled by them (in km) if the motorist travelling at 4 km/h arrives half an hour after the other motorist.Solution
The correct answer is C
Which SQL clause is used to group rows?
Which SQL keyword prevents duplicate rows in result?
Materialized views differ from normal views because:
What is the output of this SQL snippet if the price column contains NULL values?
SELECT SUM(price) FROM products;
Recursive CTEs are mainly used for:
In SQL, the ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW clause applies to:
Which SQL clause is used for filtering rows?
A materialized view differs from a normal view because it:
Which command removes all rows but keeps table structure?
Which of the following can be used to avoid duplicate entries in a column?