Question
In the question below some statements are given
followed by two conclusions I and II. You have to take the given statements to be true even if they seem to be at variance with commonly known facts. Read all the conclusions and then decide which of the given conclusion definitely follows from the given statements, disregarding commonly known facts. Statements: Some Father are Mother All Brother are Mother No Father is Sister Conclusions: I. Some Father are Brother II. Some Mother are SisterSolution
Some Father are Mother (I) + Some Mother are Brother (I) → No conclusion. Hence conclusion I does not follow. No Father is Sister (E) → Conversion → No Sister is Father (E) + Some Father are Mother (I) → Some Mother are not Sister (O*). Hence conclusion II does not follow.
What is the output of this SQL snippet if the price column contains NULL values?
SELECT SUM(price) FROM products;
Which of the following is a key characteristic that distinguishes a PL/SQL `FUNCTION` from a PL/SQL `PROCEDURE`?
A materialized view differs from a normal view because it:
What is the primary purpose of a `SEQUENCE` in SQL?
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?
Recursive CTEs are mainly used for:
Which operator is used to combine results of two SELECT queries and remove duplicates?
Which SQL function returns the largest value in a column?
Which of the following can be used to avoid duplicate entries in a column?
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?
