The problem
The problem arises because you are using very old and deprecated two-letter font commands, which, as you have discovered, yield unexpected effects when combined together. Here's what you probably tried first:
\documentclass[12pt]{beamer}
\usepackage[T1]{fontenc}
\title{\rm\sc Great title}
\date{\tiny Blah blah}
\author{Fred}
\begin{document}
\begin{frame}
\maketitle
\end{frame}
\end{document}
If you compile this document, the title ends up in the sans font, and you also get the following warning saying that there is no sans small caps:
LaTeX Font Warning: Font shape `T1/cmss/m/sc' undefined
(Font) using `T1/cmss/m/n' instead
The reason for this is in the way the old two letter font commands work. See the following for more discussion of this.
The solution
The solution is to use the proper font commands, \rmfamily and \scshape and then things behave as you expect:
\documentclass[12pt]{beamer}
\usepackage[T1]{fontenc}
\title{\rmfamily\scshape Great title}
\date{\tiny Blah blah}
\author{Fred}
\begin{document}
\begin{frame}
\maketitle
\end{frame}
\end{document}
{\rmfamily\scshape Title}and not change the font theme? Note the use of\scshapenot\sc(which will not give the desired result). See Will two-letter font style commands (\bf , \it , …) ever be resurrected in LaTeX?. – Alan Munn Nov 19 '13 at 20:42