I feel qualified to work with SQL Server (not for a DBA position though) and didn't know the answers to half the questions. I've never seen truncate, two types

I feel qualified to work with SQL Server (not for a DBA position though) and didn't know the answers to half the questions. I've never seen truncate, two types of UDF or cursors... I believe that the thing that infuriates the interviewer is not ignorance, but the unlimited interviewee's confidence in making up the answers with "logic". If I don't know what truncate is, I just say so. Also I do know what a clustered index is, the difference between triggers and SPs, or the select into thing. So there wouldn't be so extreme a difference between knowledge and answering impudence.