there is also shear transfer due to the moment. resolve the moment into a tension / compression couple at the centerlines of the two thinner sections, then transfer that load across the joint in shear.
well what is your definition of "any"??? nothing is perfectly rigid.
well, what is "some"?
a sketch of this plate, with applied loads (a balanced fbd) and boundary conditions / connections would greatly help.
is there a hole in the plate with diameter equal to pipe ID?
what is the application?
where did the drawing come from?
if it came from a customer of yours, then contact them and discuss the requirements
then with displacement controlled tests, you will see load drops in the response curve which will not show up in a load controlled curve. these load drops are an artifice of the displacement controlled loading, as when there is a stiffness drop (due to damage, etc) there will be a load drop and...
1) suggest you delete and repost in the Aircraft Engineering forum
2) can you show a sketch of the joint?
3) is the bolt threaded into the fitting? (I hope not) or a thru bolt with proper nut/collar on it?