Can designers create on-chip SDRAM on Altera FPGA?

No.

You can use on-chip SRAM or instantiate a SDRAM interface to external SDRAM but there is no SDRAM on chip.