NCTIONS #25 PAT-ID is a string column that contains the patients' IDs. PAT-NAME is a string column that contains patients' names. Assume that both columns are populated. Which of the following concatenates patient IDs and patient names? SELECT ALL THAT APPLY (1 PT) A. In Oracle: PAT_ID |I PAT NAME In SQL Server: PAT ID + PAT_NAME B. In Oracle: PAT ID "PAT_NAME" In SQL Server: "PAT NAME" PAT_ID C.COALESCE( PAT_ID, PAT_NAME) D. CONCAT( PAT ID, PAT NAME)