categories - Does the 'cat' argument in query_posts fetch posts from subcategories as well as the given ID? in WordPress

In short: Yes.

Your question is about the query_posts Wordpress PHP function . The link I've placed is the official wordpress codex documentation for that function.

For your example it states:

Display posts from only one category ID (and any children of that category):

query_posts('cat=4');

I hope this information is helpful. You find more infos in codex, the function is pretty powerful.