What is wrong with my sql answers and how should I answer?

Question

SQL

When I was looking for a job, I was interviewing for the vacancy of an ASP.NET programmer. I was cut off by 2 questions on MSSQL, Tell me how you would answer, the interviewer clearly did not like my answers.
Question 1: Q
: What is the difference between stored procedures and stored functions?
Me: Yes, as in many programming languages: a function returns a value, a procedure does not.
Q: What can be done in a stored procedure that cannot be done in a stored function?
I:. ...
Question 2:
And: What is a representation?
Me: A query-based selection that can be accessed by name, just like a regular table.
Type SELECT * FROM ViewName
And: Why do we need views?
Me: To write less code, not to produce the same type of requests. + I'm not sure, but it's possible that the views are somehow cached and you can get a performance bonus.
Both of my answers caused a sour face on the interviewer's face :)))

Answer 1

1 stackoverflow.com/questions/1179758/function-vs-st...
2 stackoverflow.com/questions/3986366/how-to-create-...
in both answers, you emphasized the wrong thing.
Most likely, in practice, you don't faced with what you were asked.
The next time you stumble over a question like this, say straight out that you have not encountered a task for which it is worth using X.
Ask the interviewer where they are currently using this technology in the project

Answer 2

Normal answers. The problem is not with them, but with the interviewer, IMHO.