Q1 is simple enough and is simple join techniques, I wouldn't expect to see any issues there.
Q2 requires people to know about SARGability. While a definite skill I'd like to see in an applicant, I find many are largely clueless.
Q3 requires them to know the possible implications of recursive triggers and a little more detail to deal with interview nerves. A simple inclusion: We bulk update this table.
I personally don't find these questions overly difficult, but only the first one is a "book" question. The rest are experience questions.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA