Answer:
(a) Correlated.
Explanation:
Correlated subquery :These sub queries reference columns from outer table or uses values from outer query.These sub queries are processed atleast once for every row processed.So because of this reason correlated sub queries can be slow.Since the query in the question also uses value from the outer query so it is a correlated query.
Answer:
3
Explanation:
The function floor() is used to give the integer which is smaller than or equal to the provided decimal value.
for example:
let a=5.8
floor(a);
the function provides the value 5 (smaller than or equal to 5.8).
In the given code:
variable num assigns the number 3.14.
then, floor(3.14) gives the value 3 (smaller than or equal to 3.14).
then, the echo print the value on the screen.
Therefore, the correct answer is 3.
