Question
In the following question a sentence is given with a
blank. Choose the most appropriate option to make the sentence contextually and grammatically correct. The petitioner sought a direction to the authorities concerned to renovate the school building and _____________new classrooms to avoid overcrowding.Solution
Explanation: The word "establish" fits best in this context as it conveys the idea of setting up or creating new classrooms to address overcrowding. "Build" could also work, but "establish" is more formal and appropriate in the context of administrative or legal language, where "setting up" or "creating" is more commonly used. "Form" and "creation" are less suitable here, as "form" implies a more abstract concept, and "creation" would require a different grammatical structure (e.g., "the creation of new classrooms"). Β
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?
Recursive CTEs are mainly used for:
To rename a column in a SELECT query result, you use:
Which PL/SQL cursor attribute returns `TRUE` if the most recent `FETCH` statement returned a row, and `FALSE` otherwise?
Which of the following is a key characteristic that distinguishes a PL/SQL `FUNCTION` from a PL/SQL `PROCEDURE`?
Which SQL keyword prevents duplicate rows in result?
Which operator is used to combine results of two SELECT queries and remove duplicates?
What is the result of SELECT COUNT(NULL) on any table?
Which of the following SQL constructs avoids returning duplicate rows?
What is a 'stored procedure' in SQL?