Ask a Question
Advertise on boostr.in
Organizational Research By
Surprising Reserch Topic
Question:Which of the following is true when the sparse data is densified using partitioned outer joins?
a. ¬†¬†¬†¬†¬†¬†¬†The missing data must be filled in by zeros
b. ¬†¬†¬†¬†¬†¬†¬†The IGNORE NULLS clause can be used with the LAST_VALUE function to replace the missing values with the most recent non-NULL value in that column
c. ¬†¬†¬†¬†¬†¬†¬†The missing data must be filled in by NULLs
d. ¬†¬†¬†¬†¬†¬†¬†The missing data must be provided by updating the column with the missing values
Sep 13, 2013
Sep 12, 2013
to add a comment.
Related Hot Questions
Your name to display (optional):
Email me at this address if my answer is selected or commented on:
Email me if my answer is selected or commented on
Privacy: Your email address will only be used for sending these notifications.
To avoid this verification in future, please