Hello Divya Ramprasad and welcome to bytes.com!
Your second question is easy to answer: No, you won't be able to see a stack or a queue if you open the motherboard. What you may see is the
RAM, which is a green bar with black rectangular chips on it and which is attached to the motherboard in a long slot. Many computers have several RAM bars, I've never seen a motherboard that supported less than two of them (though that doesn't necessarily mean, that a minimum of two are actually installed).
To answer your first question, it depends on what you mean with "how do they appear in memory" - if you mean how they look datatype wise, look at implementations of queues and stacks in languages such as C or, if you really want to know the details, in an assembly language. If you mean how they look optically I'd refer you to the first paragraph of my answer.