"So, to confirm, if I now attach a MF lens, I can use Aperture Priority?"
Yes, Tariq, let's hope this turns out to be the true state of the upgrade. There is lots of talk over at dpreview about how the A700 was the last Sony to get the A mode MF lens capability before the A900 series lost it, then (I believe) they reinstated it for the later small sensor cams.
It is just a small piece of automation but it will make a real difference to MF lens users, saving prep time for each shot, which can instead be used for any exposure comp setting using the front dial again. Another benefit is going from AF to MF lenses and back again, you can just leave it in A mode. There are apparently big benefits for users of telescopes and microphotography also, things of which I have no knowledge, just passing it on.
Hey, it might also stave off the sticky front dial some A900/850 users have reported...I have to spin that thing a lot sometimes if using f11, to set s/speed.