Can I query the Remote access object to get consumer key and consumer secret?

No – it’s not possible to retrieve a remote access app’s consumer key/secret via Apex.

The approach Chatter Desktop uses is the OAuth 2.0 ‘user agent’ flow – the Chatter Desktop carries a consumer key, but no secret, since an attacker could just read it out of the app’s binary.