First aptitude test was taken which was of 15 minutes duration. Some candidates got eliminated. Next was technical test which was of 30 minutes duration and it had 30 questions. The questions were mainly related to SQL and PL/SQL.
Some questions of aptitude section are listed below:
1. There were question on profit/loss, geometry, ratio and probability.
2. A man spent 1/6 of his life as a child, 1/12th of his life as teenager and 1/7 of his life as unmarried man. After 5 years of his marriage, he was blessed with a son. But, the son died 4 years before father expired and his age was half the age of his father at that time. Based on this, it was required to find the age of father, age of son and age of father when he got married.
3. Find the sum of the four digit numbers formed using the digits 0, 1, 2 and 3 used only once.
4. There are 10 students in a class. The teacher writes a number on the board. First student says that the number is divisible by 1, second student says that it is divisible by 2, third by 3 and so on till 10th student. If one of the students is lying, what is the least number possible?
5. There were some questions on comprehension.
Some questions of technical section are listed below:
1. There were some questions on SQL queries, Triggers, procedures and SELECT statements.
2. Which of the operator is not used in outer join : a) = b) != c) AND d) OR
3. Which of these is used by PL/SQL : a) Early binding b) Late binding c) No Binding d) Deferred binding
4. One question was on NLS_DATE_FORMAT.
5. Some questions were on C and Java program.
First aptitude test was taken which was of 15 minutes duration. Some candidates got eliminated. Next was technical test which was of 30 minutes duration and it had 30 questions. The questions were mainly related to SQL and PL/SQL.
Some questions of aptitude section are listed below:
1. There were question on profit/loss, geometry, ratio and probability.
2. A man spent 1/6 of his life as a child, 1/12th of his life as teenager and 1/7 of his life as unmarried man. After 5 years of his marriage, he was blessed with a son. But, the son died 4 years before father expired and his age was half the age of his father at that time. Based on this, it was required to find the age of father, age of son and age of father when he got married.
3. Find the sum of the four digit numbers formed using the digits 0, 1, 2 and 3 used only once.
4. There are 10 students in a class. The teacher writes a number on the board. First student says that the number is divisible by 1, second student says that it is divisible by 2, third by 3 and so on till 10th student. If one of the students is lying, what is the least number possible?
5. There were some questions on comprehension.
Some questions of technical section are listed below:
1. There were some questions on SQL queries, Triggers, procedures and SELECT statements.
2. Which of the operator is not used in outer join : a) = b) != c) AND d) OR
3. Which of these is used by PL/SQL : a) Early binding b) Late binding c) No Binding d) Deferred binding
4. One question was on NLS_DATE_FORMAT.
5. Some questions were on C and Java program.