• SCHOLARSHIP

    he Norwegian government provides scholarships for students from developing countries in the South and countries of Central- and East-Europe and Central-Asia under the Quota Scheme. The goal of the Quota Scheme is to promote the internationalization of higher education and give developing country students relevant education that would also benefit their home countries when they return after graduation..

  • Education

    It´s time for another post with inspirational quotes. This time I´d like to focus on something I find very useful: education. School may have been – or still be – boring, a killer of creativity or downright awful for you. But education is still important because it opens the mind and expands it. And if your years in school were bad or boring you can still educate yourself now. Anyways, here’s some wisdom and inspiration from the people who have walked before us. It is impossible for a man to learn what he thinks he already knows ...

  • Exam.

    Exam Quotes On Taking The Initiative “Recipe for success: Study while others are sleeping; work while others are loafing; prepare while others are playing; and dream while others are wishing.” ~ William A. Ward.

Showing posts with label Top Level Exam. Show all posts
Showing posts with label Top Level Exam. Show all posts

Tuesday, May 7, 2013

Top Ten Students in Jharkhand 2013

Jharkhand Results 10th Class


Top Level Exam, 10th Results, Jharkhand, Jharkhand Results, JHARKHAND SCHOLARSHIP,
Jharkhand Top ten Jac 10 th Results
jac 10th Results

Top Ten Students in Jharkhand 2013
Read More

Wednesday, February 6, 2013

LADY TATA MEMORIAL TRUST LADY TATA MEMORIAL TRUST



JHARKHAND SCHOLARSHIP, ALL INDIA SCHOLARSHIP, SCHOLARSHIP, SCHOLARSHIP FORM, Top Level Exam,
LADY TATA MEMORIAL TRUST

RULES GOVERNING THE SCHOLARSHIP AWARDEES IN INDIA

POST-DOCTORAL FELLOWSHIP  AND JUNIOR SCHOLARSHIP

2013-2014

1. The JR scholar’s university/laboratory/institution must appoint a three-member Doctoral Committee (DC) within three months of the issuance of the JR award letter and this DC has to have the approval of the Indian Scientific Advisory Committee of the Trust.  The DC should comprise of the Guide (Convenor), a Professor grade faculty and another faculty working in related areas of science.  At the end of each year, the Scholar will present the work done to the DC and a summary of the work done along with approval of the DC members should be sent to the Trust’s ISAC for renewal of the scholarship for the subsequent year

2. The JR Scholar must complete the formalities for Ph.D. registration within 9 months to 14 months from the date of joining the award, otherwise the Trust will terminate the scholarship.

3. It is to be noted that while the Trust awards a five-year scholarship to fresh M.Sc.s (2 year as JRS and 3 years as SRS), the tenure of this scholarship will be continued only up to the vivo voce of the thesis submitted for the Ph.D. requirements.  The student   must send a copy of the synopsis of the thesis to the Trust when it is submitted to the respective University and inform the date when the thesis is submitted and when the viva voce is scheduled.  A copy of the provisional certificate after completion of the Ph.D. requirements must also be submitted to the Trust (Points 1 to 3 strictly for Junior Scholarship awardees).

4. The awardee must devote his/her whole time to the research work undertaken by him/her.  All other scholarships, posts or awards must be relinquished before the Lady Tata Memorial Trust Award is accepted.

5. The awardee will engage in the scientific work as approved by the Indian Scientific Advisory Committee of the Trust to the entire satisfaction of the Trustees who reserve the right to withhold payment.  He/she will be required to submit in the month of August his/her progress report online together with of a covering letter from the Guide giving his/her critical comments on the work done by the awardee as per requirements given by the Trust.  The scholarship is liable to be terminated without notice if the progress made on the research project, as per the annual progress report, is found to be unsatisfactory or if any unfavourable report is received from the Doctoral Committee (for Junior Scholarship) / Director of the Institute or the Head of the Department under whom the awardee may be working.

6. A contingency grant not exceeding Rs.20,000/- per annum for the purchase of chemicals or glass apparatus, maintenance of animals, and such other items as are ordinarily admissible for contingent expenditure, may be made if found necessary.  Allowance will also be made for covering the registration fees and second class sleeper travel, to and fro, within the country for attending seminar/conference/meeting, etc. as participant or for presentation of abstract / poster presentation.  The institution to which the awardee is associated will be expected to provide at its cost the supplies normally made available to the research workers.  The estimate of the contingent expenditure indicating clearly the items needed should be sent to the Trust before the 31st August 2013.  In the event of the contingency grant being sanctioned, claims for reimbursement of the actual expenditure incurred by the scholar will be entertained on production of original bills and vouchers pertaining thereto, together with a covering statement in duplicate of expenses incurred, duly endorsed by his/her University/Institute.  Such claims for reimbursement are to be made in accordance with the instructions which are given in the letter of award sanctioning the contingency grant to the scholar.  Claims for reimbursement must be sent so as to reach the Secretary, Lady Tata Memorial Trust, before 31st  August each year.

7. Sick leave may be granted at the discretion of the Research Guide but cases of such leave should be immediately reported to the Trust.  A case of absence exceeding ten days on account of serious illness or any other reason should be referred to the Trust for consideration.

8. The awardee will strictly not be permitted, except for very exceptional reasons supported by documentary evidence, to abandon his/her research work in the middle of the academic year as this defeats the very purpose of the Scholarship and is viewed with strong disfavour by the Trust.

9. A selected candidate, if after having accepted our Award abandons the research work before completing it or relinquishes the scholarship in the middle of an academic year on the ground that he/she has been offered an award of a higher value by another funding agency/organisation, or has secured alternate employment, he/she will be called upon to refund the entire scholarship amount plus the amount paid for contingency/HRA expenditure and the concerned university / institute will not be considered for the Trust scholarships for the next two academic years.  A Bond will have to be executed to this effect by the awardee, and countersigned by the concerned guide, at the time of accepting our Award.  Applications for relinquishing a Scholarship must be sent to the Trust one month prior to the date of such relinquishment.

10. Claims for House Rent Allowance, where applicable, should be made latest by the 10th September 2013, together with the latest original receipt as proof of occupancy.  Any claims made after that period will not be entertained.
-------

Read More

scholarship list Scholarships for Indians who intend to Study abroad


ALL INDIA SCHOLARSHIP, Top Level Exam, FORMS, SCHOLARSHIP, SCHOLARSHIP FORM,
Scholarships for Indians who intend to Study abroad 

Welcome to version 2.0 of the scholarship list. The changes in this list (as compared to the previous one)
have been mentioned below.
There are NUMEROUS scholarships available for study abroad. The Rotary, JN tata, and GD Sethna
Scholarships are MUST apply scholarships. I was able to apply for just one of the above (GD Sethna)
because I was late. Please don’t repeat the same mistake.
TIME TO APPLY:
If you plan to go for August the next year, you should start applying from JULY in the PREVIOUS Year.
For example, if you have to go for August 2005, you should start applying for the scholarships from July/
September 2004 i.e. 11 months before hand.
This is particularly true of the Rotary scholarship fund, which issues the application forms in July.
UPDATED LISTS:
The changes made in version 2.0 are:
1) Phone numbers & website addresses of most of the important scholarships included.
2) Discontinued scholarships have been weeded out
3) Most of the Non-Bombay scholarships have been included
The changes that will be made in the next version (v 3.0) will be as follows:
1) A map of Bombay with the scholarships trusts marked out by area will be included.
2) Deadlines of most of these scholarships will be mentioned.
3) All the non-Bombay scholarships will be included.
Version 3.0 will probably be the final version of this list.
The updated lists will be uploaded to my college website (www.kemates.com). Visit the site to verify
that you have the most up-to-date and correct version. Corrections submitted to me will be added to
the list as soon as I can. If you want to be informed when these lists are uploaded, please send me a
short mail at siddharthkharkar@yahoo.com or oncogen@kemates.com
PDF created with FinePrint pdfFactory trial version http://www.fineprint.comTIPS FOR USING THIS LIST:
1) Pay special attention to the pin codes and plan your travel accordingly. It will take you around 2-3
days to cover all these areas.
2) Try calling up directory services (in Bombay, phone 28888888) to find the numbers for the trusts.
If you don’t find the numbers and have to go personally, please ask them for their phone number.
If you do find the numbers, please send them to me via email, so that I can include them in the list for
the benefit of others.
Please send any corrections/suggestions/words of encouragement via email. Most of the phone numbers
in this list have been verified, if you come across any mistakes, please send me a short email.
And please, please, please if this list is useful to you and you do get any of these scholarships, please do
send me a mail. It would make all this trouble seem worthwhile.
Don’t forget to share this information with your friends, and send me any information you have, so that I
can include it here.
Best of Luck, J
Dr. Siddharth Kharkar.
ScM, Molecular Microbiology and Immunology,
Sp. Interest: Vaccine development,
John Hopkins University, Fall 2003.
Graduation: MBBS, GS medical college and KEM hospital.
Email: oncogen@kemates.com & siddharthkharkar@yahoo.com
Table of Contents
1. “Must Apply” Scholarships
2. Other Scholarships in Bombay/Pune
3. Other Scholarships in Delhi
4. Miscellaneous
PDF created with FinePrint pdfFactory trial version http://www.fineprint.com“Must apply” scholarships:
These are scholarships that are stable. A large number of scholarships are available each year through
each of these schemes. The most valuable scholarships are those sponsored by the JN tata, Rotary,
USEFI (Fullbright) and Inlaks foundations.
1) The J.N.Tata Endowment Fund:
Also, phone once more at the same number and ask for the Ratan Tata trust (for travel)
Telephone Address Website / Email address
22 - 22049131 Bombay House,
Behind Askarrally’s lane,
24, Homi Mody Street,
Mumbai – 400 001.
http://tata.com/0_beyond_business/t
rusts/index.htm
Established in 1892, the trust funds higher education of deserving Indians. So far, the trust has supported
2,890 scholars and awarded Rs. 68 million to promising students from various strata of society.
Graduates with consistently good academic record, who have applied for admission to universities
abroad for the Fall / Spring semesters. The form can be obtained from Mulla House, 51 M G Road,
Mumbai 400 001 against Rs 50/- by cash or MO before January 31.
Eligibility
a) Students with just a basic graduation are normally not encouraged. b) While only students with a
consistent academic record will be eligible to apply, those have had opportunity of studying abroad will
not be considered for the award. c) Age limit not more than 27 years at time of applying.
Total worth:
FULL fees + Monthly stipend of around 1000 US dollars.
2) Rotary Scholarship:
Phone  Address Website / Email
022 - 26609847
022 - 26607217
(Praful M. Bhatt)
Rotary Service center,
Juhu Tara road,
Mumbai - 400049
http://www.rotary.org/foundation/educat
ional/amb_scho/
Also see:
http://www.umich.edu/~icenter/oversea
s/study/rotary.html
Applicants
1. Should be between 18 to 30 years of age
2. Should hold first class honors degree in related discipline
3. Work experience is preferred
Value:  $10,000 (up to 24,000) + other expenses
PDF created with FinePrint pdfFactory trial version http://www.fineprint.comFeatures:
1. There are 8 different scholarships administered. They are:
    a. Graduate scholarships
    b. Undergraduate scholarships
    c. Vocational scholarships
    d. Teachers and handicapped scholarships
    e. Journalism scholarships
    f. Freedom from Hunger scholarships
    g. District scholarships
    h. Group study exchange programme
2. Eligibility criteria and notification will appear separately for each branch.
3) RD Sethna Scholarship:
Phone Number Address
022 - 22070764
Esplanade House, 1st Floor,
RD Sethna Scholarships
Fund, 29,
H. Somani Marg,
Fort, Mumbai - 400 001
Its near Sterling Theater. The Phirojshah Godrej foundation
is nearby too. Hence, make it a point to visit it when you visit
the Sethna fund. By the way, in case you are hungry, grab a
chicken sandwich at the sterling café.It’s cheap and good. ;)
4) American Alumni Association:
Phone Number Address
022 - 2821413
022 - 2821485
aaa@indous.org
C-Vulcah Insurance Building,
Veer Nariman Road,
Opp. Churchgate Station,
Mumbai 400020.
(Get down at CCg station and start walking towards Marine
drive. It is on the same side of the road as “Asiatic general
stores”, about 3-4 buildings away.)
5) Lotus Trust:
Phone Number Address
Lotus House,
Near Liberty Theater,
6 New Marine Lines, Mumbai 400020.
Comments: Small scholarship, Max Rs. 50,000. But, it’s easily available.
PDF created with FinePrint pdfFactory trial version http://www.fineprint.com6) The Fulbright Commission / Also known as the USEFI :
Phone Numbers Address Website / Email
022-22624603 (Bombay)
044-28112049 (Chennai)
033-22881637 (Calcutta)
011-23328944 (Delhi)
Has offices in Mumbai,
Calcutta, Delhi and
Chennai. Check the site for
the addresses.
http://www.fulbright-india.org/
info@fulbright-india.org
The flagship international educational program sponsored by the United
States Government, widely known as the Fulbright Program, is designed to
"increase mutual understanding between the people of the United States and
the people of other countries..."
With this goal as a starting point, the Fulbright Program has provided more than
230,000 participants - chosen for their leadership potential - with the opportunity
 to observe each others' political, economic and cultural institutions, exchange
ideas, and embark on joint ventures of importance to the general welfare of the
world's inhabitants. In some countries Fulbright provides only partial scholarships.
Application process usually begins 18 months prior enrollment.
7) Inlakhs Scholarships:
Phone Number Address Website / Email
Post Box No. 2108
C/O St. Stephen's College
New Delhi 110 007
INDIA
www.inlaksfoundation.org
inlaks@del2.vsnl.net.in
Comments: HUGE scholarship, as large as the JN Tata endowment fund and the Rotary scholarships
   
Courses of Study:
o Courses at Oxford, Cambridge, London School of Economics, Imperial College of Science &
Technology in any available subject except Engineering and Computer Sciences.
o Graduate courses at American and European Institutions in subjects including Architecture,
Business Administration, Communications (Film, Television, Journalism), Special Education and
Law.
o Courses in Fine Arts, Applied Arts and Conservation, Design and Fashion Design, Theatre and
Dance, Music and Composition.
Candidates should have obtained admission to the University or Institute of their
choice prior to submitting the application form. The Committee will consider only
those candidates for interview, who have obtained admission.
PDF created with FinePrint pdfFactory trial version http://www.fineprint.com8) Bai Shrinbai and Seth Horusji Mody trust:
Phone Number Address
022 - 2673806 C/O Kapadia Damania company,
Bhupen Chambers,
Dalal street,
MUMBAI - 400 001
Comment: Available from 1st April. The Last date to submit this form is 31st May
9) Shri Brihad Bhartiya samaj Scholarships:
ONLY given to candidates lacking in financial resources.
Phone Number Address
022 - 22020113
(Mrs. Gadre)
Sri Brihad Bhartiya samaj,
NKM International house,
178, Backbay reclamation,
Babubhai M. Chinai marg,
Mumbai – 400 020
Comments: Newspaper notification appears in July, last date for submission of forms is September 15.
PDF created with FinePrint pdfFactory trial version http://www.fineprint.comOther Scholarships in Bombay / Pune:
Please inform me once you know the phone numbers of these institutions.
Also, mail me about discontinued scholarships, or incorrect phone numbers or addresses. Someone is
doing this for you; you owe it to everyone to send in the corrections. I hope you agree… J
 Please mail me at siddharthkharkar@yahoo.com or oncogen@kemates.com
  Please don’t be selfish, and you won’t lose. J
Scholarship Phone
Number
Address Comments
1. Currimiji Jiwanji Moriswala
Charity Trust
Trust 157 Kazi Sayeed Street
Bombay
INDIA
India
2. Dawoodbhoy Fazalbhoy
Muslim Educational Trust
Dawodbhoy Fazalbhoy
Muslim Educational Trust
42, Ibrahim Md. Merchant
Road
Dhadah Khadak
Mumbai 400 029
Only for Muslims
3. Deccan Education Society
Foreign Scholarship Fund
Deccan Education Society
Pune
INDIA
4. Ichalkaranji educational
Endowement
“Yeshodham”, 7,
Tapobhuml Society,
Near  Kirloskar Press,
Mukund Nagar,
Pune - 9
Only for Maharastrians
5. Eduljee Dinshaw Trust Bombay University
M.G. Road
Mumbai 400 023
India
6. G.B. Kimaye
Scholarship Fund
Trust c/o Director of
Education
Pune, Maharashtra
INDIA
7. GSB Foreign
Education Society
Trust Chikitsaha Samuha
Building
Sadashiv Cross St.
Khadilkhar Road
Mumbai 400 004
INDIA
PDF created with FinePrint pdfFactory trial version http://www.fineprint.com8. H.C.J. Trust Readymoney Mansion
Veer Nariman Road
Mumbai
9. Hinduja Foundation Trust Hinduja House
Dr. Annie Besant Road
Worli
Bombay 400 018
10. Homi Bhabha Foundation Trust c/o National Centre for 
Performing Arts
Nariman Point
Mumbai 400 021
11. India Foundation
(For Free Passage)
Sakal Office Building
595 Budhawar Peth
Pune 411 002
INDIA
12. Jain Educational Society Trust c/o V.T. Sheth
14 Murzban Road
Fort Mumbai 400 023
INDIA
13. Jivraj Mulukchand Shah 
Charitable Trust
Trust Vasant Nivas
1st Babulnath Lane
Mumbai 400 007
INDIA
14. K.C. Mahindra Education 
Trust
Mahindra Spincer Building
15, J.N. Heredia Marg
Ballard Estate
Mumbai 400 038
INDIA
15. K.H. Goreganokar 
Charitable Trust
Trust Radha Niwas
1st Babulnath Lane
Mumbai 400 017
INDIA
16. Kasturbhai Walchand 
Trust
Construction House
Ballard Estate
Bombay 400 039
INDIA
PDF created with FinePrint pdfFactory trial version http://www.fineprint.com17. Lady Meherbai Tata Trust Bombay House
Homi Mody Street
Mumbai 400 020
Only for girls
18. Lila Poonawalla 
Foundation
C/o the Secretary
The White House
Modi Baug
University Road
Pune 411 016
Only for girls
19. Lokmanya Memorial
Trust
Trust c/o Kesari Maratha
Trust
Gaikwad Wada
Pune
20. M.C. Ghia Charity
Trust
DISCONTINUED
21. M.G. Charitable Trust Trust c/o M.S. Motichand & 
Company
United India Building
Sir P.M. Road
Fort Mumbai 400 001
22. Mafatlal Charity Trust Mafatlal House
27 Veer Nariman Road
Mumbai 400 001
23. Maganlal Vallabhdas 
Mehta Trust
c/o Shri Gopaldas M. Shah
Chandra Nivas
Opposite Prakash Picture
Andhari (East)
Mumbai 400 058
24. Maharatta Education 
Fund
Maharatta Niwas
219 Mowbrays Road
Chennai 600 018
INDIA
This is actually in
Chennai, but it is ONLY
for Marathi speaking
candidates. Go figure… :)
25. Mahindra Education Trust Trust Wavell House
15 Graham Road
Mumbai 400 023
The forms are distributed
in the month of January,
and have to be submitted
by March.
PDF created with FinePrint pdfFactory trial version http://www.fineprint.com26. Mariwala Trust Knamoor House
5th Floor
281/87
Narsi Natha Street
Near Masjid Rly. Station
Mumbai 400 009
27. Marshal Charitable 
Foundation 2074506
Ellis Saroj
Savoy Chambers
Ground Floor (Behind
Excelsior Theatre)
5 Wallace Street
Mumbai 400 001
28. Menekji & Shrinibai 
Neterwalla Trust
Trust Liberty Building
4th Floor
New Marine Lines
Mumbai 400 020
29. N.A.F. Foundation Milton's House
Prabhadevi
Mumbai 400 025
30. N.M. Wadia Charities
DISCONTINUED
31. Nanikran Meghraj Trust 16 Kishore Building
521 Kalbadevi Road
Opp. Edward Cinema
Mumbai 400 002
32. Oak Education Charity 
Trust
c/o R.V. Dongre
348 Lamington Road
Mumbai 400 040
INDIA
India
33. Paragon Charitable Trust 493 8752 or 
493 8599
90, Paragon Textile Mills
opp century Mills
Near Mahindra Towers
Mumbai 400 013
34. Pirojsha Godrej 
Foundation
56365656
(Mr.
Dadabhoy)
4 A, Home Street, Fort
Mumbai 400 071
INDIA
This is located near the
RD Sethna foundation;
visit them both at the
same time.
PDF created with FinePrint pdfFactory trial version http://www.fineprint.com35. HA Dubhash Charities Near Jehangir Art Gallery
Fort Mumbai 400 001
INDIA
For BOYS only
36. S.K. Patil Trust N.K. Mehta International 
House
178 Backbay Reclamation
Mumbai
37. S.V. Rajadhyaksha G.S.B. 
Foreign Education Society
Chikitshaka Sasmuda
Building
1st Khadilkar Road
Mumbai 400 004
For G.S.B. community
only.
38. Saifee Foundation Trust 7 Najmuddin Saifee Mahal
Powai Road
Mumbai 400 001
For Bohri Muslims only
39. Seth P.F. Davar Charitable 
Trust
c/o Parsi Panchayat Office
209 Dr. D.N. Road
Fort Numbai 400 001
(Housed in JJPB Girls High
School)
40. Seth Puroshothamdas 
Thakurdas Trust
Navsari Chambers
Thakurdas Marg
Mumbai 400 001
41. Shri Hatakesh Ambika 
Trust
38 Noble Trust
5th Road
Parsi Bazaar Street
Fort Mumbai 400 001
42. Shri Ramakrishanan 
Shikshan Mandal
c/o Raghunath R. Narwane
Shastri Hall
Tardeo Road
Mumbai 400 007
43. Tata Chem Golden 
Jubilee Foundation
Trust Bombay House
Homi Mody Street
Mumbai 400 020
PDF created with FinePrint pdfFactory trial version http://www.fineprint.com44. The V.C. Vaidya Hundi
Education Fund
Managing Trustee
c/o New India Assurance Co.,
Ltd.
M.G. Road
Fort Mumbai 400 001
45. Time & Talents Club Victory Stall
Apollo Bunder
Mumbai 400 001
INDIA
Has this been
discontinued ?
46. Vasketu Foundation 267 4869 Great Eastern Shipping 
Corporation
Mercantile Bank Building
Mumbai 400 023
47. Watumul Foundation 
 c/o Office of the K.C. College DISCONTINUED
48. Manekji & Shrinibai
Neterwalla Trust
Liberty Building,
4th Floor,
New Marine Lines,
Mumbai 400020.
Last Date : 15th  April
49. Naina Parikh Education  
Trust
Vithaldas Chambers,
Opp. State Bank,
Bruce  Street,
Mumbai - 400001
50. B.D.Bangur  Endowment Mumabi  Office. C/O
Graphite India Ltd., Bakthwar
Towers,  Nariman Point
51. Hinduja Foundation Hinduja  House,
Worli,
Bombay
PDF created with FinePrint pdfFactory trial version http://www.fineprint.com52. Rameshwardas Birla
Smarak Kosh
Hospital Avenue
Mumbai
Maharashtra
For Indians pursuing
further studies in
medicine.
Value of scholarship :
Rs.7200/-p.m.in India &
Rs.20,000/-p.m. in
abroad.
53. Sir Vitthaldas Thackersey 2042441 Sir Vithaldas chambers, 
16, Apollo street,
Near Mumbai house,
Mumbai- 400 023
54. Shriyans Prasad
charitable trust
2
nd
floor, Nirmal building,
Nariman point
Mumbai- 400 021
55. Somaiya Charitable trust: c/o Godavari Sugar mills,
Next to Davar’s college,
3
rd
floor,
Mumbai – 400 001
56. Jagjivan Vibbanji 
charitable trust
Mann Mansion,
Shaheed Bhagat singh road,
Mumbai – 400 001
57. Maneckji and Shirinbai 
Netterwalla foundation
2017130 /
2015895
Liberty building,
Sir Vithaldas Thackersey
Marg,
Mumbai – 400 020
58. MUMBAI  UNIVERSITY 
SCHOLARSHIPS:
1) SIR MANGALDAS NATHUBHAI
TRAVELLING FELLOWSHIPS.
2) SIR MANGLADAS NATHUBHAI
TECH.  SCHOLARSHIPS
3) SIR CURRIMBBHOY IBRAHIM
SCHOLARSHIPS
4) C.I. PATEL SCHOLARSHIPS
Only for Mumbai university
students. I do not know if these
scholarships are available for
studies ABROAD. Please verify
this and send me an email
(siddharthkharkar@yahoo.com)
59. S.R. Bomanji Charitable 
trust
60, FORBES STREET
MUMBAI  – 400 001.
PDF created with FinePrint pdfFactory trial version http://www.fineprint.com60. HASANBBHOY
JEEJEEBHOUY TRUST
2618446 BALLARD HOUSE,
ADI MARZBAN PATH,
BALLARD ESTATE,
MUMBAI – 400 039
61. ESSAR Scholarships: CORPORATE  
COMMUNICATION DEPT.
INVESTORS RELATIONS
GROUP
PLOT NO.  82,
SURVEY 104
LAXMI UMAJI GADKARI
MARG
ANIK CHEMBUR
62. G.D. GOKHALE TRUST 90 MUMBAI CHEMICALS
5TH  FLOOR,
MANKECJI WADIA BLDG
NR. CHICAGO ROAD
MUMBAI
63. Aga Khan Foundation Diamond Jubilee Trust
Aga Hall
Nezbitt Road
For Khoja Muslims only
64. Shambhekar Trust Udyog Bhavan,
Tilak road,
Pune – 411 002
65. Hargobind Foundation Medical Fellowships 
PO Box No 11703,
Nariman point,
Mumbai.
Division: Maharashtra
Eligibility:
a) He/She should be MBBS with qualification.
b) Postgraduate qualification.
c) Should have minimum experience of 3 years or must have special achivements to his /her credit.
d) Must have obtained admission in Universities /Medical Institution /college/Public hospitals in
U.S.A.,Europe,,U.K.or Australia.
e) Must have "JI" visa.
f)Should give an undertaking /sign a Bond that he /she would stay in Medical field in India for atleast
5 years after completing his/her training in U.S.A.,Europe,U.K.Australia.
PDF created with FinePrint pdfFactory trial version http://www.fineprint.comOther Scholarships in Delhi:
Please inform me once you know the phone numbers of these institutions.
Also, mail me about discontinued scholarships, or incorrect phone numbers or addresses. Someone is
doing this for you; you owe it to everyone to send in the corrections. I hope you agree… J
 Please mail me at siddharthkharkar@yahoo.com or oncogen@kemates.com
 Please don’t be selfish, and you won’t lose. J
Scholarship Phone
Number
Address Comments
1. Agatha Harrison Memorial
Fellowship
Scholarships The Ministry of
Education and Social Welfare
Dept. of Education
E.S. 5 Section Room No. 517
B Wing
Shastri Bhavan
New Delhi 110 001
For PhD degree Indian
nationals aged 30-40
years old.
2. Anand Charitable Trust 100 Jor Bagh
New Delhi 110 003
3. Charanjiv Charitable Trust Charanjiv Charitable Trust
11d Ansal Bhawan
16 Kasturba Gandhi Marg
New Delhi 110 001
India Students should
have a good academic
record with 60% marks in
H.S.C./P.U.C. or
equivalent or graduation,
etc. Annual income less
than Rs. 12,000.
4. Citibank Cambridge
Scholarships
Cambridge Commonwealth
Trust (TPG)
c/o the Nehru Trust for
Cambridge University
Teen Murti Marg.
New Delhi 110 011
For Finance and
Economics. Amount: Air
fare, tuitions fees and
maintenance allowance.
5. Dr. Amedkar Overseas
Fellowships
Dr. Ambedkar Foundation
25 Ashoka Road
New Delhi 110 001
Fellowships for
postgraduates, doctoral,
research in law,
Economics, sociology,
international relations.
Amount: US $8,400 P.A.
+ U.S. $1,200 P.A.
6. Dr. P.N. Behl Foundation
Scholarships
Dr. P.N. Behl Foundation
N Block
Opposite of Lady ShriRam
College for Women
Greater Kailash
New Delhi 110 048
INDIA
PDF created with FinePrint pdfFactory trial version http://www.fineprint.com7. Raunaq Education
Foundation
Rannag Management and
Personnel Consultancy
Services
17 Parliament Street
New Delhi 110 011
Medical Institutions
engaged in research and
relief work and students
engaged in such activity.
8. S.J. Jindal Trust Jindal Trust, 1/6 - B
Asaf Ali Road
New Delhi 110 001
Degree Course in
Engineering, Medicine,
Science, Commerce,
Agriculture
and Education. Not less
than 60% marks in
aggregate. Annual
income less
than Rs 5,000.
9. Sahu Jain Trust Trust Times of India House
4th Floor
7 Bahadursha Zafar Marg
New Delhi 110003
10. Aga Khan Foundation 3782157 / 73
/ 85
fax. 3782174
Sarojini house,
2
nd
floor,
6, bhawandas road
New Delhi – 110 001.
Forms available from 1st
January. Last date for
submission is 31st March
for Postgraduate Studies.
PDF created with FinePrint pdfFactory trial version http://www.fineprint.comMiscellaneous (i.e. Scholarships elsewhere)
Scholarship Phone
Number
Address Comments
CHENNAI
1. Janaki Ramachandran
Educational Trust
483 3045 31 Doraisamy Road
Chennai 600 026
2. Jeppiaar Educational
Trust
496 1179
jprsatya@vsnl.com
Jeppiaar Nagar
Chennai 600 119
3. Maharatta Education
Fund
The Hon. Secretary
Maharatta Niwas
219 Mowbrays Road
Chennai 600 018
India Professional and
Technical Studies. For
Marathi speaking students in
South India
4. MGR Memorial
Charitable Trust
435 9094
mgr@vsnl.com
MGR Memorial House
27 Arcot Street
Chennai 600 017
http://education.vsnl.com/mgr
5. The Tamil Nadu
Educational Trust
Rajah Annamalai
Building
18-A Marshall's Road
Egmore, Chennai 600
008
Parent's Income should not
exceed Rs. 12,000-p.a.
AHEMDABAD
1. Lalbhai Dalpatbhai
Charity Trust
Sheth Lalbhai
Dalpatbhai Vanda
Pankornaka
Ahmadabad 380001
OR
Pankari Naka
Ghenkanta Trust
Ahmedabad 1
PDF created with FinePrint pdfFactory trial version http://www.fineprint.comOTHERS
1. H.E.H. The Nizam
Charitable Trust
Trust Haveli Manjili
Begum
Shah Ali Banda
Hyderabad 2
2. Neichu Foundation The Managing Trustee
Neichu Foundation
C/O Needle Industries
Ltd.
Nilgris, TamilNadu
 643 243
Parental Income below Rs.
750/-p-m.
Must be Nilgris resident.
3. Taraknath Das
Foundation
(212) 854-2592
or
(212) 854-8017
c/o Southern Asian
Institute
Columbia University
420 West 118th Street
New York,
NY 10027-7296
http://www.columbia.edu/cu/
sipa/REGIONAL/SAI/tdas.html
Amount: $3,500.
4. Birla Education trust Pilani,
RAJASTHAN
5. ITC limited Virginia house
37, Chowringhee lane,
CALCUTTA – 700 071
PDF created with FinePrint pdfFactory trial version http://www.fineprint.com
Read More

Postgraduate Scholarships for Indian Students


Postgraduate Scholarships for Indian Students 
ALL INDIA SCHOLARSHIP, SCHOLARSHIP, SCHOLARSHIP FORM, Others, Top Level Exam,
 
$400,000 Scholarship scheme in Engineering, Science and Technology for 2012
Queen’s University Belfast is offering up to 100 scholarships to talented Indian
students enroling in postgraduate engineering, science, innovation and technology programmes
in September 2012.
 
Queen's University Dr APJ Abdul Kalam Scholarships 
Number of awards Value of Award Tuition Fee Net Fee
100  £2,500 ($4,000 approx)  £14,460  £11,960
 
Eligibility Criteria:
• Candidates must be Indian nationals and must be eligible to pay overseas tuition fees
(non EU).
• Candidates must demonstrate outstanding academic achievement in their studies.
• Candidates can be studying on postgraduate taught or postgraduate research
programmes within the named Schools.
• Candidates must not be in receipt of any other Queen’s University Belfast scholarship or
tuition fee reduction.
Scholarship awards will be deducted from the tuition fees payable to Queen’s upon
enrolment in September 2012, and will be payable in pounds sterling.
• Students must be able to finance the remainder of their tuition fees and living expenses.
Scholarships cannot be deferred and are solely for enrolment in September 2012.
 
Application procedures:
• There is no need to make a separate scholarship application. All eligible candidates will
be considered on the basis of their course/ programme online application.
• Early application will increase the chances of candidates being awarded a scholarship.• Full information about the scholarship will be sent by the Admissions and Access Service
to eligible candidates with their conditional or unconditional offer letter.
• Candidates with an unconditional offer must accept their offer online as indicated in their
offer letter, and pay a deposit of £2,000 within one month of receiving their offer.
• Candidates with a conditional offer must accept their offer online as indicated in their offer
letter, then inform the Admissions and Access Service (intl.student@qub.ac.uk) when they have met the
condition(s) of their offer. Applicants should scan and email evidence of their academic and/or
English Language qualifications to the Admissions and Access Service, and pay a deposit of
£2,000 within one month of meeting the condition(s) of their offer.
• Once the deposit has been confirmed as received by the Queen’s Income and Student
Finance Department, an award letter will be sent to successful candidates by the International
Office. Please allow approximately one week for the bank transfer to take place.
For further information, please contact Ms Isabelle Husillos (i.husillos@qub.ac.uk).
 
Scholarships are available for postgraduate taught courses in the following Schools.  Postgraduate research programmes within
these Schools are also eligible.
School of Chemistry and Chemical Engineering    
MSc in Chemical Research
MSc in Chemical Biology
MSc in Process Engineering
• School of Electronics, Electrical Engineering and Computer Science
MSc Advanced Wireless Communications
MSc Electronics
MSc Telecommunications
MSc Educational Multimedia
MSc Sustainable Electrical Energy Systems
MSc Software Development

MSc Polymer Engineering
MSc in Advanced Mechanical Engineering
• School of Planning, Architecture and Civil Engineering
MArch Architecture
MSc Construction and Project Management
MSc Durability of Structures
MSc Environmental Engineering
MSc Environmental PlanningMSc Spatial Regeneration
MSc Sustainable Design
MSc Urban and Rural Design
MSc Water Resources Management

MA in Sonic Arts
NB.  Only postgraduate research programmes in the subject area of Sonic Arts will be eligible
within this School

For further information and details on the degree programmes, please check the Course Finder.
 
Read More

TOEFL Test Skills and Sample Reading Skills, Listening Skills, Speaking Skills, Writing Based


TOEFL Test Skills and Sample 


Reading Skills

Tofel Exam, Top Level Exam, Education, Online Exam, Question Paper,

Tofel Exam, Top Level Exam, Education, Online Exam, Question Paper,


Listening Skills

Tofel Exam, Top Level Exam, Education, Online Exam, Question Paper,

Tofel Exam, Top Level Exam, Education, Online Exam, Question Paper,


Speaking Skills  Speaking About
Familiar Topics

Speaking Skills  
Speaking About
Campus Situations

Speaking Skills

Speaking About
Academic Course
Content

Tofel Exam, Top Level Exam, Education, Online Exam, Question Paper,


Tofel Exam, Top Level Exam, Education, Online Exam, Question Paper,

Tofel Exam, Top Level Exam, Education, Online Exam, Question Paper,






Writing Skills
Tofel Exam, Top Level Exam, Education, Online Exam, Question Paper,

Tofel Exam, Top Level Exam, Education, Online Exam, Question Paper,

Tofel Exam, Top Level Exam, Education, Online Exam, Question Paper,

Tofel Exam, Top Level Exam, Education, Online Exam, Question Paper,


Writing Based
on Reading and
Listening
Read More

Sunday, February 3, 2013

Step by Step Guide to apply for MS in US GRE and TOEFL exams


Step by Step Guide to apply for MS in US
Education, Tofel Exam, Top Level Exam, GRE, Others, Online Exam,

Why study in the USA?
Well Students prefer USA because a degree from a US university is recognized globally.
It gives you a platform for excellent career growth. There are various factors. The
academic world in the US is far more diverse in terms of educational resources. The
educational system exploits the student's strengths and abilities to the fullest.
Thousands of students go to the US annually for higher education. Many students who
consider an education in US fail to get sufficient information and advice based on their
individual needs and abilities, as well as the many differences in American
universities.As a result they may secure admission in a university with expectations that
cannot be fulfilled. To avoid finding yourself in such a situation plan well in advance and
obtain all the information you need.

The procedure to apply to the universities in USA.

1. Give your GRE and TOEFL exams. If possible decide on at least 3 or 4

universities before u give the exam. This will help you save a lot of money: (15 * 4
= $60) on GRE score reports and (17*4 = $68) on TOEFL score reports. ETS
sends official GRE score reports to 4 universities and official TOEFL scores to 4
universities free of cost.

2. For the GRE exam solve as many papers as possible.

3. If you are applying for the fall semester (starts in August) then send your pre-

application (request the university to send the form and brochure) by May or first
week of June.

4. Once you receive the forms and brochure, decide on the universities that you are

going to apply to. The choice of the university should be made based on the
following factors:

*The university should offer the field of your choice.
*The ranking of the university should suit your needs.
*If you need aid, it is normally the highly ranked universities that have funds.

msinusblog.com – reference blog for international students who want to apply to graduate schools in US

msinusblog.com – reference blog for international students who want to apply to graduate schools in US

Choose universities that have sufficient funds i.e. the university should be known
to have offered many scholarships in the past.
*Choose universities where you have seniors (performing academically well
there) so that they are positively disposed towards you (and other students from
your college here).

5. Once you have decided on the universities, take recommendations from 2 or 3

professors as per the requirement of the university.

6. Apply for official transcripts from college.

7. Preferably finish the recommendation and transcript work in October because

professors tend to go on vacation towards the end of the semester (i.e.
November).

8. Write your Statement Of Purpose (SOP).

9. Fill the application form and also send a resume with each application

10. The financial document is not a necessity for admission. It can be submitted after

the admission is received.

11. With each application the following documents should be present even though

not explicitly mentioned in the form :

*Statement of Purpose
*Recommendations
*Resume
*Photocopies of certificates (if applicable)
*Photocopy of GRE and TOEFL score report
*Checklist stating the list of items in the packet
*If you aren't sending the financial document, then write a letter stating that you
will send it later.
*If you have undergone training then make a separate list of courses done
*Emphasize on the work experience

msinusblog.com – reference blog for international students who want to apply to graduate schools in US

msinusblog.com – reference blog for international students who want to apply to graduate schools in US

Application Time Table

June-August

* Think about your educational future and career prospects at home
* Talk with your family about financial resources
* Read the section on Selecting a University
* Visit an educational advising center and become familiar with the application process.
* Register for tests such as the TOEFL, SAT, SATII, GRE, or GMAT

August-November

* Take entrance tests
* Attend university fairs
* Research universities and identify between four and ten that meet your needs

December-March

* Pay careful attention to deadline dates.
* Submit a winning application to at least three universities

April-May

* Letters of acceptance or rejection arrive.
* Read acceptance letters carefully. Many institutions require a separate application for
housing.
* Choose the university you want to attend.
* Send letters of regret to universities you will not attend.
* Seek information about applying for a visa

June-July

* Apply for a student visa
* Make travel arrangements
* Attend a pre-departure orientation program at your school or at an educational
advising center.

August

* Arrive in time to attend the university’s orientation program for new students
* Be prepared for an excellent academic experience

msinusblog.com – reference blog for international students who want to apply to graduate schools in US

msinusblog.com – reference blog for international students who want to apply to graduate schools in US

What is Graduate Record Examination (GRE) ?

The GRE is one of the most important examinations to be taken by a student aspiring to
go for further studies abroad. The GRE is a Computer Based Test (CBT) . You need to
know about the testing style which is vastly different from the paper based testing
format .The CBT is an adaptive test and the level of difficulty increases with each
correctly answered question.

The first few questions are supposed to be very important from the scoring point of
view. The score does vary a lot on account of later questions but the initial questions are
make or break.

Some important points about the GRE:

1. It is required for admission to most universities in the USA.
2. Take it once and properly. Not only is it costly but also time consuming to go through
the rigours of taking the GRE.
3. Some Universities consider the latest score, some the best score and some the average
of all scores. So don't take a chance with the GRE. Take it when you are really well
prepared.
4. The GRE score is valid for 5 YEARS.

When to appear for the GRE?

1. The best time to take the GRE is 5TH SEM / 6TH SEM.
2. The last you can take the test and be in time for deadlines is 7th sem.
3. Register for the GRE well in advance so not to miss the test during the intended
period and also to avoid going too far off cities such as Bangalore to take the test.

The Official GRE Page


msinusblog.com – reference blog for international students who want to apply to graduate schools in US

msinusblog.com – reference blog for international students who want to apply to graduate schools in US

GRE preparation Tips

You need to prepare sincerely for at least 3 months. Actually it also depends on the
individual taking the test. If you are good at the word lists (VERBAL) then it would take
you much less time. But the verbal section is the one which makes the difference
between a good score and an excellent one. So do all the 50 word lists from BARRON'S
properly. It sure goes a long way in improving your GRE score.

For analytical sections , practice as much as possible. Take as many tests / sections for
this. It would help to take both the paper based and CBT for practice. Though the
scoring would be certainly different on the paper based tests , the practice is invaluable .
Also many CBT tests would not be easily available so the CBT alone would not be
sufficient practice.

Nowadays, the Quantitative section is becoming tough . Questions on probability ,
statistics are appearing on every test . It would be advisable to ask friends who have
appeared for the CBT before on the type of questions that appeared on the test.

GRE Preparation Tips

http://www.petersons.com/testprep/default.asp?id=880&path=gr.pft.gre

msinusblog.com – reference blog for international students who want to apply to graduate schools in US

msinusblog.com – reference blog for international students who want to apply to graduate schools in US

What is TOEFL?

Test of English as a Foreign Language (TOEFL)

Most of the Universities also make the TOEFL a compulsory test. The TOEFL is a very
simple exam for most students from an English medium background. Compared to the
Verbal section of the GRE, the TOEFL is a cake walk.

Most universities require a score of 80 / 120 in TOEFL iBT and 213/300 in TOEFL CBT.
It is easy to score much more than this.

When to appear for the TOEFL?

1) The best time to take the TOEFL is 6TH SEM / 7TH SEM.
2) The last you can take the test and be in time for deadlines is 7th SEM.
3) Register for the TOEFL well in advance so not to miss the test during the intended
period and also to avoid going too far off cities such as Bangalore to take the test.!
TOEFL preparation

For the TOEFL, the preparation required is meager. Most students just take all the tests
from the Barron’s. Other preparatory material is Princeton's

The Official TOEFL page

Click Here

TOEFL Preparation Tips

http://www.petersons.com/testprep/toefl.asp?id=3567&path=ug.pft.toefl

TOEFL iBT Pattern and Details.
I wrote TOEFL iBT and before taking the test I had two options, either to take TOEFL
CBT or TOEFL iBT. All my friends recommended me to take CBT since they said that
the new pattern has speaking section and so the old pattern in much easier. But I still
went ahead and gave the iBT pattern. Well to be true the new format is quite easy and

msinusblog.com – reference blog for international students who want to apply to graduate schools in US

msinusblog.com – reference blog for international students who want to apply to graduate schools in US

you can score high with a little bit of preparation. The speaking section is not that tough.
The only tip which I would like to give you guys is that don't try to speak differently.
They are not looking for American accent. Since you are speaking into the microphone
the only thing you have to do is speak slowly and clearly, yes I would emphasize on the
word clearly and you will end up with a high score. Well don't get tensed by seeing other
speaking really fast English. Be relaxed and take your time.

Well for more details on the TOEFL iBT pattern and details go to

http://www.petersons.com/common/article.asp?
id=1149&path=gr.pft.advice&sponsor=1

Tips and Strategies

http://www.petersons.com/testprep/tips.asp?id=3569&sponsor=1&path=gr.pft.toefl

http://www.petersons.com/ugchannel/file.asp?id=1073&sponsor=1&path=gr.pft.toefl

Test Info

http://www.petersons.com/testprep/test_info.asp?
id=3570&sponsor=1&path=gr.pft.toefl

msinusblog.com – reference blog for international students who want to apply to graduate schools in US

msinusblog.com – reference blog for international students who want to apply to graduate schools in US

Tips for Statement of Purpose (SOP)

The SOP is one of the most vital components of your application packet. The SOP is a
personal essay which is to be written by each applicant. The SOP is supposed to give a
clear idea to the admissions committee about your goals and academic interests.

The SOP is generally one page long made up of 4 - 6 paragraphs. The SOP must address
the following issues:

* Reason for pursuing higher studies.
* Research and academic interests
* Goal in life
* Personal strengths and weaknesses
* Academic and other achievements
* Related experience / projects undertaken
* Reason for applying to the university

It is a good idea to go through the SOPs of your seniors and other students applying to
other departments .Get your SOP checked for errors and grammatical mistakes.Such
errors will create a bad impression and may prove costly.

Start working on your SOP by September end try and get it done by October.

Also Check out these websites

http://www.statementofpurpose.com/

http://www.infozee.com/application-issues/sample/sop-engg.htm

http://www.desigrad.com/~desigrad/desi_grad/sop.php

http://www.desigrad.com/sop.php

http://www.achieverspoint.com/apply/samplesop.htm

http://www.infozee.com/channels/ms/app-issues/sop.htm

msinusblog.com – reference blog for international students who want to apply to graduate schools in US

msinusblog.com – reference blog for international students who want to apply to graduate schools in US

Tips for Letters of Recommendations (RECOS)/ Recommendation Lettters

The Letters of recommendations are a vital part of the application package. These
RECOS are letters from your professors who have taught you during your under
graduate course. All most all the universities require that you send 3 recos.

The recos should ideally be from professors who have taught you core subjects in your
field of specialization eg Operating Systems, TCS .

You can also ask professors who have taught you subjects such as Applied Mathematics
and Discrete Structures, for recos.

A recommendation letter from the HOD of your major field is very vital and would
definitely be an edge over the completion.

Do all professors write their own recos?

Well, some professors write the reco themselves while some ask the students to write it
themselves according to a pattern. If the professor writes the reco himself, it saves you
the trouble. But if you have to write it yourself you have to be very careful.

Remember that many of your class-mates might take recos from the same profs and also
might apply to the same places.So you must be extra careful while writing the reco. You
can ask some of your friends or family members to write a reco for you. One you can
write on your own.The aim should be to try and see that the 3 recos sound as if written
by different people and not written by the same person. You should also try and
highlight your plus points and academic achievements in the 3 recos. Try and focus on
different aspects in the 3 recos such has programming skills, team work , motivation for
future studies , academic performance with respect to the class ie top 10 % of the class
,etc.

Some Universities have their own reco formats?

Some universities send recommendation forms in their own format. They have columns
where the recommender compares the student with his batch mates on various
grounds . These could be mental ability, team work , motivation for higher studies ,
verbal skills , expressiveness etc. Basically the same things which are written in the reco
by the professor or rather by you!

If possible you must ask the professor to fill these forms as well. Some professors may
not fill them. Generally these are optional and the university says so in the brochure.
Whenever in doubt you must contact the college by email and clear your doubt.

msinusblog.com – reference blog for international students who want to apply to graduate schools in US

msinusblog.com – reference blog for international students who want to apply to graduate schools in US

The recos are also to be sent in sealed envelopes with the signature of the recommender
on the flap.

When do I ask for recos?

Since the whole application procedure is so lengthy and time consuming, you should try
and be on your heels throughout the application stage. Many professors may not give
recos to all students or if they have already given a lot of recos. Approach the professors
well in advance and let them know of your academic pursuits and that you would like
them to write a reco for you. Even if you take the actual reco much later , once the prof
assures you of a reco , he won’t refuse you later.

If you plan to get the college reco forms filled as well as sending a typed letter, then you
will have to finalize your univs first. Also ask the prof if he would be filling in the college
forms as well. Thus, how quickly you get the recos done in this case , depends on how
fast you finalize you univs.

But just with the intention of doing this first or early, don't compromise on the effort
that you put in shortlisting your univs. This is crucial.

On the other hand if you intend to send only the typed letter then you can get the recos
done a little earlier.

Also Check out these websites

http://www.statementofpurpose.com/recos.html

http://www.dickinson.edu/career/files/lettersofrecforfaculty.pdf

http://career.berkeley.edu/Grad/GradLetter.stm

msinusblog.com – reference blog for international students who want to apply to graduate schools in US

msinusblog.com – reference blog for international students who want to apply to graduate schools in US

Sample Resume for MS in US Application

TIPS FOR RESUME

The purpose of a resume is to disclose your accomplishments and
qualifications to the admissions committee. Think of your resume as a
promotional brochure about you. You need to show the committee what you have
accomplished and where your experience lies. Your strategy should be to emphasize the
experience and skills that a particular school is looking for. Your resume is also an
example of your communication and
organizational skills.

Selecting the right format.

There are several acceptable formats for a resume. Based on the amount
of your work experience, you can use one of the following formats:

Chronological:

This is the most common resume style for people with significant work
experience. In the Chronological format, the emphasis is placed on
employment experience. The applicant's job history is presented in reverse
chronological order, with the most recent jobs placed at the top of the list.

Functional:

In this non-linear format, your skills and achievements are emphasized.
Your employment history is summarized and linked to your skills and
achievements. Your skills and previous relevant experience (including
educational experience) are presented at the beginning of your resume. The Functional
resume can be particularly effective if you've held a number of similar positions; it will
allow you to highlight your skills rather than itemize what might be a redundant looking
job history.

Combination:

The Combination resume is simply a Functional resume with a brief
employment history added. Educational qualifications are listed first,
skills and accomplishments are still listed next; the employment history follows. You
need to reveal where you worked, when you worked, and what your job position was.
Emphasize your talents and show how you used them at the job.

msinusblog.com – reference blog for international students who want to apply to graduate schools in US

msinusblog.com – reference blog for international students who want to apply to graduate schools in US

School Specific:

Some schools specify the format for the resume. In most cases, you
will be asked to include all part-time and full time work experiences,
research and project activities, extracurricular interests and
community/civil activities.

Resume writing tips:

Keep it concise

Resumes should be one page, if possible, and two if absolutely
necessary to describe relevant work experience.

Make your words count.

Your use of language is extremely important; you need to sell yourself
to a committee quickly and efficiently.

Avoid large paragraphs (over six or seven lines).

Use action verbs such as "developed," "managed," and "designed" to
emphasize your accomplishments.

Don't use declarative sentences like "I developed the..." or "I
assisted in..."; leave out the "I."

Avoid passive constructions, such as "was responsible for managing."
It's not only more efficient to say "Managed," it's stronger and more
active.

Make the most of your experience

The admissions committee is looking for future business managers and
leaders. They need to know what you have accomplished to have an idea of what you can
add to the program.

Don't be vague. Describe things that can be measured objectively.
Telling someone that you "improved warehouse efficiency" doesn't say much.
Telling them that you "cut requisition costs by 20%, saving the company
$3800 for the fiscal year" does. Employers will feel more comfortable
hiring you if they can verify your accomplishments.

Be honest. There is a difference between making the most of your
experience and exaggerating or falsifying it.

msinusblog.com – reference blog for international students who want to apply to graduate schools in US

msinusblog.com – reference blog for international students who want to apply to graduate schools in US

Don't neglect appearance

Your resume is the first impression you'll make on the committee, and a
successful resume depends on more than what you say; how you say it
counts as well.

Check your resume for proper grammar and correct spelling - evidence of
good communication skills and attention to detail. Nothing can ruin
your chances of getting an admission more than submitting a resume filled with (easily
preventable) mistakes.

Make your resume easy on the eyes. Use normal margins (1" on the top
and bottom, 1.25" on the sides) and don't cram your text onto the page.
Allow for some breathing room between the different sections. Avoid
unusual or exotic font styles; use simple fonts with a professional look.

Eliminate superfluous details

Unnecessary details can take up a lot of valuable space on your resume.

Don't mention personal characteristics such as age, height, and marital
status on your resume. This information is either irrelevant or is
taken care of in other parts of the application. List your hobbies and
interests and extracurricular activities if these are not covered
elsewhere.

For Sample Resumes go to

http://www.i20fever.com/samples/resume/index.html

For Sample Resume for Master of computer science

http://www.asher.com/pdf/ENGRESUME.pdf

msinusblog.com – reference blog for international students who want to apply to graduate schools in US

msinusblog.com – reference blog for international students who want to apply to graduate schools in US

Sample Cover Letter for MS Application

Covering Letter
ABC
B.E Computer Science
XXXXXXXX
XXXXXX
XXXX
XXXXXX
INDIA.

Dear Sir/Madam,
Subject: Submission of application form to Graduate School for MS (Computer Science)
for fall 200X.
I am aspiring student to have further studies at your esteemed university. In regard with
this I am applying for your graduate school for M.S Degree in Computer Science for the
Fall 2003. I am sending all the necessary documents along with filled application form.
Enclosures are as follows:
1.Application DD ( if not payed online)
2.Filled Application form (if not submitted online)
3.An official bank statement and a copy of Affidavit of Support given by Sponsor
4.A copy of Resume(Bio-data)
5.A Statement of Purpose(SOP)
7.Copies of 11th+12th Marks list- Attested by institution head.(2)
8.Copies of B.Tech Memos- Attested by Institution head and University Registrar.(2)
9.Recommendation letters given by HOD and Lecturers.(3)
10.Copies of GRE and TOEFL score reports.

Miscellaneous Documents
1.Prabhava-Paper Presentation certificate (Software Architecture)
2.Service Certificate- Loyola Academy.

Please take note of the following:-
• My university (univ name) does not have the practice of sending Transcripts directly to
universities, so in order to authenticate my transcripts I have requested them to seal and
sign across the envelope.
• I have not produced the Recommendation letters in the format given by you. My
Professors have given their Recommendations on their own letter pads. I request you to
accept my Recommendation letters, which are in a different format.

msinusblog.com – reference blog for international students who want to apply to graduate schools in US

msinusblog.com – reference blog for international students who want to apply to graduate schools in US

University Expenses including Tuition Fee, Living Expenses etc.

Tuition Fees

US Universities fall under two major categories: public (state supported), and private
(independent) institutions. International students’ tuition expenses at state schools are
based on nonresident costs, which are still usually less expensive than those of private
universities. It’s important to note that the cost of a program in a US school does not
necessarily affect its quality.

A brief idea can be had from the following :

University Type Tuition Fees (annual in U.S. Dollars)
Private Institutions (High Cost) >$ 25,000
Private Institutions (Low Cost) >$ 16,000
State Institutions (High Cost) >$ 17,000
State Institutions (Low Cost) >$ 9,000

The tuition fee is different for different universities and varies widely with courses. It
can vary from as low as $ 9000 a year for state universities to as much as $ 30000 per
annum for some private universities. For more specific details, please contact the
universities.

Living Expenses

The approximate annual living expenses are about $10,000, which includes
accommodation as well as other daily expenses. However, the expenses are different for
different people depending on the lifestyles and this is just a rough idea.
So, about $1000 per month is a good estimation. Most people can survive with $700-
$1000 a month. The key here is to share apartments/houses so that you save on the
utilities, fixed charge portion of phone and to some extent on groceries.

Financial Aid & Scholarships

Financial aid is an important factor to consider for students applying abroad. Careful
planning is both necessary and wise. Foreign nationals are required to show proof of
sufficient funds to cover at least the first year of their college education to apply for a
student visa. To compare the total cost of studying in various countries, check out Cost
of Education

The burden of securing necessary funding can be challenging, and sometimes
frustrating. Your savings (or your family's) may be the only reliable source of funding

msinusblog.com – reference blog for international students who want to apply to graduate schools in US

msinusblog.com – reference blog for international students who want to apply to graduate schools in US

you have as you begin your program of studies abroad.

Important: University funding is easier to get in the United States
than in U.K., Canada, Australia or New Zealand. Most students who go to
Australia and U.K. are self funded students.

All about Financial Aid
What is financial AID?
“AID is not free money, one need to work to get money!”

The following form of support is what I refer to as financial AID
· GRA-Graduate Research Assistantship Task: work under a prof , research
· GTA-Graduate Teaching Assistantship Task: Help a prof in class, grading, Lab -
· GA-Graduate Assistantship Task: Work for department eg:webmaster
· Fellowship (rare) Task: Paid for research to very talented guys

And NOT
· SCHOLARSHIP of $3000 or $5000, partial waivers given by some schools, this is not
AID. This is a trap!

Fee?
International students are expected to take 9 credit hours (3 courses) and the general
fee for this will be
Out sate fee: $ 6000 to $ 12000 per SEM
Instate fee: $3000 per SEM to $6000 per SEM

International students are supposed to pay out state fee but with a TA or RA from the
university you pay instate fee; some Univs even waive instate fee for RA’s or TA’s

What do we get if we have TA, RA or GA?
University will waive the students out-state fee and pay you salary- if you get a 10 hour
RA the general salary is 600-700 per month and a 20 hour RA/TA makes 1200-1500$ a
month. (Based on the pay rates of the school). If you get a RA for 10 hours, if you want
you can work for 10 hours in library or anywhere in the campus, International students
are allowed to work for 20 hours a week.

“I got waiver of $ 3000, I got AID”- NO (Why scholarship is not AID)?
Partial waivers are given generally in schools (low ranked schools), which don’t have
money/grants/resources to conduct research and thus no money to pay the students as
a RA/TA/GA Generally students who get a partial waiver never end up getting an RA or
TA, in other words you are given 3000 and made to pay 20,000.

Fee per semester in such schools is generally high, say 10000 per SEM @ 4 sems will be
a total fee of over 40,000 USD. Now these schools attract the students by offering a

msinusblog.com – reference blog for international students who want to apply to graduate schools in US

msinusblog.com – reference blog for international students who want to apply to graduate schools in US

waiver of $ 3000-5000, but the truth is you are paying the remaining $ 35,000. Trust
me this is how it works.

Education Sector in the US Is a big business, these guys are here to make money, the
Education sector in US makes close to 15 billion dollars which is more than what India
makes on IT per annum (we call ourselves as the IT capital of word, huh)

Naveen you are wrong – “my school said I got 3000$ waiver now I may get RA/TA also
after I come to US?

These schools first of all don’t have many Assistantships (TA’s or RA’s), they will have
some but Look when every student is given 3000$ waiver, every student who applied to
this school and got an admit come here because of that waiver, so result more
competition. Finally you won’t get AID?

Not Convincing! Ok, let me defend --What are top ranked schools? Schools that have
research money and grants and places where there are many Undergraduate students
attending.
“We are masters- Graduate students, why are we bothered about undergrads”- TA or
teaching assistant positions are given based on the number of undergrad students, if
school is a good school and more number of Americans attend it; we have more number
of TA’s and more number of Campus jobs- Also federal grants to schools and the other
Govt agencies also depends on number of undergraduate students, if school has good
number of UG’s they good federal grants. Bottom line Department and profs have
money to do research and they hire us to work. Just think: So now your school has not
many Under-grads where will it create the TA positions?

General Trend
· 80 % of students in top 60-70 ranked schools get some form of support or the other
· 40-60 % of students get financial aid in first semester and the remaining get financial
aid after second semester.
· Getting funding from India is hard/ rare as a professor cannot decide if you a good
match for his research

MS in US Application and Admission General FAQ'S
What are the MS requirements?

For masters you have to take courses and do a project. Usually MS requires anywhere
between 30 & 36 credits. For thesis option you take less courses and do a big thesis
project and for non thesis you take more courses and do a small project. So say in a
thesis option you have to do 9 credit hours of research (project) you either take it from
the first semester you come here or hence forth. You can also take 3 credit hours of

msinusblog.com – reference blog for international students who want to apply to graduate schools in US

msinusblog.com – reference blog for international students who want to apply to graduate schools in US

research in one semester and remaining in other semesters. And along with the research
credits you have to take courses. What you can also do is finish your course
requirements and then take research credits. If you are funded from the beginning, then
your advisor might want you to spend some time on research, so he will say take 3
research credits from now along with the courses. So it depends in which situation you
find yourself in. This might sound complicated to you, but do not worry as soon as you
go to US you will understand it.

Is work experience essential for MS ?

For MS generally work experience is not required. I think if you do (very) well in GRE
and your academics, your chances of getting financial aid increases.

What are credit hours/credit points/ degree credits? (Very Important)

Usually students do not bother to understand this term. But it is very essential that one
knows what exactly this means. Every regular subject/course is scheduled for 1 to 5
hours/week. That number is the credits (nothing but the number of hours you put in a
week) you get for that subject. A Masters program consists of a required number of
credit hours, which varies from University to University.

Want to know about the grading system in US?

Universities use alphabets to grade the quality of the students academic performance.
A(4=excellent), B(3=good), C(2=average), D(1=below average) and F(0=fail). You need
to score grade B or more to continue your graduate study.

What is the Grade Point Average (GPA)?

A system of recording academic achievement based on an average, calculated by
multiplying the numerical grade received on each course by the number of credit hours
studied. :-) Ok stop cursing us for that definition. Here is an example that will put the
smile :-) back on your face. Suppose you have taken 3 courses: X, Y & Z each with a
credit hour requirement of 3. Assume your grades in the 3 courses are A, B & A
respectively. Then your GPA will be calculated as : X : 4 * 3 = 12 Y : 3 * 3 = 9 Z : 4 * 3 =
12 Total = 12+ 9 + 12 = 33 GPA = 33 / (3+3+3) = 3.66 That should have made things
clear!!

What's a major?

The area of studies in which you wish to concentrate. This is usually EE (Electrical
Engineering) or CS (Computer Science) or CE (Computer Engineering). Mind you, the
area of specialization differs from a major in that, it is the field in wish to do some

msinusblog.com – reference blog for international students who want to apply to graduate schools in US

msinusblog.com – reference blog for international students who want to apply to graduate schools in US

research viz. VLSI, Computer N/W, Parallel Computing, DSP etc.

How many years does it take to complete MS ?

Masters takes time. On an average it takes 2 years. You have to be very good to finish it
in 1 year. 1.5 years is possible but its safer to think that it will take 2 years. Many
Universities offer a 1 year accelerated course which may sound tempting. But think
carefully before you decide to go for this. It is extremely hectic. Some
students have found even 2 year a tough job.

What to write in an SOP ?

The SOP is supposed to identify to the Univ. what your (1) Interests are in the field you
plan to major in. For e.g.. one can write that he/she is interested in Software
Engineering and Networking. You need to mention why you are interested in these
areas. Maybe you did a project and found yourself drawn to those aspects of the project.
(2) Future plans are. Do you want to get into academia or industry. Either answer is OK.
What role do you see yourself playing wherever you land up (are you going to be a
technical person, a researcher, a teacher). You don't have to get very specific, but you
should think about these things carefully.

Is TOEFL necessary for admission?

If your native language is NOT English and/or you do not have a degree from a
university in an English-speaking country, you will be asked to provide evidence of
English proficiency. Most universities require scores from TOEFL while some
universities administer their own test upon arrival on campus, and a growing number of
universities are accepting the scores from the IELTS. • TOEFL-The Test of English as a
Foreign Language measures the ability of nonnative speakers of English to use and
understand North American English as it is used in college and university settings.
Many universities have a minimum score required entrance to the academic program.
Students with lower scores will be required to take an intensive English language
program. The test is offered on computer throughout most regions of the world. In areas
where access to computer-based testing is limited, a supplemental paper-and-pencil
version of the test is administered. For further information, visit www.toefl.org. •
IELTS-International English Language Testing Systems tests the complete range of
English language skills which will commonly be encountered by students when studying
or training in the medium of English. All candidates take the same Listening and
Speaking Modules. There is an option of either Academic or General Training Reading
and Writing Modules. The Academic option is suitable for candidates planning to
undertake higher education. For further information, go to www.ielts.org.

Why study in the U.S.?

•Worldwide recognition of U.S. degrees •Employers favor U.S. degrees •Wide range of

msinusblog.com – reference blog for international students who want to apply to graduate schools in US

msinusblog.com – reference blog for international students who want to apply to graduate schools in US

educational programs •U.S. universities spend $20,000 per year on each student
compared to $7,225 in Britain, $11,572 in Australia, $12,217 in Canada •Outstanding
facilities, libraries and laboratories •Diverse student body •Opportunity to spend an
additional year in the U.S. getting valuable, relevant work experience

How to Calculate Expenses?

Calculating expenses • Tuition – the cost of instruction is generally charged as a single
amount for the term (semester/quarter). Some universities, and many graduate
programs, based their fees on the number of credits students take • Fees • health
insurance • student activity fee that gives students access to the library, health center
and campus activities • out-of-state fees charged by public universities to ALL students
who cannot prove they are residents of that particular State. • Living Costs • room and
board • transportation • books and supplies

How to obtain a Student Visa?

To obtain a student visa, you must demonstrate that you: • Have the ability and
intention to pursue a course of full-time study. This can be demonstrated by official
acceptance from the college or university that you wish to attend. Some visa officers will
also want to see transcripts and test scores or discuss your plans further. HINT: Be
prepared to tell the visa officer what you want to study, where you want to study, how
you are going to finance your stay in the United States, and what you intend to do with
your degree when you return to your home country. Be prepared to do this clearly and
quickly. • Possess adequate funds to cover all of the costs listed by the university on the
I-20 or IAP-66 form that they will send to you when you are accepted. These costs
include tuition, fees, living expenses, and incidental expenses. As a general rule, the
consular official will want to see a bank draft in the amount of the first year’s expenses
and documentation showing how the money will be found for future years. • Have
sufficiently strong social, economic, and other reasons to leave the United States upon
completion of the projected program of studies. Such reasons can be shown during the
visa interview (if an interview is required), by such means as showing strong family ties
in your home country and/or excellent employment prospects when you return home
with a U.S. degree. • Are able to articulate your reason for studying at a specific
institution

For more Faq's go to

http://www.educationusa.state.gov/faq.htm
Read More

Tuesday, January 29, 2013

Short Question for Oracle,


Oracle, Interview, SQL, Online Exam, Top Level Exam,
3. What is Schema ?
      The set of objects owned by user account is called the schema

      4. What is an Index ? How it is implemented in Oracle Database ?
      An index is a database structure used by the server to have direct access 
      of a row in a table.
      An index is automatically created when a unique or primary key constraint 
      clause is specified in create table command (Ver 7.0)

      5. What is clustres ?
      Group of tables physically stored together because they share common 
      columns and are often used together is called Clusters.

      6. What is a cluster key ?
      The related columns of the tables are called the cluster key. The cluster 
      key is indexed using a cluster index and its value is stores only once for 
      multiple tables in the cluster.

      7. What are the basic element of Base configuration of an oracle Database 
      It consists of
      one or more data files
      one or more control files
      two or more redo log files

      The database contains
      Multiple users/schemas
      one or more rollback segments
      one or more tablespaces
      Data dictionary tables
      User objects (tables,indexes,views etc)
      The server that access the database consists of
      SGA (Database buffer, Dictionary Cache Buffers, redo log buffers,Shared 
      SQL pool)
      SMON
      PMON
      LGWR
      DBWR
      ARCH
      CKPT
      RECO
      Dispatcher
      User process with associated PGA

      8. What is deadlock ? Explain.
      Two processes waiting to update the rows of a table which are locked by 
      the other process then deadlock arises.
      In a database environment this will often happen because of not issuing 
      proper row lock commands. Poor design of front-end application may cause 
      this situation and the performance of server will reduce drastically.
      These locks will be released automatically when a commit/rollback 
      operation performed or any one of this processes being killed externally.

     3.2 Memory Management
      9. What is SGA ? How it is different from Ver 6 and Ver 7 ?
      The System Global Area in a Oracle database is the area in memory to 
      facilitates the transfer of information between users. It holds the most 
      recently requested structural information about the database.
      The structure is Database buffers, Dictionary Cache, Redo Log Buffer and 
      Shared SQL pool (Ver 7) area.

      10. What is Shared SQL pool ?
      The data dictionary cache is stored in an area in SGA called the Shared 
      SQL Pool. This will allow sharing of parsed SQL statements among 
      concurrent users.

      11. What is meant by Program Global Area (PGA) ?
      It is area in memory that is used by a Single Oracle User process.

      12. What is a data segment ?
      Data segment are the physical areas within a database block in which the 
      data associated with tables and clusters are stored.

      13. What are the factors causing the reparsing of SQL statements in SGA ?
      Due to insufficient Shared SQL pool size
      Monitor the ratio of the reloads takes place while executing SQL 
      statements. If the ratio is greater that 1 then increase the 
      SHARED_POOL_SIZE.

      3.3 Logical & Physical Architecture of Database
      14. What is Database Buffers ?
      Database buffers are cache in the SGA used to hold the data blocks that 
      are read from the data segments in the database such as tables, indexes 
      and clusters. DB_BLOCK_BUFFERS parameter in INIT.ORA decides the size.

      15. What is dictionary cache ?
      Dictionary cache is information about the database objects stored in a 
      data dictionary table.

      16. What is meant by recursive hits ?
      Number of times processes repeatedly query the dictionary table is called 
      recursive hits. It is due to the data dictionary cache is too small. By 
      increasing the SHARED_POOL_SIZE parameter we can optimize the size of Data 
      Dictionary Cache.

      17. What is meant by redo log buffer ?
      Changes made to entries are written to the on-line redo log files so that 
      they can be used in roll forward operation during database recoveries. 
      Before writing them into the redo log files, they will first brought to 
      redo log buffers in SGA and LGWR will write into files frequently. 
      LOG_BUFFER parameter will decide the size.

      18. How will you swap objects into a different table space for an existing 
      database ?
      Export the user
      Perform import using the command imp system/manager file=export.dp 
      indexfile=newfile.sql. This will create all definitions into newfile.sql.
      Drop necessary objects.
      Run the script newfile.sql after altering the tablespaces.
      Import from the backup for the necessary objects.

      19. List the Optimal Flexible Architecture (OFA) of Oracle database ? or
      How can we organise the tablespaces in Oracle database to have maximum 
      performance ?
      SYSTEM - Data dictionary tables
      DATA - Standard operational tables
      DATA2 - Static tables used for standard operations
      INDEXES - Indexes for Standard operational tables
      INDEXES1 - Indexes of static tables used for standard operations
      TOOLS - Tool table
      TOOLS1 - Indexes for tools table
      RBS - Standard Operations Rollback Segments
      RBS1,RBS2 - Additional/Special rollback segments
      TEMP - Temporary purpose tablespace
      TEMP_USER - Temporary tablespace for users
      USERS - User tablespaces.

      20. How will you force database to use particular rollback segment ?
      SET TRANSACTION USE ROLLBACK SEGMENT rbs_name

      21. What is meant by free extent ?
      A free extent is a collection of continuous free blocks in tablespace. 
      When a segment is dropped its extents are reallocated and are marked as 
      free.

      22. How free extents are managed in Ver 6 and Ver 7. ?
      Free extents cannot be merged together in Ver 6.0
      Free extents are periodically coalesces with the neighboring free extent 
      Ver 7.0.

      23. Which parameter in Storage clause will reduce no of rows per block ?
      PCTFREE parameter
      Row size also reduces no of rows per block.

      24. What is significance of having storage clause ?
      We can plan the storage for a table as how much initial extents are 
      required, how much can be extended next, how much % should leave free for 
      managing row updations etc.

      25. How does space allocation take place within a block ?
      Each block contains entries as follows :
      Fixed block header
      Variable block header
      Row header, row date (Multiple rows may exists)
      PCTFREE (% of free space for row updation in future)

      26. What is the role of PCTFREE parameter is Storage clause ?
      This is used to reserve certain amount of space in a block for expansion 
      of rows.

      27. What is the OPTIMAL parameter ?
      It is used to set the optimal length of rollback segment.
      28. What is the functionality of SYSTEM tablespace ?
      To manage the database level of transactions such as modifications of the 
      data dictionary table that record information about the free space usage.

      29. How will you create multiple rollback segments in a database ?
      Create a database which implicitly creates a SYSTEM Rollback Segment in a 
      SYSTEM tablespace.
      Create a Second Rollback Segment name R0 in the SYSTEM tablespace.
      Make new rollback segment available (After shutdown, modify init.ora file 
      and Start database)
      Create other tablespace (RBS) for rollback segments.
      Create additional Rollback segment in tablespace (RBS)
      Deactivate Rollback Segment R0 and activate the newly created rollback 
      segments.

      30. How the space utilisation takes place within rollback segments ?
      It will try to fit the transaction in a cyclic fashion to all existing 
      extents. Once it found an extent is in use then it forced to acquire a new 
      extent. (No of extents is based on the OPTIMAL size).

      31. Why query fails sometimes ?
      Rollback segment dynamically extent to handle larger transactions entry 
      loads.
      A single transaction may wipeout all available free space in the Rollback 
      Segment Table space. This prevents other user using Rollback segment.

      32. How will you monitor the space allocation ?
      By querying DBA_SEGMENT table/View

      33. How will you monitor rollback segment status ?
      Querying the DBA_ROLLBACK_SEGS view
      The status available as follows :
      IN USE - Rollback Segment is on-line
      AVAILABLE - Rollback Segment available bur not on-line
      OFF-LINE - Rollback Segment us off-line
      INVALID - Rollback Segment dropped
      NEEDS RECOVERY - Contains data but need recovery or corrupted
      PARTLY AVAILABLE - Contains data from an unresolved transaction involving 
      a distributed database

      34. List the sequence of events when a large transaction that exceeds 
      beyond its optimal value when an entry wraps and causes the rollback 
      segment to expand into another extend.
      Transaction Begins
      An entry is made in the RBS header for new transactions entry
      Transaction acquired blocks in an extent of RBS
      The entry attempts to wrap into second extent. None is available. So that 
      the RBS must extent.
      The RBS checks to see if it is oldest inactive segment
      Oldest inactive segment is eliminated
      RBS extends
      The Data dictionary table for space management are updated
      Transaction Completes.

      35. How can we plan storage for very large tables ?
      Limit the number of extents in the table
      Separate the Table from its indexes
      Allocate sufficient temporary storage

      36. How will you estimate the space required by non-clustered tables ?
      Calculate the total block header size
      Calculate the available data space per block
      Calculate the combined column length of the average row
      Calculate the total average row size
      Calculate the average number rows that can fit in a block
      Calculate the number of blocks and bytes required for the table
      After arriving the calculation add the additional space to calculate the 
      initial extent size for working area

      37. Is it possible to use raw devices as data file and what is the 
      advantages over file system files ?
      Yes.
      The advantages over file system files :
      I/O will be improved because Oracle is bye-passing the kernal while 
      writing into disk.
      Disk Corruption will be very less.

      38. What is a control file ?
      Database's overall physical architecture is maintained in a file called 
      control file. It will be used to maintain internal consistency and guide 
      recovery operations. Multiple copies of control files are advisable.

      39. How to implement the multiple control files for an existing database ?
      Shutdown the database
      Copy one of the existing control file to new location'
      Edit config.ora file by adding new control file name
      Restart the database

      40. What is meant by Redo Log file mirroring ? How it can be achieved ?
      Process of having a copy of redo log files is called mirroring.
      This can be achieved by creating group of log files together, so that LGWR 
      will automatically writes them to all the members of the current on-line 
      redo log group. If any one group fails then database automatically switch 
      over to next group.

      41. What is advantage of having disk shadowing/Mirroring ?
      Shadow set of disks save as a backup in the event of disk failure. In most 
      Operating System if any disk failure occurs it automatically switchover to 
      place of failed disk.
      Improved performance because of most OS support volume shadowing can 
      direct file I/O request to use the shadow set of files instead of the main 
      set of files. This reduces I/O load on the main set of disks.

      42. What is use of rollback segment in Database ?
      They allow the database to maintain read consistency between multiple 
      transactions.

      43. What is a Rollback segment entry ?
      It is the set of before image data blocks that contain rows that are 
      modified by a transaction.
      Each Rollback Segment entry must be completed within one rollback segment.
      A single rollback segment can have multiple rollback segment entries.

      44. What a hit ratio ?
      It is a measure of well the data cache buffer is handling requests for 
      data.
      Hit Ratio = (Logical Reads - Physical reads - Hit Misses) / Logical reads.

      45. When will be a segment released ?
      When Segment is dropped.
      When Shrink (RBS only)
      When truncated (TRUNCATE used with drop storage option)

      46. What are disadvantages of having raw devices ?
      We should depend on export/import utility for backup/recovery (fully 
      reliable)
      The tar command cannot be used for physical file backup, instead we can 
      use dd command which is less flexible and has limited recoveries.

      47. List the factors that can affect the accuracy of the estimations ?
      The space used transaction entries and deleted records does not become 
      free immediately after completion due to delayed cleanout.
      Trailing nulls and length bytes are not stored.
      Inserts of, updates to, and deletes of rows as well as columns larger than 
      a single data block, can cause fragmentation and chained row pieces.

      3.4 Database Security & Administration
      48. What is user account in Oracle database ?
      An user account is not a physical structure in Database but it is having 
      important relationship to the objects in the database and will be having 
      certain privileges.

      49. How will you enforce security using stores procedures ?
      Don't grant user access directly to tables within application
      Instead grant the ability to access the procedures that access the tables
      When procedure executed it will execute the privilege of procedures owner. 
      Users cannot access tables except via the procedure.

      50. What are the dictionary tables used to monitor a database spaces ?
      DBA_FREE_SPACE
      DBA_SEGMENTS
      DBA_DATA_FILES

      51. What are responsibilities of a Database Administrator ?
      1. Installing and upgrading the Oracle Server and application tools
      2. Allocating system storage and planning future storage requirements for 
      the database system.
      3. Managing primary database structures(tablespaces)
      4. Managing primary objects (table,views,indexes)
      5. Enrolling users and maintaining system security
      6. Ensuring compliance with Oracle license agreement
      7. Controlling and monitoring user access to the database
      8. Monitoring and optimising the performance of the database
      9. Planning for backup and recovery of database information
      10. Maintain archived data on tape
      11. Backing up and restoring the database
      12. Contacting Oracle Corporation for technical support

      52. What are requirements one should fulfill to connect to ORACLE as 
      internal?
      Operating system account has the operating system privileges that allow 
      you to connect
      One should be authorised to connect as internal
      Database has a password for internal connections, and you know the 
      password must use a dedicated server

      53. What are the roles and user accounts created automatically with the 
      database ?
      DBA role - Contains all database system privileges
      SYS user account - The DBA role will be assigned to this account. All of 
      the base tables and views for the database's dictionary are store in this 
      schema and are manipulated only by ORACLE.
      SYSTEM user account - It has all the system privileges for the database 
      and additional tables and views that display administrative information 
      and internal tables and views used by oracle tools are created using the 
      username.

      54. What are the database administrators utilities available ?
      SQL*DBA - This allows DBA to monitor and control an ORACLE database.
      SQL*Loader - It loads data from standard operating system files (Flat 
      files) into ORACLE database tables.
      EXPORT(exp) and IMPOER (imp) utilities allow you to move existing data in 
      ORACLE format to and from ORACLE database.

      55. What are the minimum parameters should exist in the parameter file 
      (init.ora) ?
      DB_NAME - Must set to a text string of not more that 8 characters and it 
      will be stored inside the datafiles, redo log files and control file while 
      database creation.
      DB_DOMAIN - It is string that specifies the network domain where the 
      database is created. The global database name is identified by setting 
      these parameters (DB_NAME & DB_DOMAIN)
      CONTROL_FILES - List of control filenames of the database. If name is not 
      mentioned then default name will be used.
      DB_BLOCK_SIZE - The default data block size and is operating system 
      dependent. It cannot be changed after database creation except by 
      re-creating the database.
      DB_BLOCK_BUFFERS - The maximum number of operating system processes that 
      can be connected to ORACLE concurrently. The value should be 5 (background 
      process) and additional 1 for each user.
      ROLLBACK_SEGMENTS - List of rollback segments an ORACLE instance acquires 
      at database startup.
      Also optionally LICENSE_MAX_SESSIONS,LICENSE_SESSION_WARNING and 
      LICENSE_MAX_USERS.

      56. What is a trace file and how it is created ?
      Each server and background process can write an associated trace file. 
      When an internal error is detected by a process or user process, it dumps 
      information about the error to its trace. This can be used for tuning the 
      database.

      57. What are roles ? How can we implement roles ?
      Roles are easiest way to grant and manage common privileges needed by 
      different groups of database users.
      Creating roles and assigning privies to roles.
      Assign each role to group of users. This will simplify the job of 
      assigning privileges to individual users.

      58. What are the steps to switch a database's archiving mode between 
      NOARCHIEVELOG and ARCHIVELOG mode ?
      1. Shutdown the database instance
      2. Backup the database
      3. Perform any operating system specific steps (optional)
      4. Start up a new instance and mount but do not open the database
      5. Switch the database's archiving mode.

      59. How can you enable automatic archiving ?
      Shut the database
      Backup the database
      Modify/Include LOG_ARCHIVE_START = TRUE in init.ora file
      Start up the database

      60. How can we specify the Archived log file name format and destination ?
      By setting the following values in init.ora file
      LOG_ARCHIVE_FORMAT = arch%S/s/T/t.arc (%S - Log sequence number and is 
      zero left-paded, %s - Log sequence number not paded, %T - Thread number 
      left-zero-paded and %t - Thread number not paded). The file name created 
      is arch0001.arc %S is used.
      LOG_ARCHIEVE_DEST = path
      Shut the database and change these parameters in init.ora files.

      61. What is the user of ANALYZE command ?
      To perform one of these function on an index, table, or cluster :
      to collect statistics about object used by the optimizer and store them in 
      the data dictionary.
      to delete statistics about the object from the data dictionary
      to validate the structure of the object
      to identify migrated and chained rows of the table or cluster.

      3.5 Managing Distributed Databases
      62. How can we reduce the network traffic ?
      Replication of data in distributed environment
      Using snapshots to replicate data
      Using remote procedure calls.

          63. What is a snapshot ?
      Snapshot is an object used to dynamically replicate data between 
      distributed databases at specified time intervals. In ver 7.0 they are 
      read only.

      64. What are the various type of snapshots ?
      Simple and Complex.
      65. Differentiative simple and complex, snapshots
      A simple snapshot is based on a query that does not contains GROUP BY 
      clauses, CONNECT by clauses, JOINs, Subquery or a set of operations.
      A complex snapshots contain at least any one of the above.
      66. What is dynamic data replication ?
      Updating or inserting records in remote database through database 
      triggers. It may fail if remote database is having any problem.

      67. How can you enforce referential integrity in snapshots ?
      Time the references to occur when master tables are not in use.
      Perform the references manually immediately after locking the master 
      tables.
      We can join tables in snapshots by creating a complex snapshot that will 
      be based on the master tables.

      68. What are the options available to refresh snapshots ?
      COMPLETE - Tables are completely regenerated using the snapshot's query 
      and the master tables every time the snapshot referenced.
      FAST - If simple snapshot used then a snapshot log can be used to send 
      only the changes to the snapshot tables.
      FORCE - The default value. If possible it performs a FAST refresh; 
      Otherwise it will perform a COMPLETE refresh.

      69. What is a snapshot tag ?
      It is a table that maintains a record of modifications to the master table 
      in a snapshot. It is stored in the same database as master table and is 
      only available for simple snapshots. It should be created before creating 
      snapshots.

      70. When will the data in the snapshot log be used ?
      The data in the snapshot log is used during fast references of the table's 
      snapshots.

      71. What are the pre-requisites to create a snapshot log ?
      We must be able to create a after row trigger on table (i.e. it should not 
      be already available)
      After giving table previleges.
      We cannot specify snapshot log name because oracle uses the name of the 
      master table in the name of the database objects that support its snapshot 
      log.
      The master table name should be less than or equal to 23 characters.
      (The table name created will be MLOG$_tablename, and trigger name will be 
      TLOG$_tablename)

      72. What are the benefits of distributed options in databases ?
      Database on other servers can be updated and those transactions can be 
      grouped together with others in a logical unit.
      Database uses a two phase commit

      73. What is a two-phase commit ?
      Database on other servers can be updated and those transactions can be 
      grouped together with others in a logical unit is called two-phase commit. 
      They are
      The Preparation Phase : An initiating node called the global coordinator 
      notifies all sites involved in the transaction to be ready either commit 
      or rollback the transaction.
      The Commit Phase : If there is no problem with prepare phase, then all 
      sites commit their transactions. If a network or node failure occurs, then 
      all sites rollback their transactions.

      3.6 Managing Backup & Recovery
      74. What are the different methods of backing up oracle database ?
      Logical Backups
      Cold Backups
      Hot Backups (Archive log)

      75. What is a logical backup ?
      Logical backup involves reading a set of database records and writing them 
      into a file. Export utility is used for taking backup and Import utility 
      is used to recover from backup.

      76. What is cold backup ? What are the elements of it ?
      Cold backup is taking backup of all physical files after normal shutdown 
      of database. We need to take
      All Data files
      All Control files
      All on-line redo log files
      Then init.ora file (optional)

      77. What are the different kind of export backups ?
      Full backup - Complete database
      Incremental Backup - Only affected tables from last incremental date / 
      Full backup date
      Cumulative backup - Only affected table from the last cumulative date / 
      Full backup date

      78. What is hot backup and how it can be taken ?
      Taking backup of archive log files when database is open. For this the 
      ARCHIVELOG mode should be enabled. The following files need to be backed 
      up :
      All data files
      All archive log, redo log files
      On control file.

      79. What is the use of FILE option in EXP command ?
      To give the export file name.
      80. What is the use of COMPRESS option in EXP command ?
      Flag to indicate whether export should compress fragmented segments into 
      single extents.
      81. What is the use of GRANT option in EXP command ?
      A flag to indicate whether grants on database objects will be exported or 
      not. Values is 'Y' or 'N'.

      82. What is the use of INDEXES option in EXP command ?
      A flag to indicate whether indexes on tables will be exported.

      83. What is use of ROWS option in EXP command ?
      Flag to indicate whether table rows should be exported. If 'N' only DDL 
      statements for the database objects will be created.

      84. What is the use of CONSTRAINTS option in EXP command ?
      A flag to indicate whether constraints on table need to be exported.

      85. What is the use of FULL option in EXP command ?
      A flag to indicate whether full database export should be performed.
      86. What is the use of OWNER option in EXP command ?
      List of table accounts should be exported.
      87. What is the use of TABLES option in EXP command ?
      List of tables should be exported.
      88. What is use of RECORD LENGTH option in EXP command ?
      Record length in bytes.
      89. What is use of INCTYPE option in EXP command ?
      Type export should be performed. COMPLETE, CUMULATIVE, INCREMENTAL
      90. What is use of RECORD option in EXP command ?
      For incremental exports, the flag indicates whether a record will be 
      stored in data dictionary tables recording the export.
      91. What is the use of PARFILE option in EXP command ?
      Name of the parameter file to passed for export.
      92. What is the use of ANALYSE (Ver 7) option in EXP command ?
      A flag to indicate whether statistical information about the exported 
      objects should be written to export dump file.
      93. What is use of CONSISTENT (Ver 7) option in EXP command ?
      A flag to indicate whether a read consistent version of all the exported 
      objects should be maintained.
      94. What is the use of Log (Ver 7) option in EXP command ?
      The name of file to which log of the export will be written.

      95. What is use of FILE option in IMP command ?
      The name of file from which import should be performed.

      96. What is the use of SHOW option in IMP command ?
      A flag to indicate whether file content should be displayed or not.
      97. What is the use of IGNORE option in IMP command ?
      A flag to indicate whether import should ignore errors encounter when 
      issuing CREATE command.
      98. What is the use of GRANT option in IMP command ?
      A flag to indicate whether grants on database objects will be imported.
      99. What is use of INDEXES option in IMP command ?
      A flag to indicate whether import should import index on tables or not.
      100. What is use of ROWS option in IMP command ?
      A flag to indicate whether rows should be imported. I f this is set to 'N' 
      then only DDL for the database objects will be executed ?
      101. What is the use of FULL option in IMP command ?
      A flag to indicate whether full import should be done or not.
      102. What is the use of FROMUSER option in IMP command ?
      A list of database accounts whose objects should be read from the export 
      dump file.
      103. What is use of TOUSER option in IMP command ?
      A list of database accounts into which objects in the export dump file 
      will be imported

      104. What is use of TABLES option in IMP command ?
      A list of tables to be imported.

      105. What is use of RECORDLENGTH option in IMP command ?
      The length of the record in bytes of the export dump file.

      106. What is use of INCTYPE option in the IMP command ?
      The type of import being performed.

      107. What is use of COMMIT option in IMP command ?
      A flag to indicate whether import should commit after each array. If 'N' 
      then commit will take place at table level

      108. What is use of PARFILE option in IMP command ?
      Name of the parameter file to passed for import command.

      109. What is use of INDEXFILE option in IMP command ?
      If filename is given then all the DDL will be created in the given file.

      110. What is use of DESTROY (Ver 7) option in IMP command ?
      A flag to indicate whether the create tablespace command found in dump 
      files from full exports will be executed.

      111. What is use of LOG option in IMP command ?
      Name of the file to which the log of the import will be written.

      112. Consider a case below : User is taking the backup in the following 
      fashion :
      Type F I I I I C I I I I C I I
      Date 1 2 3 4 5 6 7 8 9 10 11 12 13
      F - Full Backup
      I - Incremental Backup
      C - Cumulative Backup
      Suppose database crash on 14th morning. How can we retrieve the database ?
      Create the database
      Import from the Full backup which was taken on 1st
      Import from Cumulative backups which was taken on 6th
      Import from Cumulative backups which was taken on 1th
      Import from the Incremental backups 12,13 respectively.
      Now the database will be available to latest status provided there is no 
      transaction taken place after the 13th incremental backup.

      113. List the steps to restore the database if data file lost. (Assume  
we are taking hot backups)
      Copy the lost file from the backup to the original location
      Start the instance
      Mount the database
      Recover the database using recover database command
      Open the database

      114. What are the points to be taken care when we are using SQL*Loader for 
      importing data from flat files ?
      Whether table and indexes are properly sized.
      Direct option being used or not (Ver 7)
      If one time load do not create any index until data has been loaded and 
      table size is verified.

      115. What are the advantages of using direct path option in SQL*Loader ?
      It bypasses the normal processing of insert statements and instead writes 
      directly to tables data blocks.
      When direct option is used index become invalid and once the load complete 
      the new key is merged with all old one and bring the status to valid.
      Data should be presorted otherwise it needs the double the size in 
      tablespace.

      116. What are areas a DBA can monitor the database using SQLDBA command?
      DBA can monitor the following areas to do fine tuning of the database :
      Processes
      Sessions
      Tables(Locks etc)
      SQL Area
      Library Cache
      Latch
      Locks
      File I/O
      System I/O
      Rollback Segments
      Statistics (System, Sessions)
      Apart from this all DBA activities can be performed through SQLDBA 
command.
      DDE ¡V OLE

      DDE - Dynamic Data Exchange.
      DLL - Dynamic Link Library
      OLE - Object Linking and Embedding.
      MAPI ¡V Messaging Application Program Interface
Read More