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

asked Sep 13, 2013 in MYSQL by anonymous
edited Sep 12, 2013
0 votes

Related Hot Questions

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please log in or register.