Champcash 2017 June Refer Id of Sponsor – 15851958, Unlimited Earning TRICKS | Free Rs. 62 to New Users

Champcash app by which you can earn real unlimited money.We recommend this app to everyone.You can redeem your reward via paypal,free recharge ,E-Gift vouchers. Normally there are so many free recharge app by which you can earn free recharges, real money,etc. Some of those such app are whaff,mcent, ladooo, etc  but this real cash making app – CHAMPCASH is very unique.I will discuss below how you can earn unlimited real cash using this app.With champcash trick you can earn unlimited money.We don’t advise anyone to use champcash trick as they are blocking accounts now.So be safe.To get Started use our Champcash Referral ID during signup : 15851958

To earn unlimited real money from this app you have to refer this app to your friends and just told them to complete the challenge.

Champcash App : Trick to Earn Real Unlimited money

During Signup Use our Champcash Sponsor ID – 15851958

1)Download Champcash app Android

2) Install the app

3) Open the app and signup for new account by clicking on “Sign Up with Champcash”

4) Fill the required details name,passwords,etc, carefully

5) On the next page you will be asked to enter  sponsor ID

6) Enter our ID : 15851958[You can’t access the app without entering the referral ID /Sponsor ID,use our ID “15851958“]

7) Now Accept the Challenge

8) Install the offer apps one by one to complete the challenge,to be a part of Champcash N/W
system

9) Install all apps and complete your challenge and become part of Champcash Network

10) After installing the app,open the app for at least one minute and then reopen champcash app

Don’t uninstall the app after installation until your challenge completed.

Use different browser if you got any error message like “Your browser is not supported”

After completing the challenge you will get sms and email saying

“Congratulations For Being Part of Our Network system. Now You are Eligible To Earn Unlimited with Us”

How to Earn Money with Champcash app

• First you have to complete your challenge to earn unlimited money with champcash app as mentioned above
• click on “Invite and Earn” and start referring your friends
• Ask your friend to complete the challenge
• you will get instant reward when your friend complete the challenge
• More you refer and more you will earn
• You will get payment within 35 minutes

How Much Referral Commission

• First you have to complete your challenge to earn unlimited money with champcash app as mentioned above
  

How to Earn Unlimited money with Champcash Trick

The Below trick is also shared on so many other websites.We don’t advise anyone to use this trick.As champcash have very good tracking system.If they found you or anyone in your team using Champcash Bluestacks Trick, champcash team will block your account and payment.

This is a simple Champcash trick which we had shared earlier also to use this trick you need Bluestack and BS Tweaker.

Download these from our onedrive Link Bluestack + BS Tweaker

Now here Trick starts

1. Change Your Bluestack Id and Guid each time for New installs. (see here How to Change That)
2. Install Champcash.
3. Now Enter any Mobile no. [you can chose any random mobile no. you don’t have to verify it].
4. Enter other Info like address, Name etc.
5. Enter Your Referral Code.
6. Complete tasks form the app [Download the apps as above] and Get 1$ in your account and Referral Credits would be received in your account within 35 minutes.

If you don’t want to use Bluestack you can also opt for Youwave and factory reset the youwave each time for New Installs and use the trick.

Repeat The Process to Get unlimited Referral Bonuses. You can opt for transfer these credits into your account when you earn $10 in your Champcash account.

Minimum Redemption

Mobile Recharge : Rs 10

Flipkart Gift Card : Rs 500

Bank transfer : $ 5

During Signup if asked for Champcash Refer ID , use our sponsor code : 15851958

SBI Recruitment 2017 – 255+ Dean of Studies, Relationship Manager & Customer Relationship Executive Vacancy

SBI Recruitment 2017 – Dean of Studies

State Bank Institute of Management (SBIM) notified about new recruitment project for Dean of Studies. It is contract basis job. Apply online before 20th April 2017.

Total Number of Vacancies: Not Mentioned

Post Name: Dean of Studies

Salary Offered: Negotiable

Posting: Kolkata (West Bengal)

Educational Qualification: Aspirants interested in SBI Dean of Studies Recruitment 2017 should have  MBA from Top Indian/International ‘B’ Schools, OR Ph.D. from Top Indian University or Top Indian /International B-Schools.

Age Limit: Date to calculate age is 1st February 2017.

• Lower age condition:  40 years
• Upper age limit: 65 years

Important Information

• Last Date to Reach Application: 20th April 2017
• Postal Address: State Bank of India, Central Recruitment & Promotion Department, Corporate Centre, Floor, Atlanta Building, Nariman Point, Mumbai-400021

Advertise Link: https://www.sbi.co.in/webfiles/uploads/files/1491045362469_DEAN_ADVERTISEMENT_ENGLISH.pdf

Application Form: http://www.sbi.co.in/webfiles/uploads/files/1491045362469_DEAN_APPLICATION_FORM.pdf

SBI Recruitment 2017 – 255 Relationship Manager / Customer Relationship Executive

State Bank of India notified about new recruitment drive for the year 2017 2018. Total 255 new vacancies open out of which 120 (one hundred twenty) for Relationship Manager and 65 (sixty five) for Customer Relationship Executive. Apply online from 24th March to 10th April 2017.

Total Number of Vacancies: 255

Post Name: 

• Relationship Manager: 120
• Customer Relationship Executive: 65

Educational Qualification: Aspirants interested in SBI Relationship Manager Recruitment 2017 2018 should have Graduate Degree.

Age Limit: Upper age limit is 1st March 2017

Lower age limit: 23 years for Post 01 and 20 years for Post 02. +5 years upper age relaxation for SC/ST, +3 years for OBC. For detailed information read advertisement.

Fee Charges:

• General / OBC: Rs. 600/- (Rupee six hundred only)
• SC/ST/PWD: 100/- (Rupee one hundred only)

How to Apply: Aspirants need to access www.sbi.co.in website  to apply from 24th March 2017/ 10th April 2017.

Advertise Link: https://www.sbi.co.in/webfiles/uploads/files/1490271025070_Wealth_Management_English.pdf

Apply Online: http://ibps.sifyitest.com/sbispwmfeb17/

Bank of Baroda Probationary Officer Across India. Last Date: 01 May 2017

Probationary Officer

Eligibility : Any Graduate

Location : Anywhere in India

Last Date : 01 May 2017

Bank of Baroda looking for young, energetic, and innovative minds who can be imparted with the necessary knowledge and skills required to be good all-round bankers through a -9- (nine) months Post Graduate Certificate in Banking and Finance course in Baroda Manipal School of Banking.

Bank of Baroda recruiting 400 Vacancies for the post of Probationary Officer

Probationary Officer Job opportunity in Bank of Baroda

The course consists of -9- months on campus program, on completion of which the candidate would be awarded a Post Graduate Certificate in Banking & Finance and will be offered appointment in the Bank as Probationary Officer in Junior Management Grade / Scale-I.

No. of Vacancies : 400 (UR-202, OBC-108, SC-60, ST-30)

Qualification (As on 01.05.2017) :  Degree (Graduation) with minimum 55% (50% for SC/ST/PWD) marks in any discipline from a recognized University OR any equivalent qualification as such recognized by Central Government. All the educational qualifications mentioned should be from a University/ Institution/ Board recognized by Govt. Of India/ approved by Govt. Regulatory Bodies and the result should have been declared on or before 30.04.2017. Proper document from Board / University for having declared the result on or before 30.04.2017 has to be submitted at the time of interview. The date of passing the eligibility examination will be the date appearing on the mark-sheet or provisional certificate issued by University/ Institute. In case the result of a particular examination is posted on the website of the University/ Institute and web based certificate is issued then proper document/certificate in original issued and signed by the appropriate authority of the University/ Institute indicating the date of passing properly mentioned thereon will be reckoned for verification and further process.
Calculation of Percentage: The graduation percentage and class will be calculated as per the University norms for calculation of percentage and declaration of class/results. The graduation percentage/class as appearing in the Final Year/semester/ consolidated mark-sheet & Provisional/Degree Certificate will be taken into consideration for eligibility. In case the graduation percentage/class is not clearly mentioned in the mark-sheet/certificate, the candidate has to produce a certificate issued by the appropriate authority of University/Institute indicating graduation percentage/ class as per the University norms for awarding degree.
Where CGPA / OGPA is awarded, the same should be converted into percentage and indicated in online application. If called for interview, the candidate will have to produce a certificate issued by the appropriate authority inter alia stating that the norms of the University regarding conversion of grade into percentage and the percentage of marks scored by the candidate in terms of norms.
Candidate should indicate the percentage obtained in Graduation calculated to the nearest two decimals in the online application. The fraction of percentage so arrived will be ignored i.e. 54.99% will be treated as less than 55% and 49.99% will be treated as less than 50%.

Age (As on 01.04.2017) :  Minimum 20 years- Maximum 28 years i.e a candidate must have been born not earlier than 02.04.1989 and not later than 01.04.1997 (both dates inclusive)

Application Fees/ Intimation Charges (Payable from 01.04.2017 to 01.05.2017 (Online payment) both dates inclusive :

- Rs. 100/- for SC/ST/PWD candidates.
- Rs. 750/- for all others

Programme Fees : The fees for this Course will be Rs. 3.45/- lakhs (all inclusive of boarding, Lodging and course fees, other fees, etc.) plus service taxes, as applicable to be paid by the student.
Apart from the above course fees, the exam fees for undergoing various Certification exams viz. NISM (Mutual Funds) and NISM (Depository services) as mandated under the course will have to be borne by the candidates, as per the fees charged by NISM from time to time for conducting these Certification exams. Currently, the fees for NISM (Mutual Funds) and NISM (Depository services) certification exams comes to Rs. 2500/- per candidate.

Selection Process : Candidates shall be selected by BOB through a selection process consisting of an (open) online exam followed by Psychometric Assessment, Group Discussion and Interview. 
The selection process aims at getting applicants who are likely to succeed at various roles in the Bank. The endeavour is to select people who are bright, have good communication skills (both oral and written), are dedicated, can work effectively in teams, are passionate about their career goals and who display integrity and a positive attitude.

Objective Test

Reasoning : No of Question : 50, Marks : 50

Quantitative : No of Question : 50, Marks : 50

General Awareness (related to Banking Industry) : No of Question : 50, Marks : 50

English Language : No of Question : 50, Marks : 50 

Descriptive Test

English Language : No of Question : 02, Marks : 50

Centres for Online Test : Vijaywada, Vishakapatnam, Rajahmundry, Tirupati, Guwahati, Muzzafarpur, Patna, Bhagalpur, Chandigargh, Amritsar, Ludhiana, Delhi-NCR, Noida, Panaji, Anand, Ahmedabad, Rajkot, Surat, Vadodara, Faridabad, Gurgaon, Simla, Jammu, Jamshedpur, Ranchi, Bangalore, Mangalore, Mysore, Cochin, Trivandrum, Bhopal, Indore, Jabalpur, Gwalior, Raipur, Aurangabad, Mumbai/Thane/Navi Mumbai, Nagpur, Pune, Imphal, Bhubaneshwar, Rourkela, Puducherry, Jodhpur, Ajmer, Jaipur, Kota, Udaipur, Chennai, Coimbatore, Madurai, Hyderabad, Karimnagar, Dehradun, Haldwani, Agra, Allahabad, Bareilly, Gorakhpur, Kanpur, Lucknow, Varanasi, Kolkata, Burdwan

Official Link:

http://www.bankofbaroda.co.in/Careers/Admission-2017-18.asp

Champcash 2017 June Refer Id of Sponsor – 10307847, Free Rs. 62 to New Users | Updated TRICKS

Champcash app by which you can earn real unlimited money.We recommend this app to everyone.You can redeem your reward via paypal,free recharge ,E-Gift vouchers. Normally there are so many free recharge app by which you can earn free recharges, real money,etc. Some of those such app are whaff,mcent, ladooo, etc  but this real cash making app – CHAMPCASH is very unique.I will discuss below how you can earn unlimited real cash using this app.With champcash trick you can earn unlimited money.We don’t advise anyone to use champcash trick as they are blocking accounts now.So be safe.To get Started use our Champcash Referral ID during signup : 10307847

To earn unlimited real money from this app you have to refer this app to your friends and just told them to complete the challenge.

Champcash App : Trick to Earn Real Unlimited money

During Signup Use our Champcash Sponsor ID – 10307847

1)Download Champcash app Android

2) Install the app

3) Open the app and signup for new account by clicking on “Sign Up with Champcash”

4) Fill the required details name,passwords,etc, carefully

5) On the next page you will be asked to enter  sponsor ID

6) Enter our ID : 10307847[You can’t access the app without entering the referral ID /Sponsor ID,use our ID “10307847“]

7) Now Accept the Challenge

8) Install the offer apps one by one to complete the challenge,to be a part of Champcash N/W
system

9) Install all apps and complete your challenge and become part of Champcash Network

10) After installing the app,open the app for at least one minute and then reopen champcash app

Don’t uninstall the app after installation until your challenge completed.

Use different browser if you got any error message like “Your browser is not supported”

After completing the challenge you will get sms and email saying

“Congratulations For Being Part of Our Network system. Now You are Eligible To Earn Unlimited with Us”

How to Earn Money with Champcash app

• First you have to complete your challenge to earn unlimited money with champcash app as mentioned above
• click on “Invite and Earn” and start referring your friends
• Ask your friend to complete the challenge
• you will get instant reward when your friend complete the challenge
• More you refer and more you will earn
• You will get payment within 35 minutes

How Much Referral Commission

• First you have to complete your challenge to earn unlimited money with champcash app as mentioned above
  

How to Earn Unlimited money with Champcash Trick

The Below trick is also shared on so many other websites.We don’t advise anyone to use this trick.As champcash have very good tracking system.If they found you or anyone in your team using Champcash Bluestacks Trick, champcash team will block your account and payment.

This is a simple Champcash trick which we had shared earlier also to use this trick you need Bluestack and BS Tweaker.

Download these from our onedrive Link Bluestack + BS Tweaker

Now here Trick starts

1. Change Your Bluestack Id and Guid each time for New installs. (see here How to Change That)
2. Install Champcash.
3. Now Enter any Mobile no. [you can chose any random mobile no. you don’t have to verify it].
4. Enter other Info like address, Name etc.
5. Enter Your Referral Code.
6. Complete tasks form the app [Download the apps as above] and Get 1$ in your account and Referral Credits would be recived in your account within 35 minutes.

If you don’t want to use Bluestack you can also opt for Youwave and factory reset the youwave each time for New Installs and use the trick.

Repeat The Process to Get unlimited Referral Bonuses. You can opt for transfer these credits into your account when you earn $10 in your Champcash account.

Minimum Redemption

Mobile Recharge : Rs 10

Flipkart Gift Card : Rs 500

Bank transfer : $ 5

During Signup if asked for Champcash Refer ID , use our sponsor code : 10307847

SQL and PL/SQL Interview Questions [TCS, Infosys, Cognizant, HCL, Wipro, IBM, Tech Mahindra & More]

These questions will be updated on regular basis, so stay tuned and subscribe to RSS Feed.

Q. How many max triggers can be defined in a Table?

A. 12 Triggers

Q. Can we use equal sign for a Null value?

A. No we can’t, Null is not equals to another null. Thats why we use (COL1 IS NULL, rather than COL1=NULL);

Q. What is IS NULL and IS NOT NULL

A. You can use this syntax to check specifically to see if a variable's value is NULL or NOT NULL.

Q. How to encrypt a PL/SQL application?

A.  Using WRAP command.

Q. What is the difference between a PROCEDURE, FUNCTION and PACKAGE.

A. Procedure does not have a return type in its specification and should not return a value, but it can have a return statement that simply stops its execution and returns to the caller procedure. A function has a return type in its spec and must return a value specified in that type.  A package is consists of logically connected procedure and/or functions.

Q. How to handle NULL value in SQL?

A. NVL - Converts a NULL to another specified value, as in:

Select NVL(COL1, ‘Abcd’) from TAB1;  TAB1 is the table where COL1 is a column. This query will return the exact value of COL1 if its not null and if its null, then ‘Abcd’ will appear.

Q.  Briefly tell the compilation process of a PL/SQL block?

A. The compilation process steps are syntax check, binding, & p-code generation. Syntax checking involves checking PL/SQL code for compilation errors. After syntax errors have been corrected, an internal storage address is assigned to the variables that are used to hold data for Oracle. This process is called binding. After this, p-code is generated for the PL/SQL block. P-code is a list of instructions to the PL/SQL engine. For named blocks, p-code is stored in the database, and it is used the next time the program is executed.

Q. What is difference between Runtime error and Syntax error?

A. A syntax error can be Tracked by the PL/SQL compiler. A runtime error occurs only when the program is running and cannot be detected by the PL/SQL compiler.

For quick idea - A misspelled keyword is an example of a syntax error. For example, this script:

BEGIN

DBMS_OUTPUT.PUT_LINE ('This is a Syntax test');

ENDD;

contains a syntax error, ENDD should be END only.

For runtime error:

Declare

Abc number;

Begin

Select Col1 into Abc from TAB1 where col1 like ‘%A%’;

End;

As this will return a character into Abc, so it’ll give runtime error.

Q. What is difference of Commit, Rollback and Savepoint.

A. 1. When a COMMIT statement is triggered to the database, the transaction has ended, and the following results are true:

 a. All work done by the transaction in the session becomes permanent.

b. Other session can see changes in data made by the transaction.

c. Any locks acquired by the transaction are released.

2. When a ROLLBACK statement is triggered to the database, the transaction has ended, and the following results are true:

a. All work done by the transaction is undone, as if it hadn’t been issued.

b. Any locks acquired by the transaction are released.

c. The ROLLBACK statement undoes all the work done by the user in a specific transaction/session. With the SAVEPOINT command, however, only part of the transaction can be undone.