Question
Which of the following statement is/are incorrect about
the “Aravali Range”? I. The shape of the Aravali range is similar to that of the Tanpur instrument. II. The Aravalli range covers 21 districts of the state. III. The highest extent of the Aravali ranges is in Ajmer district and the lowest extent is in Udaipur district.Solution
The Aravalli range covers 17 districts of the state. It divides the state into two parts. Eastern and western parts. The Aravalli range divides the rivers of the state into 2 parts. Western part and eastern part. The rivers flowing to the west of the Aravalis carry their water to the Arabian Sea and the rivers flowing east of the Aravalis carry their water to the Bay of Bengal. The highest extent of the Aravali ranges is in Udaipur district and the lowest extent is in Ajmer district. The highest point of the Aravalli range is Gurushikhar in Sirohi district while the lowest point is pushkar valley in Ajmer district.
Which of the following is a key characteristic that distinguishes a PL/SQL `FUNCTION` from a PL/SQL `PROCEDURE`?
Which SQL statement combines the results of two queries and removes duplicates?
Which SQL clause is used to filter records based on aggregate functions?
Which SQL clause is used to filter results after a GROUP BY operation?
Which of the following statements about SQL `INDEXES` is generally TRUE?
Which SQL clause is used for filtering rows?
Given a table employees(id, dept_id, salary), which query returns departments with average salary greater than overall average across the company?
What is the main function of a PL/SQL `TRIGGER`?
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 SQL clause is used to group rows?
