Tuesday, 31 January 2017

ING Vysya Bank Recruitment

ING Vysya Bank Recruitment


ING Vysya Bank Recruitment 2017 - Clerk , PO and SO Vacancies :

Apply Online for ING Vysya Bank Recruitment notification 2017 for freshers. ING Vysya Bank Recruitment 2017 Job Openings in India for the Vacancies of Clerks , PO's, and Managers. Interested and Eligible Candidates can apply Online for ING Vysya Bank Careers through below provided registration link.
Good news for the Candidates who are eagerly waiting for the ING Vysya Bank recruitment notification.Finally the bank has announced various job Openings across India.Candidates can practice ING Vysya Bank Previous Papers to crack the exam and can go through the ING Vysya Bank syllabus and exam pattern.
So this will help you to clear the preliminary and mains exams. Here you can find latest Job Updates of ING Vysya Bank .
Company Name ING Vysya Bank
Qualification Any Graduate / Any Post Graduate
Experience Freshers (2017 / 2016 / 2015 / 2014 pass outs)
Job Location Across India
Job Role Clerks, PO's ,Specialist Officers and Managers
Package Best in Market
Industry Banking
Website www.ingvysya.kotak.com

Latest Job Openings in ING Vysya Bank:



  • Bank Teller
  • Bank Clerk
  • Bank PO (Probationary Officer)
  • Specialist Officers
  • Data Entry Staff
  • Financial Analyst
  • Loan Officer
  • Financial Manager
  • IT Engineers
  • BPO Staff
  • Customer Care Executives
  • Bank Security Guards
  • ATM Guards
  • Customer Relationship Mangers
  • Accountants
  • Field Officers
  • Marketing Executives
  • About ING Vysya Bank :

    NG Vysya Bank (Kannada: ಐ.ಎನ್.ಜಿ ವೈಶ್ಯ ಬ್ಯಾಂಕ್ ಲಿಮಿಟೆಡ್) was a privately owned Indian multinational bank based in Bangalore, with retail, wholesale, and private banking platforms formed from the 2002 purchase of an equity stake in Vysya Bank by the Dutch ING Group. This merger marked the first between an Indian bank and a foreign bank.[3] Prior to this transaction, Vysya Bank had a seven-year-old strategic alliance with erstwhile Belgian bank Banque Bruxelles Lambert, which was also acquired by ING Group in 1998. As of March 2013, ING Vysya was the seventh largest private sector bank in India with assets totaling ₹54,836 crore (US$8.1 billion) and operating a pan-India network of over 1,000 outlets, including 527 branches, which serviced over two million customers.[1][4] ING Group, the highest-ranking institutional shareholder, held a 44% equity stake in ING Vysya Bank, followed by Aberdeen Asset Management, private equity firm ChrysCapital, Morgan Stanley, and Citigroup, respectively.[5] ING Vysya had been ranked the "Safest Banker" by the New Indian Express and among "Top 5 Most Trusted Private Sector Banks" by the Economic Times.[6] On 20 November 2014, in an all-stock amalgamation, ING Vysya Bank decided to merge with Kotak Mahindra Bank, creating the fourth largest private sector bank in India.[7] On 1 April 2015, the Reserve Bank of India approved the merger. On 15th May 2016 the whole merger process was completed

    Recruitment Selection Process :

    The Selection Process of following Three Rounds
    1. Preliminary Exam
    2. Mains (Who cleared the Prelims Exam)
    3. Interview

    Registration Process :


  • Go to the Official website of ING Vysya Bank.
  • Click on the careers link.
  • Select the link available for the opening.
  • Fill the Application with Required details.
  • Pay the Application Fee to Complete the Registration Process.
  • Eligibility Criteria


  • Should have a degree from the Recognized university with an aggregate of 60% an above in academics without any Backlogs at the time of Applying.
  • Minium Age Limit :20 years (As on 1-1-2017).
  • Maximum Age Limit :30 years
  • If the Percentage marks are in CGPA mode , then they are to be converted into Equivalent Percentage.
  • Document Required (Orginal and Photocopies) :



  • SSC Mark Sheet
  • HSC/Diploma Mark Sheet
  • Graduation & Post Graduation all year's Mark Sheet
  • Photo ID Proof (pan Card/ Passport /Driving License / College ID)
  • Photograph
  • Resume
  • Company Location :

    ING Vysya , Bank Limited,
    (Formerly 'The Vysya Bank Limited'),
    Regisered & Corporate Office, No.22 ,M G Road, Bangalore - 560001.

    How to Apply for ING Vysya Bank Jobs:

    Apply Here
    Note : If you need more details about ING Vysya Bank Recruitment, check the official website.
    Dear job aspirants, get latest updates related to ING Vysya Bank Recruitment 2017 , By clicking on the Link
    Also , you can Bookmark this page.

    Karur Vysya Bank Recruitment -2017

    Karur Vysya Bank Recruitment -2017

    Karur Vysya Bank Recruitment 2017 - Clerk , PO and SO Vacancies :

    Apply Online for Karur Vysya Bank Recruitment notification 2017 for freshers. Karur Vysya Bank Recruitment 2017 Job Openings in India for the Vacancies of Clerks , PO's and Managers. Interested and Eligible Candidates can apply Online for Andhra Bank Careers through below provided registration link.
    Good news for the Candidates who are eagerly waiting for the Karur Vysya Bank recruitment notification.Finally the bank has announced various job Openings across India.Candidates can practice Karur Vysya Bank Previous Papers to crack the exam and can go through the Andhra Bank syllabus and exam pattern.
    So this will help you to clear the preliminary and mains exams. Here you can find latest Job Updates of KVB Bank Bank.
    Company Name Karur Vysya Bank
    Qualification Any Graduate / Any Post Graduate
    Experience Freshers (2017 / 2016 / 2015 / 2014 pass outs)
    Job Location Across India
    Job Role Clerks, PO's ,Engineers
    Package Best in Market
    Industry Banking
    Website www.kvb.co.in

    Latest Job Openings in KVB Bank:



  • Bank Teller
  • Bank Clerk
  • Bank PO (Probationary Officer)
  • Specialist Officers
  • Data Entry Staff
  • Financial Analyst
  • Loan Officer
  • Financial Manager
  • IT Engineers
  • BPO Staff
  • Customer Care Executives
  • Bank Security Guards
  • ATM Guards
  • Customer Relationship Mangers
  • Accountants
  • Field Officers
  • Marketing Executives
  • About KVB Bank :

    Commercial banking in India can boast of a history of about 200 years. Though one could trace the history of banking back to the 19th century, the beginning of the last century saw the birth of many banks in India, set up by people with vision, commitment and national spirit. The Karur Vysya Bank Limited, popularly known as KVB, one such endeavour, was set up in 1916 by two great visionaries and illustrious sons of Karur, the Late Shri M A Venkatarama Chettiar and the Late Shri Athi Krishna Chettiar to inculcate the habit of savings and provide financial assistance to traders and small agriculturists in and around Karur, a textile town in Tamil Nadu. Though the bank started with a seed capital of Rs.1 lakh, it has withstood innumerable changes and challenges in the past few decades and has profitably emerged as one of the leading banks in India without compromising on its fundamentals. The bank is professionally managed and guided by the Board of Directors drawn from different fields with vision, experience, knowledge and business acumen. Shedding its inherent regional flavour, the bank has now spread its wings far and wide with over 675 branches in 20 States and 3 Union Territories in order to gain a pan India presence. The bank has been conducting its affairs meticulously to conform to all the prudential norms and exacting statutory regulations. KVB has consistently maintained strong fundamentals with a higher percentage of Capital Adequacy Ratio than mandated by the RBI. KVB has also been generating profits and rewarding its stakeholders with handsome dividends since inception..

    Recruitment Selection Process :

    The Selection Process of following Three Rounds
    1. Preliminary Exam
    2. Mains (Who cleared the Prelims Exam)
    3. Interview

    Registration Process :



  • Go to the Official website of Karur Vysya Bank.
  • Click on the careers link.
  • Select the link available for the opening.
  • Fill the Application with Required details.
  • Pay the Application Fee to Complete the Registration Process.
  • Eligibility Criteria



  • Should have a degree from the Recognized university with an aggregate of 60% an above in academics without any Backlogs at the time of Applying.
  • Minium Age Limit :19 years (As on 1-1-2017).
  • Maximum Age Limit :26 years
  • If the Percentage marks are in CGPA mode , then they are to be converted into Equivalent Percentage.
  • Document Required (Orginal and Photocopies) :



  • SSC Mark Sheet
  • HSC/Diploma Mark Sheet
  • Graduation & Post Graduation all year's Mark Sheet
  • Photo ID Proof (pan Card/ Passport /Driving License / College ID)
  • Photograph
  • Resume
  • Company Location :

    NO. 633-637 ,I ST Floor,
    Jawahar Bazaar,
    Karur - 639001.

    How to Apply for Karur Vysya Bank Jobs:

    Apply Here
    Note : If you need more details about Karur Vysya Bank Recruitment, check the official website.
    Dear job aspirants, get latest updates related to Karur Vysya Bank Recruitment 2017 , By clicking on the
    Link
    Also , you can Bookmark this page.

    Canara Bank Recruitment- 2017

    Canara Bank Recruitment- 2017

    Canara Bank Recruitment 2017 - Clerk , PO and SO Vacancies :

    Apply Online for Canara Bank Recruitment notification 2017 for freshers. Canara Bank Recruitment 2017 Job Openings in India for the Vacancies of Clerks , PO's and Specialist Officers. Interested and Eligible Candidates can apply Online for Canara Bank through below provided registration link.
    Good news for the Candidates who are eagerly waiting for the Canara Bank recruitment notification.Finally the bank has announced various job Openings across India.Candidates can practice Canara Bank Previous Papers to crack the exam and can go through the Canara Bank syllabus and exam pattern.
    So this will help you to clear the preliminary and mains exams. Here you can find latest Job Updates of Canara Bank.
    Company Name Canara Bank
    Qualification Any Graduate / Any Post Graduate
    Experience Freshers (2017 / 2016 / 2015 / 2014 pass outs)
    Job Location Across India
    Job Role Clerks, PO's ,Managers
    Package Best in Market
    Industry Banking
    Website www.canarabank.com

    Latest Job Openings in KVB Bank:





  • Bank Teller
  • Bank Clerk
  • Bank PO (Probationary Officer)
  • Specialist Officers
  • Data Entry Staff
  • Financial Analyst
  • Loan Officer
  • Financial Manager
  • IT Engineers
  • BPO Staff
  • Customer Care Executives
  • Bank Security Guards
  • ATM Guards
  • Customer Relationship Mangers
  • Accountants
  • Field Officers
  • Marketing Executives
  • About Canara Bank :

    Canara Bank is an Indian state-owned bank headquartered in Bangalore, Karnataka. It was established at Mangalore in 1906, making it one of the oldest banks in the country. The government nationalized the bank in 1969. As of September 2016, the bank had a network of 5847 branches and more than 10026 ATMs spread across India. The bank also has offices abroad in London, Hong Kong, Moscow, Shanghai, Doha, Bahrain, South africa, Dubai, Tanzania and New York.

    Recruitment Selection Process :

    The Selection Process of following Three Rounds
    1. Preliminary Exam
    2. Mains (Who cleared the Prelims Exam)
    3. Interview

    Registration Process :


  • Go to the Official website of Canara Bank.
  • Click on the careers link.
  • Select the link available for the opening.
  • Fill the Application with Required details.
  • Pay the Application Fee to Complete the Registration Process.
  • Eligibility Criteria


  • Should have a degree from the Recognized university with an aggregate of 60% an above in academics without any Backlogs at the time of Applying.
  • Minium Age Limit :19 years (As on 1-1-2017).
  • Maximum Age Limit :28 years
  • If the Percentage marks are in CGPA mode , then they are to be converted into Equivalent Percentage.
  • Document Required (Orginal and Photocopies) :





  • SSC Mark Sheet
  • HSC/Diploma Mark Sheet
  • Graduation & Post Graduation all year's Mark Sheet
  • Photo ID Proof (pan Card/ Passport /Driving License / College ID)
  • Photograph
  • Resume
  • Download : Canara Bank Previous Papers

    Company Location :

    Shop No.1494/A ,2nd Cross,
    3rd Main, Mahakavi kuvempu Rd,,
    M.R Palya ,Rajaji Nagar , Bengaluru,
    Karnataka - 560021.

    How to Apply for Canara Bank Jobs:

    Apply Here
    Note : If you need more details about Canara Bank Recruitment, check the official website.
    Dear job aspirants, get latest updates related to Canara Bank Recruitment 2017 , By clicking on the Link
    Also , you can Bookmark this page.

    Bank Of Baroda Recruitment For Freshers

    Bank Of Baroda Recruitment For Freshers


    Bank of Baroda Recruitment 2017 - Clerk , PO and SO Vacancies :

    Apply Online for Bank of Baroda Recruitment notification 2017 for freshers.Bank of Baroda Recruitment 2017 Job Openings in India for the Vacancies of Clerks , PO's and Managers. Interested and Eligible Candidates can apply Online for Bank of Baroda Careers through below provided registration link.
    Good news for the Candidates who are eagerly waiting for the Bank of Baroda recruitment notification.Finally the bank has announced various job Openings across India.Candidates can practice Bank of Baroda Previous Papers to crack the exam and can go through the Bank of Baroda syllabus and exam pattern.
    So this will help you to clear the preliminary and mains exams. Here you can find latest Job Updates of Bank of Baroda.

    Company Name Bank of Baroda
    Qualification Any Graduate / Any Post Graduate
    Experience Freshers (2017 / 2016 / 2015 / 2014 pass outs)
    Job Location Across India
    Job Role Clerks, PO's ,Specialist Officers and Managers/td>
    Package Best in Market
    Industry Banking
    Website www.bankofbaroda.com

    Latest Job Openings in Bank Of Baroda :


  • Bank Teller
  • Bank Clerk
  • Bank PO (Probationary Officer)
  • Specialist Officers
  • Data Entry Staff
  • Financial Analyst
  • Loan Officer
  • Financial Manager
  • IT Engineers
  • BPO Staff
  • Customer Care Executives
  • Bank Security Guards
  • ATM Guards
  • Customer Relationship Mangers
  • Accountants
  • Field Officers
  • Marketing Executives
  • About Bank Of Baroda :

    Bank of Baroda is an Indian state-owned International banking and financial services company headquartered in Vadodara (earlier known as Baroda) in Gujarat, India.It is the second largest bank in India, next to State Bank Of India. Its headquarters is in Vadodara, it has a corporate office in the Bandra Kurla Complex in Mumbai. Based on 2014 data, it is ranked 801 on Forbes Global 2000 list.[4][5] BoB has total assets in excess of ₹ 3.58 trillion, a network of 5493 branches in India and abroad, and 10441 ATMs as of Sept, 2016.[6] The bank was founded by the Maharaja of Baroda, Maharaja Sayajirao Gaekwad III on 20 July 1908 in the Princely State of Baroda, in Gujarat.[7] The bank, along with 13 other major commercial banks of India, was nationalised on 19 July 1969, by the Government of India and has been designated as a profit-making public sector undertaking (PSU). In 2015, Bank of Baroda officials recently stumbled upon illegal transfers of a whopping Rs 6,172 crores in foreign exchange, made to Hong Kong through newly opened accounts in the bank's Ashok Vihar branch. As many as 10 banks have been merged with Bank of Baroda during its journey so far:
  • Hind Bank Ltd (1958)
  • New Citizen Bank of India Ltd (1961)
  • Surat Banking Corporation (1963)
  • Tamil Nadu Central Bank (1964)
  • Umbergaon People Bank (1964)
  • Traders Bank Limited (1988)
  • Bareilly Corporation Bank Ltd (1998)
  • Benares State Bank Ltd (2002)
  • South Gujarat Local Area Bank Ltd (2004)
  • Memon Cooperative Bank Limited (2011)
  • Recruitment Selection Process :

    The Selection Process of following Three Rounds
    1. Preliminary Exam
    2. Mains (Who cleared the Prelims Exam)
    3. Interview

    Registration Process :


  • Go to the Official website of Bank of Baroda.
  • Click on the careers link.
  • Select the link available for the opening.
  • Fill the Application with Required details.
  • Pay the Application Fee to Complete the Registration Process.
  • Eligibility Criteria


  • Should have a degree from the Recognized university with an aggregate of 60% an above in academics without any Backlogs at the time of Applying.
  • Minium Age Limit :19 years (As on 1-1-2017).
  • Maximum Age Limit :26 years
  • If the Percentage marks are in CGPA mode , then they are to be converted into Equivalent Percentage.
  • Document Required (Orginal and Photocopies) :


  • SSC Mark Sheet
  • HSC/Diploma Mark Sheet
  • Graduation & Post Graduation all year's Mark Sheet
  • Photo ID Proof (pan Card/ Passport /Driving License / College ID)
  • Photograph
  • Resume
  • Company Location :

    Bank Of Baroda Building,
    Hathikhana Main Road,
    Mandvi, Vadodara,
    Gujarat - 390006.

    How to Apply for Bank of Baroda Jobs:

    Apply Here throught IBPS (1039 specialist officers vacancies)
    or
    Apply Here
    Note : If you need more details about Bank of Baroda Recruitment, check the official website.
    Dear job aspirants, get latest updates related to Bank of Baroda Recruitment 2017 , By clicking on the Link
    Also , you can Bookmark this page.

    AXIS Bank Recruitment for Freshers - 2017

    AXIS Bank Recruitment for Freshers -  2017


    Axis Bank Recruitment 2017 - Clerk , PO and SO Vacancies :

    Apply Online for Axis Bank Recruitment notification 2017 for freshers. Axis Bank Recruitment 2017 Job Openings in India for the Vacancies of Entry level engineers and IT internship Jobs Interested and Eligible Candidates can apply Online for Axis Bank Careers through below provided registration link.
    Good news for the Candidates who are eagerly waiting for the Axis Bank recruitment notification.Finally the bank has announced various job Openings across India.Candidates can practice Axis Bank Previous Papers to crack the exam and can go through the Axis Bank syllabus and exam pattern.
    So this will help you to clear the preliminary and mains exams. Here you can find latest Job Updates of Axis Bank.
    Company Name Axis Bank
    Qualification Any Graduate / Any Post Graduate
    Experience Freshers (2017 / 2016 / 2015 / 2014 pass outs)
    Job Location Across India
    Job Role Entry Level Engineer
    Package Best in Market
    Industry IT- Software Service
    Website www.axisbank.com

    Latest Job Openings in Axis Bank:


  • Bank Teller
  • Bank Clerk
  • Bank PO (Probationary Officer)
  • Specialist Officers
  • Data Entry Staff
  • Financial Analyst
  • Loan Officer
  • Financial Manager
  • IT Engineers
  • BPO Staff
  • Customer Care Executives
  • Bank Security Guards
  • ATM Guards
  • Customer Relationship Mangers
  • Accountants
  • Field Officers
  • Marketing Executives
  • About Axis Bank :

    AxisBank is the third largest of the private-sector banks in India offering a comprehensive suite of financial products. The bank has its head office in Mumbai and Registered office in Ahmedabad. It has 2,959 branches, 12,743 ATMs, and nine international offices. The bank employs over 50,000 people and had a market capitalization of ₹1.0583 trillion (US$16 billion) (as on March 31, 2016).[4] It offers the entire spectrum of financial services large and mid-size corporates, SME, and retail businesses.[1] Axis Bank has its registered office in Ahmedabad.[5] As of 30 Jun. 2016, 30.81% shares are owned by promoters & promoter group (United India Insurance Company Limited, Oriental Insurance Company Limited, National Insurance Company Limited, National Assurance Company Ltd, GIC, LIC & UTI).[6] Remaining 69.19% shares are owned by Mutual Funds Institutions, FIIs, Financial Institutions (banks), Insurance companies, corporate bodies & individual investors among others.

    Recruitment Selection Process :

    The Selection Process of following Three Rounds
    1. Preliminary Exam
    2. Mains (Who cleared the Prelims Exam)
    3. Interview

    Registration Process :


  • Go to the Official website of Axis Bank.
  • Click on the careers link.
  • Select the link available for the opening.
  • Fill the Application with Required details.
  • Pay the Application Fee to Complete the Registration Process.
  • Eligibility Criteria


  • Should have a degree from the Recognized university with an aggregate of 60% an above in academics without any Backlogs at the time of Applying.
  • Minium Age Limit :18 years (As on 1-1-2017).
  • Maximum Age Limit :28 years
  • If the Percentage marks are in CGPA mode , then they are to be converted into Equivalent Percentage.
  • Document Required (Orginal and Photocopies) :


  • SSC Mark Sheet
  • HSC/Diploma Mark Sheet
  • Graduation & Post Graduation all year's Mark Sheet
  • Photo ID Proof (pan Card/ Passport /Driving License / College ID)
  • Photograph
  • Resume
  • Company Location :

    Bombay Dyeing Mills Compound,
    Pandurang Budhkar Marg, Worli,
    Mumbai, Maharashtra - 400025.

    How to Apply for Axis Bank Jobs:

    Apply Link
    Note : If you need more details about Axis Bank Recruitment, check the official website.
    Dear job aspirants, get latest updates related to Axis Bank Recruitment 2017 , By clicking on the
    Link
    Also , you can Bookmark this page.

    HDFC recruitment for Freshers -2017

    HDFC recruitment for Freshers -2017

    HDFC Bank Recruitment 2017 - Clerk , PO and SO Vacancies :

    Apply Online for HDFC Bank Recruitment notification 2017 for freshers. HDFC Bank Recruitment 2017 Job Openings in India for the Vacancies of Clerks , PO's Specialist and Managers. Interested and Eligible Candidates can apply Online for HDFC Bank Careers through below provided registration link.
    Good news for the Candidates who are eagerly waiting for the HDFC Bank recruitment notification.Finally the bank has announced various job Openings across India.Candidates can practice HDFC Bank Previous Papers to crack the exam and can go through the HDFC Bank syllabus and exam pattern.
    So this will help you to clear the preliminary and mains exams. Here you can find latest Job Updates of HDFC Bank.
    Company Name HDFC Bank Limited
    Qualification Any Graduate / Any Post Graduate
    Experience Freshers (2017 / 2016 / 2015 / 2014 pass outs)
    Job Location Across India
    Job Role Clerks, PO's , Specialist Officers and Mangers
    Package Best in Market
    Industry Banking
    Website www.hdfcbank.com

    Latest Job Openings in HDFC Bank :


  • Bank Teller
  • Bank Clerk
  • Bank PO (Probationary Officer)
  • Specialist Officers
  • Data Entry Staff
  • Financial Analyst
  • Loan Officer
  • Financial Manager
  • IT Engineers
  • BPO Staff
  • Customer Care Executives
  • Bank Security Guards
  • ATM Guards
  • Customer Relationship Mangers
  • Accountants
  • Field Officers
  • Marketing Executives
  • About HDFC Bank :

    HDFC Bank (Housing Development Finance Corporation) is an Indian banking and financial services company headquartered in Mumbai, Maharashtra. It has about 87,555 employees[1] and has a presence in Bahrain, Hong Kong and Dubai.[2] HDFC Bank is the first largest private bank in India as measured by assets.[3] It is the largest bank in India by market capitalization as of February 2016.[4] It was ranked 69th in 2016 BrandZTM Top 100 Most Valuable Global Brands.

    Recruitment Selection Process :

    The Selection Process of following Three Rounds
    1. Preliminary Exam
    2. Mains (Who cleared the Prelims Exam)
    3. Interview

    Registration Process :


  • Go to the Official website of HDFC Bank.
  • Click on the careers link.
  • Select the link available for the opening.
  • Fill the Application with Required details.
  • Pay the Application Fee to Complete the Registration Process.
  • Eligibility Criteria


  • Should have a degree from the Recognized university with an aggregate of 60% an above in academics without any Backlogs at the time of Applying.
  • Minium Age Limit :18 years (As on 1-1-2017).
  • Maximum Age Limit :28 years
  • If the Percentage marks are in CGPA mode , then they are to be converted into Equivalent Percentage.
  • Document Required (Orginal and Photocopies) :


  • SSC Mark Sheet
  • HSC/Diploma Mark Sheet
  • Graduation & Post Graduation all year's Mark Sheet
  • Photo ID Proof (pan Card/ Passport /Driving License / College ID)
  • Photograph
  • Resume
  • Company Location :

    HDFC Bank Limited,
    HDFC Bank House, Senapathi Bapat Marg,
    Lower parel (W), Mumbai - 400013.

    How to Apply for HDFC Bank Jobs:

    Apply Here
    Note : If you need more details about HDFC Bank Recruitment, check the official website.
    Dear job aspirants, get latest updates related to HDFC Bank Recruitment 2017 , By clicking on the Link Also , you can Bookmark this page.

    SBI Recruitment 2017

    SBI Recruitment 2017

    SBI Recruitment 2017 - Clerk , PO and SO Vacancies :

    Apply Online for SBI Recruitment notification 2017 for freshers. SBI Recruitment 2017 Job Openings in India for the Vacancies of Clerks , PO's Specialist and Managers. Interested and Eligible Candidates can apply Online for SBI Careers through below provided registration link.
    Good news for the Candidates who are eagerly waiting for the SBI recruitment notification.Finally the bank has announced various job Openings across India.Candidates can practice SBI Previous Papers to crack the exam and can go through the SBI syllabus and exam pattern.
    So this will help you to clear the preliminary and mains exams. Here you can find latest Job Updates of SBI recruitment 2017.
    Company Name State Bank of India
    Qualification Any Graduate / Any Post Graduate
    Experience Freshers (2017 / 2016 / 2015 / 2014 pass outs)
    Job Location Across India
    Job Role Clerks, PO's , Specialist Officers and Mangers
    Package Best in Market
    Industry Banking
    Website www.sbi.co.in

    Latest Job Openings in Andhra Bank :



  • Bank Teller
  • Bank Clerk
  • Bank PO (Probationary Officer)
  • Specialist Officers
  • Data Entry Staff
  • Financial Analyst
  • Loan Officer
  • Financial Manager
  • IT Engineers
  • BPO Staff
  • Customer Care Executives
  • Bank Security Guards
  • ATM Guards
  • Customer Relationship Mangers
  • Accountants
  • Field Officers
  • Marketing Executives
  • About State Bank of India :

    State Bank of India (SBI) is an Indian multinational, public sector banking and financial services company. It is a government-owned corporation with its headquarters in Mumbai, Maharashtra. As of 2016-17, it had assets of ₹30.72 trillion (US$460 billion) and more than 14,000 branches, including 191 foreign offices spread across 36 countries, making it the largest banking and financial services company in India by assets.[3][4][5] The company is ranked 232nd on the Fortune Global 500 list of the world's biggest corporations as of 2016.[6] The bank traces its ancestry to British India, through the Imperial Bank of India, to the founding, in 1806, of the Bank of Calcutta, making it the oldest commercial bank in the Indian subcontinent. Bank of Madras merged into the other two "presidency banks" in British India, Bank of Calcutta and Bank of Bombay, to form the Imperial Bank of India, which in turn became the State Bank of India in 1955.[7] Government of India owned the Imperial Bank of India in 1955, with Reserve Bank of India (India's Central Bank) taking a 60% stake, and renamed it the State Bank of India. In 2008, the government took over the stake held by the Reserve Bank of India. State Bank of India is a banking behemoth and has 20% market share in deposits and loans among Indian commercial banks.

    Recruitment Selection Process :

    The Selection Process of following Three Rounds
    1. Preliminary Exam
    2. Mains (Who cleared the Prelims Exam)
    3. Interview

    Registration Process :



  • Go to the Official website of state Bank.
  • Click on the careers link.
  • Select the link available for the opening.
  • Fill the Application with Required details.
  • Pay the Application Fee to Complete the Registration Process.
  • Eligibility Criteria



  • Should have a degree from the Recognized university with an aggregate of 60% an above in academics without any Backlogs at the time of Applying.
  • Minium Age Limit : 20years (As on 1-1-2017).
  • Maximum Age Limit : 28 years
  • If the Percentage marks are in CGPA mode , then they are to be converted into Equivalent Percentage.
  • Document Required (Orginal and Photocopies) :



  • SSC Mark Sheet
  • HSC/Diploma Mark Sheet
  • Graduation & Post Graduation all year's Mark Sheet
  • Photo ID Proof (pan Card/ Passport /Driving License / College ID)
  • Photograph
  • Resume
  • Company Location :

    State Bank Bhavan,
    Madame cama Road ,
    Nariman point,Mumbai,
    Maharashtra 400021.

    How to Apply for SBI Jobs:

    Apply Here
    Note : If you need more deatails about SBI Recruitment, check the official website.
    Dear job aspirants, get latest updates related to SBI Recruitment 2017 , By clicking on the
    Link
    Also , you can Bookmark this page.

    ICICI Bank Recruitment - 2017

    ICICI Bank Recruitment - 2017

    ICICI Bank Recruitment 2017 - Clerk , PO and SO Vacancies :

    Apply Online for ICICI Bank Recruitment notification 2017 for freshers. ICICI Bank Recruitment 2017 Job Openings in India for the Vacancies of Clerks , PO's Specialist and Managers. Interested and Eligible Candidates can apply Online for ICICI Bank Careers through below provided registration link.
    Good news for the Candidates who are eagerly waiting for the ICICI Bank recruitment notification.Finally the bank has announced various job Openings across India.Candidates can practice ICICI Bank Previous Papers to crack the exam and can go through the ICICI Bank syllabus and exam pattern.
    So this will help you to clear the preliminary and mains exams. Here you can find latest Job Updates of ICICI Bank Jobs inIndia.
    Company Name ICICI Bank
    Qualification Any Graduate / Any Post Graduate
    Experience Freshers (2017 / 2016 / 2015 / 2014 pass outs)
    Job Location Across India
    Job Role Clerks, PO's , Specialist Officers and Mangers
    Package Best in Market
    Industry Banking
    Website www.icicibank.in

    Latest Job Openings in Andhra Bank :


  • Bank Teller
  • Bank Clerk
  • Bank PO (Probationary Officer)
  • Specialist Officers
  • Data Entry Staff
  • Financial Analyst
  • Loan Officer
  • Financial Manager
  • IT Engineers
  • BPO Staff
  • Customer Care Executives
  • Bank Security Guards
  • ATM Guards
  • Customer Relationship Mangers
  • Accountants
  • Field Officers
  • Marketing Executives
  • About Andhra Bank :

    ICICI Bank is India's largest private sector bank with total assets of Rs. 7,206.95 billion (US$ 109 billion) at March 31, 2016 and profit after tax Rs. 97.26 billion (US$ 1,468 million) for the year ended March 31, 2016. ICICI Bank currently has a network of 4,501 Branches and 14,146 ATM's across India. ICICI Bank was originally promoted in 1994 by ICICI Limited, an Indian financial institution, and was its wholly-owned subsidiary. ICICI's shareholding in ICICI Bank was reduced to 46% through a public offering of shares in India in fiscal 1998, an equity offering in the form of ADRs listed on the NYSE in fiscal 2000, ICICI Bank's acquisition of Bank of Madura Limited in an all-stock amalgamation in fiscal 2001, and secondary market sales by ICICI to institutional investors in fiscal 2001 and fiscal 2002. ICICI was formed in 1955 at the initiative of the World Bank, the Government of India and representatives of Indian industry. The principal objective was to create a development financial institution for providing medium-term and long-term project financing to Indian businesses. In the 1990s, ICICI transformed its business from a development financial institution offering only project finance to a diversified financial services group offering a wide variety of products and services, both directly and through a number of subsidiaries and affiliates like ICICI Bank. In 1999, ICICI become the first Indian company and the first bank or financial institution from non-Japan Asia to be listed on the NYSE. After consideration of various corporate structuring alternatives in the context of the emerging competitive scenario in the Indian banking industry, and the move towards universal banking, the managements of ICICI and ICICI Bank formed the view that the merger of ICICI with ICICI Bank would be the optimal strategic alternative for both entities, and would create the optimal legal structure for the ICICI group's universal banking strategy. The merger would enhance value for ICICI shareholders through the merged entity's access to low-cost deposits, greater opportunities for earning fee-based income and the ability to participate in the payments system and provide transaction-banking services. The merger would enhance value for ICICI Bank shareholders through a large capital base and scale of operations, seamless access to ICICI's strong corporate relationships built up over five decades, entry into new business segments, higher market share in various business segments, particularly fee-based services, and access to the vast talent pool of ICICI and its subsidiaries. In October 2001, the Boards of Directors of ICICI and ICICI Bank approved the merger of ICICI and two of its wholly-owned retail finance subsidiaries, ICICI Personal Financial Services Limited and ICICI Capital Services Limited, with ICICI Bank. The merger was approved by shareholders of ICICI and ICICI Bank in January 2002, by the High Court of Gujarat at Ahmedabad in March 2002, and by the High Court of Judicature at Mumbai and the Reserve Bank of India in April 2002. Consequent to the merger, the ICICI group's financing and banking operations, both wholesale and retail, have been integrated in a single entity. ICICI Bank has formulated a Code of Business Conduct and Ethics for its directors and employees.

    Recruitment Selection Process :

    The Selection Process of following Three Rounds
    1. Preliminary Exam
    2. Mains (Who cleared the Prelims Exam)
    3. Interview

    Registration Process :


  • Go to the Official website of ICICI Bank.
  • Click on the careers link.
  • Select the link available for the opening.
  • Fill the Application with Required details.
  • Pay the Application Fee to Complete the Registration Process.
  • Eligibility Criteria


  • Should have a degree from the Recognized university with an aggregate of 60% an above in academics without any Backlogs at the time of Applying.
  • Age Limit : With in 25years
  • If the Percentage marks are in CGPA mode , then they are to be converted into Equivalent Percentage.
  • Document Required (Orginal and Photocopies) :


  • SSC Mark Sheet
  • HSC/Diploma Mark Sheet
  • Graduation & Post Graduation all year's Mark Sheet
  • Photo ID Proof (pan Card/ Passport /Driving License / College ID)
  • Photograph
  • Resume
  • Company Location :

    5-9-11 , Dr. Pattabhi Bhavan,
    Secretariat Road , Saifabad,
    Hyderabad - 500004.

    How to Apply for ICICI Bank Jobs:

    Apply Here
    Note : If you need more deatails about ICICI Bank Recruitment, check the official website.
    Dear job aspirants, get latest updates related to ICICI Bank Recruitment 2017 , By clicking on the Link
    Also , you can Bookmark this page.

    Monday, 30 January 2017

    Andhra Bank Recruitment 2017

    Andhra Bank Recruitment 2017

    Andhra Bank Recruitment 2017 - Clerk , PO and SO Vacancies :

    Apply Online for Andhra Bank Recruitment drive 2017 for freshers. Andhra Bank Job Openings in India for the Vacancies of Clerks , PO's Specialist and Managers. Interested and Eligible Candidates can apply Online for Andhra Bank Careers through below provided registration link. Good news for the Candidates who are eagerly waiting for the Andhra Bank recruitment notification.Finally the bank has announced various job Openings across India.Candidates can practice Andhra Bank Previous Papers to crack the exam and can go through the Andhra Bank syllabus and exam pattern. So this will help you to clear the preliminary and mains exams.Here you can find latest Job Updates of Andhra Bank.
    Company Name Andhra Bank
    Qualification Any Graduate / Any Post Graduate
    Experience Freshers (2017 / 2016 / 2015 / 2014 pass outs)
    Job Location Across India
    Job Role Clerks, PO's , Specialist Officers and Mangers
    Package Best in Market
    Industry Banking
    Website www.andhrabank.in

    Latest Job Openings in Andhra Bank :



  • Bank Teller
  • Bank Clerk
  • Bank PO (Probationary Officer)
  • Specialist Officers
  • Data Entry Staff
  • Financial Analyst
  • Loan Officer
  • Financial Manager
  • IT Engineers
  • BPO Staff
  • Customer Care Executives
  • Bank Security Guards
  • ATM Guards
  • Customer Relationship Mangers
  • Accountants
  • Field Officers
  • Marketing Executives

  • About Andhra Bank :

    "Andhra Bank" was founded by the eminent freedom fighter and a multifaceted genius, Dr. Bhogaraju Pattabhi Sitaramayya. The Bank was registered on 20th November 1923 and commenced business on 28th November 1923 with a paid up capital of Rs 1.00 lakh and an authorised capital of Rs 10.00 lakhs. Dr Bhogaraju Pattabhi Sitaramayya was born on 24th November 1880 in Gundugolanu village, West Godavari District in Andhra Pradesh. He was a renowned Freedom Fighter and a very illustrious personality.

    Recruitment Selection Process :

    The Selection Process of following Three Rounds
    1. Preliminary Exam
    2. Mains (Who cleared the Prelims Exam)
    3. Interview

    Registration Process :



  • Go to the Official website of Andhra Bank.
  • Click on the careers link.
  • Select the link available for the opening.
  • Fill the Application with Required details.
  • Pay the Application Fee to Complete the Registration Process.
  • Eligibility Criteria



  • Should have a degree from the Recognized university with an aggregate of 60% an above in academics without any Backlogs at the time of Applying.
  • Minimum Age Limited : 21 years (As on 1-1-2017).
  • Maximum Age Limit : 30 years
  • If the Percentage marks are in CGPA mode , then they are to be converted into Equivalent Percentage.
  • Document Required (Orginal and Photocopies) :



  • SSC Mark Sheet
  • HSC/Diploma Mark Sheet
  • Graduation & Post Graduation all year's Mark Sheet
  • Photo ID Proof (pan Card/ Passport /Driving License / College ID)
  • Photograph
  • Resume
  • Company Location

    5-9-11 , Dr. Pattabhi Bhavan,
    Secretariat Road , Saifabad
    Hyderabad - 500004.

    How to Apply for Andhra Bank Jobs:

    Apply here
    Note : If you need more details about Andhra Bank Recruitment, check the official website.
    Dear job aspirants, get latest updates related to Andhra Bank Recruitment 2017 , By clicking on the Link
    Also , you can Bookmark this page.

    ACUVATE Walkin Drive



    Company Name Acuvate Software
    Qualification BE / BTech / MCA ; Branches: CSE / IT
    Expericence 2014 / 2015 / 2016 Batches
    Job Location Hyderabad
    Job Role Software Engineer
    Skills C# ,Asp .Net, Ado .Net
    Package As per IT Standard
    Walkin Schedule 4th Feb 2017
    Reporting Time 10:00 A.M - 04:00 P.M
    Company Website www.acuvate.com

    About Company :

    Acuvate is a global software consulting, solutions and services company with offices in the UK, US, India, nd Netherlands. Our offerings are an optimal blend of software services and off the shelf products. This allows our customers to have the best of both worlds.

    Venue :

    Acuvate software Pvt Ltd,
    Neil Rao Towers,Plot No. 118, Road #3,
    EPIP Phase I, Whitefield,
    Bangalore - 560066

    How To Apply :

    It is a direct Walk-in Drive for eligible Candidates on 4th Feb 2017 at Bangalore Location.

    TRIGENT Walkin Drive For Freshers

    TRIGENT Walkin Drive For Freshers

    IT Recruiter Jobs in Bangalore :

    Trigent Job openings for Graduate students as Recruitment Executive. Trigent is Recruiting for Multiple Vacancies. Applicants have to tighten up their preparation by framing a planner which will be comfortable for them. Candidates will selected for the position only if theyperform well during the selection process.
    Company Name Trigent Software
    Qualification Any Graduate
    Experience 0-3 Years
    Job Location Bangalore
    Job Role Recruiter Executive
    Package Not Disclosed By Recruiter
    Industry Recruiter, Staffing
    Walkin schedule Date : 30th Jan -3rd Feb 2017 / Time:9:30 A.M - 4:30 P.M

    Job Description :


  • posting and sourcing candidates through various - Job sites , social networking sites etc.
  • preliminary screening/short-listing the right qualitative profile against the given requirement.
  • Coordinating with the SPOC to know the feedback of the candidates and improve sourcing based on the discussions.
  • Conduct initial HR Interviews(Telephonic) to check technical skills,communication skills ,interest level , etc.
  • Follow up on the feed backs.
  • Closing the positing within the stipulated time.
  • Following up with the candidate after the offer is made.
  • About Company :

    Trigent is CMM Level 4 software Development Company having our development center in Bangalore and head office situated in Boston (USA). We are also Microsoft Gold certified partner. Trigent is an early pioneer in IT outsourcing and the offshore software development business. For nearly 20 years we have helped hundreds of customers balance their cost-performance parameters for IT projects via sustainable, long term relationships with Trigent. Our hybrid engagement model is designed to leverage the best of US and India so that our customers are the ultimate beneficiaries. Our track record speaks of our success;having developed more than 100 products many of which are deployed in record time in both large and small companies. We work with the same care and diligence to make each of our engagement a success, one at a time, small or large.

    Location

    Trigent Software Ltd,
    Unit II ,49 Race Course Road, Khanija Bhavan , 2nd Floor , East Wing, Bangalore - 56001.

    Contact Person :

    Rakesh
    Email : rakesh_n@trigent.com

    Sunday, 29 January 2017

    AEGIS Walkin For Freshers

    AEGIS Walkin For Freshers

    Company Name Aegis Limited
    Qualification Any Graduate
    Expericence 0-1 Years
    Job Location Hyderabad
    Job Role Associate, Senior Associate(Non-Technical)
    No.of posts 100
    Package 1,00,000 - 1,50,000 P.A
    Walikin schedule WalkinDate:18th - 31st Jan 2017 , Walkin Time:10:00 A.M - 04:00 P.M

    Job Description

  • Position:Customer Service Associate (CSA) For Domestic BPO Process
  • Languages Known : English , Telugu and Hindi.
  • Handling Inbound Customer calls (Domestic Process)
  • Answering inbound calls for non-technical and semi-technical Process
  • About Company
    Innovative technologies are fast transforming consumer expectations and intensifying competition. To be game-changers in this dynamic sphere, your business has to be a player, not a bystander. You have to be aware and agile in your responses to global shifts. You need to deliver memorable consumer experiences that earn both loyalty and profitability. In a changing world, our road-map solutions are your best bet to achieve faster, smarter growth and efficiency. Because we believe it is our business to make sure your business succeeds.
    Location
    Aegis Limited,
    3rd Floor,
    varun Towers-2,
    Begumpet,
    Hyderabad
    (Landmark : Opposite Hyderabad Public School)

    contact No:
    040-66166228 / 8096285271 / 9542910005 / 9700223425
    To Bring For Job Interview :

  • Updated Resume
  • Valid Govt ID Proof
  • Passport Size Photo
  • Xerox copies of certification
  • Friday, 27 January 2017

    Top 20 Windows Server Interview Questions & Answers


    1)      Explain what is Windows Server?
    Window server is a series of server operating system developed by Microsoft Corporation.
    2)      Explain in windows DNS server what is Primary, Secondary and Stub zone?
    In windows DNS server,
    • Primary Zone: In this, the file is saved as normal text file with filename (.dns).
    • Secondary Zone: It maintains a read-only copy of zone database on another DNS server.  Also, it acts as a back-up server to the primary server by providing fault tolerance and load balancing
    • Stub Zone: It consists of a copy of name server and SOA records which is used for reducing the DNS search orders.
    3) Explain what does IntelliMirror do?
    IntelliMirror helps to reconcile desktop settings, applications and stored files for users especially for those users who move between workstations or those who works offline
    4) In the case when MSI file is not available, how you can install an app?
    To add the application using the Software Installer.ZAP text file can be used rather than the windows installer
    5) Explain how you can set up remote installation procedure without giving access to user?
    To do that, you have to go to,
    gponameà  User Configuration à Windows Settings à Remote Installation Services à Choice Options
    6) What does it mean by “tattooing” the Registry ?
    “ Tattooing” the registry means user can modify and view user preference that are not stored in the maintained portions of the Registry.  Even if the group policy is changed or removed, the user preference will still persist in the registry.
    7) Mention how many types of queries DNS does?
    The types of queries DNS does are
    • Iterative Query
    • Recursive Query
    8) Explain what is the primary function of the domain controller?
    Primary function of the domain controller is to validate users to the networks, it also provide a catalog of Active Directory Objects.
    9) What information is required when TCP/IP is configured on Window Server?
    To configure a TCP/PI client for an IPv4 client, you have to provide the IP address and the subnet mask.
    10) Explain what does it mean caching only server in terms of DNS?
    The caching only DNS server provides information related to queries based on the data it contains in its DNS cache.
    11)  Explain what is the way to configure the DHCP server such that it allocates the same IP address to certain devices each time the address is removed?
    To configure the DHCP server, you can create a reservation for the device.  To create a reservation, you must know the MAC hardware address of the device.  To determine the MAC address for a network device you can use the ipconfig or nbs tat command line utilities.
    12)  Explain what is SYSVOL folder?
    It is a set of files and folders that is stored on the local hard disk of each domain controller in a domain and are replicated by the FRS ( File Replication Service).  These files contain group or user policy information.
    13)  Explain what is the difference between a thread and a computer process?
    Computer Process: In computing, a process is an instance of a computer program that is executed sequentially by a computer system which can run several computer programs concurrently.
    Thread: A thread is a several executable program that work together as a single process.  For instance, one thread might send an error message to the user; another might handle error signals while the third thread might be executing the original action.
    14) Explain what is INODE?
    INODE holds the metadata of files; INODE is a pointer to a block on the disk, and it is unique.
    In simple words, it is a unique number allocated to a file in UNIX-like OS.
    15)  Explain what is RAID in Windows Server?
    For storing same data at a different place RAID or Redundant Array of Independent Disks strategy is used. It is a strategy for building fault tolerance and increase the storage capacity. On separate drives it allows you to combine one or more volumes so that they are accessed by a single drive letter
    16)  Explain what is the purpose of deploying local DNS servers?
    A local DNS server provides the local mapping of fully qualified domain names to IP addresses.  To resolve remote requests related to the domains names on your network, local DNS servers can provide record information to remote DNS servers.
    17)  To check TCP/IP configurations and IP connectivity, what are the two command line utilities that can be used?
    Ipconfig: To check the computer’s IP configuration, command ipconfig can be used and also it can be used to renew the client’s IP address if it is provided by a DHCP server.
    Ping: To check the connection between the local computer and any of the other computer device on the network Ping command is used

    18)  Explain if it is possible to connect Active Directory to other 3rd party Directory services?
    Yes, you can connect other vendors directory services with Microsoft version.  By using dirXML or LDAP to connect to other directories.
    19)  Explain where is the AD database is held?
    AD database is saved in %systemroot%/ntds.  Files that controls the AD structure are
    • ntds.dit
    • edb.log
    • res1.log
    • res2.log
    • edn.chk
    20)  Explain what is the major difference between NTFS ( New Technology File System) or FAT (File Allocation Table) on a local server?
    For local users FAT (File Allocation Table) and FAT32 provides security, while NTFS ( New Technology File System) provides security for domain users as well as local users.  NTFS provides file level security which is not possible through FAT32.

    Thursday, 26 January 2017

    Top 30 Recent Best SQL Interview Questions & Answers


    1. What is DBMS?
    A Database Management System (DBMS) is a program that controls creation, maintenance and use of a database. DBMS can be termed as File Manager that manages data in a database rather than saving it in file systems.
    2. What is RDBMS?
    RDBMS stands for Relational Database Management System. RDBMS store the data into the collection of tables, which is related by common fields between the columns of the table. It also provides relational operators to manipulate the data stored into the tables.
    3. What is SQL?
    SQL stands for Structured Query Language , and it is used to communicate with the Database. This is a standard language used to perform tasks such as retrieval, updation, insertion and deletion of data from a database.
    Standard SQL Commands are Select.
    4. What is a Database?
    Database is nothing but an organized form of data for easy access, storing, retrieval and managing of data. This is also known as structured form of data which can be accessed in many ways.
    Example: School Management Database, Bank Management Database.
     5. What are tables and Fields?
    A table is a set of data that are organized in a model with Columns and Rows. Columns can be categorized as vertical, and Rows are horizontal. A table has specified number of column called fields but can have any number of rows which is called record.
    6. What is a primary key?
    A primary key is a combination of fields which uniquely specify a row. This is a special kind of unique key, and it has implicit NOT NULL constraint. It means, Primary key values cannot be NULL.
    7. What is a unique key?
    A Unique key constraint uniquely identified each record in the database. This provides uniqueness for the column or set of columns.
    A Primary key constraint has automatic unique constraint defined on it. But not, in the case of Unique Key.
    There can be many unique constraint defined per table, but only one Primary key constraint defined per table.
     8. What is a foreign key?
    A foreign key is one table which can be related to the primary key of another table. Relationship needs to be created between two tables by referencing foreign key with the primary key of another table.
    9. What is a join?
    This is a keyword used to query data from more tables based on the relationship between the fields of the tables. Keys play a major role when JOINs are used.
     10. What are the types of join and explain each?
    There are various types of join which can be used to retrieve data and it depends on the relationship between tables.
    Inner join.
    Inner join return rows when there is at least one match of rows between the tables.
    Right Join.
    Right join return rows which are common between the tables and all rows of Right hand side table. Simply, it returns all the rows from the right hand side table even though there are no matches in the left hand side table.
    Left Join.
    Left join return rows which are common between the tables and all rows of Left hand side table. Simply, it returns all the rows from Left hand side table even though there are no matches in the Right hand side table.
    Full Join.
    Full join return rows when there are matching rows in any one of the tables. This means, it returns all the rows from the left hand side table and all the rows from the right hand side table.
    11. What is normalization?
    Normalization is the process of minimizing redundancy and dependency by organizing fields and table of a database. The main aim of Normalization is to add, delete or modify field that can be made in a single table.
     12. What is Denormalization.
    DeNormalization is a technique used to access the data from higher to lower normal forms of database. It is also process of introducing redundancy into a table by incorporating data from the related tables.
    13. What is Self-Join?
    Self-join is set to be query used to compare to itself. This is used to compare values in a column with other values in the same column in the same table. ALIAS ES can be used for the same table comparison.
    14. What is a View?
    A view is a virtual table which consists of a subset of data contained in a table. Views are not virtually present, and it takes less space to store. View can have data of one or more tables combined, and it is depending on the relationship.
    15. What is an Index?
    An index is performance tuning method of allowing faster retrieval of records from the table. An index creates an entry for each value and it will be faster to retrieve data.
    16. What is recursive stored procedure?
    A stored procedure which calls by itself until it reaches some boundary condition. This recursive function or procedure helps programmers to use the same set of code any number of times.
    17. What is a Cursor?
    A database Cursor is a control which enables traversal over the rows or records in the table. This can be viewed as a pointer to one row in a set of rows. Cursor is very much useful for traversing such as retrieval, addition and removal of database records.
     18. What is a relationship and what are they?
    Database Relationship is defined as the connection between the tables in a database. There are various data basing relationships, and they are as follows:.
    • One to One Relationship.
    • One to Many Relationship.
    • Many to One Relationship.
    • Self-Referencing Relationship.
    19. What is a query?
    A DB query is a code written in order to get the information back from the database. Query can be designed in such a way that it matched with our expectation of the result set. Simply, a question to the Database.
     20. What is subquery?
    A subquery is a query within another query. The outer query is called as main query, and inner query is called subquery. SubQuery is always executed first, and the result of subquery is passed on to the main query.
    21. What are the types of subquery?
    There are two types of subquery – Correlated and Non-Correlated.
    A correlated subquery cannot be considered as independent query, but it can refer the column in a table listed in the FROM the list of the main query.
    A Non-Correlated sub query can be considered as independent query and the output of subquery are substituted in the main query.
     22. What is a stored procedure?
    Stored Procedure is a function consists of many SQL statement to access the database system. Several SQL statements are consolidated into a stored procedure and execute them whenever and wherever required.
    23. What is a trigger?
    A DB trigger is a code or programs that automatically execute with response to some event on a table or view in a database. Mainly, trigger helps to maintain the integrity of the database.
    Example: When a new student is added to the student database, new records should be created in the related tables like Exam, Score and Attendance tables.
    24. What is the difference between DELETE and TRUNCATE commands?
    DELETE command is used to remove rows from the table, and WHERE clause can be used for conditional set of parameters. Commit and Rollback can be performed after delete statement.
    TRUNCATE removes all rows from the table. Truncate operation cannot be rolled back.
    25. What are local and global variables and their differences?
    Local variables are the variables which can be used or exist inside the function. They are not known to the other functions and those variables cannot be referred or used. Variables can be created whenever that function is called.
    Global variables are the variables which can be used or exist throughout the program. Same variable declared in global cannot be used in functions. Global variables cannot be created whenever that function is called.
     26. What is a constraint?
    Constraint can be used to specify the limit on the data type of table. Constraint can be specified while creating or altering the table statement. Sample of constraint are.
    • NOT NULL.
    • CHECK.
    • DEFAULT.
    • UNIQUE.
    • PRIMARY KEY.
    • FOREIGN KEY.
    27. What is data Integrity?
    Data Integrity defines the accuracy and consistency of data stored in a database. It can also define integrity constraints to enforce business rules on the data when it is entered into the application or database.
     28. What is Auto Increment?
    Auto increment keyword allows the user to create a unique number to be generated when a new record is inserted into the table. AUTO INCREMENT keyword can be used in Oracle and IDENTITY keyword can be used in SQL SERVER.
    Mostly this keyword can be used whenever PRIMARY KEY is used.
     29. What is the difference between Cluster and Non-Cluster Index?
    Clustered index is used for easy retrieval of data from the database by altering the way that the records are stored. Database sorts out rows by the column which is set to be clustered index.
    A nonclustered index does not alter the way it was stored but creates a complete separate object within the table. It point back to the original table rows after searching.
    30. What is Datawarehouse?
    Datawarehouse is a central repository of data from multiple sources of information. Those data are consolidated, transformed and made available for the mining and online processing. Warehouse data have a subset of data called Data Marts.