As Jack said, on most consumer devices a DMZ is simply shorthand for forward all ports to this specific host. It's like putting your computer directly on the Internet, almost.
In most corporate products a DMZ is used to seperate two parts of a network. Traffic from your backbone will be denied by default with only a few known necessary ports open for communication and usually only in one direction. For instance, if a unix box is in the DMZ you would most likely enable ssh from the backbone to the DMZ, but not vice versa.