Question
Who among the following are
girls? Study the following information carefully and answer the questions given below: Eight students A, B, C, D, E, F, G and H have their practical exam on three different days, viz Monday, Wednesday and Friday. Two of them are girls who goes for practical exam on different days and like different subjects, but not Biology. Two of them likes Physics, two of them likes Chemistry, two of them likes Biology, one of them likes Botany and one of them likes Zoology. D goes for practical exam on Monday and likes Chemistry and her female friend G, who goes for practical exam on Friday and likes Physics. H likes Chemistry and goes for practical exam on the same days as B, who likes Biology, but does not goes for practical exam on Wednesday. C, is neither a girl nor likes Botany. No two students with the same subject goes for practical exam together. F likes Biology and goes for practical exam on Wednesday and his friend A likes Physics. A goes for practical exam on Monday with only one student. Not more than three students goes for practical exam on the same days. No girl goes for practical exam on Wednesday. E does not goes for practical exam on Friday and is not a girl.Solution
What is an SQL `VIEW`?
Which of the following is a mandatory component of a PL/SQL function's definition?
Materialized views differ from normal views because:
Which index type is most beneficial for queries that use range predicates (e.g., WHERE age BETWEEN 20 AND 30)?
Which PL/SQL cursor attribute returns `TRUE` if the most recent `FETCH` statement returned a row, and `FALSE` otherwise?
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 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?
What is the correct sequence of operations for using an explicit PL/SQL cursor?
Which SQL constraint ensures a column cannot have NULL values?
Which SQL clause is used to filter records based on aggregate functions?