On Unix, all dump styles generate a core file. The process cleans itself up as much as possible before exiting.
On Windows this is a Windows minidump file (type = MiniDumpWithFullMemory) named cachefpid.dmp, which can be read by WinDbg, a Microsoft debugger. This is the most complete dump option, but it can create a huge dump file.
On OpenVMS this is a .DMP file which can be read with the OpenVMS debugger.
On Windows this is the old style exception processing where the process does minimal cleanup (deqallresources and GRETRELEASE) and then resignals the exception. The intention here is to catch the exception in a debugger and preserve as much information as possible to analyze.
On Unix this detaches shared memory before the Abort, so the core file does not contain the shared memory area.