For getting admission in good universities of Canada to study MBA, which type of work experience is needed?
Suppose I get 710 in gmat wouldn't it be sufficient for getting admission in those good universities and to get scholarship as well?

If you're talking about the best MBA programs in Canada - McGill, Rotman, Schulich - successful applicants tend to have between 4 and 6 years of work experience, on average.

If you have that much work experience - or more - a 710 GMAT score would give you reasonably good chances for admission.

However, there are a ton of other variables, as well.

Scholarships tend to be hard to come by, even if you have a high GMAT score. These tend to be awarded to exceptional candidates - but you should really ask the schools directly.