Oracle Placement Paper V

Oracle Placement Paper Technical 2009 @ Nagpur

1. Identify the relationship between the many employees
working
in a dept..
a. one to one
b. one to many
c. many to one
d. many to many
 

2. The process of including some controlled redundancy for the sake of performance
is known as
a. normalization
b. Cartesian product
c. Denormalization
d. None
 

Oracle Placement Paper IV

Oracle Placement Paper Aptitude & Technical On Mar 2011 @ Chennai

Aptitude section of Oracle

1. Two words are given by
Word 1: 83263641
Word 2: 3715468 ( don?t remember the order of the numbers.)
Each character is represented by a digit and each digit represents a character.
It is given that T and R occur four times. S and A occur two times. E, P, O and M occur one time each. The word
 

2. starts with T. The letter E occurs in word one only. The questions were,
a). Which number represents T.
b). Which number represents S.
c). Which character represents 2.
d). Which digit represents A.
e). Which word represents word 2.
 

Oracle Placement Paper III

Oracle Placement Paper Pattern & Interview On 2011 @ Mumbai

Paper Pattern:

30 Technical Questions – Time 30 minutes. Mostly on DBMS, Oracle (like what would be the output), C, C++, Java (2-3 Questions on class and constructors) and data structures. 30 General Questions – Time 30 minutes.7 Aptitude Questions, more like English (filling up prepositions, same meaning, reading comprehension, four sentences would be given ? you have to order them to form a paragraph, similarly four questions would be given – you have to say which one is a inference statement, which one is a judgment, etc.)
The technical test would be easy and general test would be little difficult.
In the interview, they asked me the following questions:
 

1. what are the macros other than C macros (the macros in word, excel)?
Ans. A macro in MS-word is used to group a sequence of jobs and make it as a button or
keyboard shortcut. Suppose, if you need always to draw a table containing 2 rows and 5 cols,you can start,record a macro and make it as a button and put in taskbar, so that when you press it, you will be provided with a fixed table.
 

2. Can you delete a column from a table?
Ans. In oracle fine, you can do it by the statement ALTER TABLE table1 DROP COLUMN
column1; In oracle 8, you can’t.

Oracle Placement Paper II

Oracle Placement Paper & Interview On 2011 @ Kolkatta

1.void main()
{

struct a
{ char ch[10];
char *str;
};
struct a s1={“Hyderabad”,”Bangalore”};
printf(“\n%c%c”,s1.ch[0],*s1.str);
printf(“\n%s%s”,s1.ch,s1.str);
getch();
}
Ans: HB, HyderabadBangalor
 

2. main(int argc,int *argv[])
{ int i;
for(i=1;i<argc;i++)
printf(“\n%s%s”,argv[i],(i<argc-1)?”":”");
return 0;
getch();
}
Ans: I work for oracle
 

Oracle Placement Paper I

Oracle Placement Paper Pattern & Interview On 2011 @ Bangalore

ROUNDS:

1. Aptitude Test,
2. Technical Round-1
3. Technical Round-2

Interview:

1. Tell me about your self?
Ans: I did a bad answer so the first impression is best impression i did not not get the best
impression so i know my self i did bad answer i am nervous that is my first time with hr.

2. what is your roll in project?
Ans: I had developed the uml diagram for my project and testing phase, i had taken fort the development of project.