Question
In a class of 225 students, 125 are girls and remaining
are boys. Among boys, the ratio of number of boys who are wearing caps to those who are not wearing caps is 1:4 respectively. Find the number of boys in the class who are wearing caps.Solution
Number of boys in the class = 225 β 125 = 100 Number of boys who are wearing caps = 100 Γ (1/5) = 20
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?