Tuesday, July 27, 2010

Oracle Company Exam Papers



SUCCESS FOR CAREER








oracle company exam papers



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;iprintf("\n%s%s",argv[i],(ireturn 0;
getch();
}
file://Ans: i work for oracle

3.void main()
{
int i,j,k;
for(i=0;i<3 br="" i="">k=sum(i,i);
printf("\n%d",k);
getch();
}
sum(s,t)
{
static int m;
m+=s+t;
return m;
}
file://Ans: 6
4.void main()
{
int i;
clrscr();
for(i=1;i<6 br="" i="">switch(i)
{
case 1:
case 2: printf("%d,",i++);break;
case 3: continue;
case 4: printf("%d,",i);
}
printf("%d",i);
getch();
}
file://Ans: 1,4,6

5.Which of the storage class(es) becomes the global
variables for the =
entire
Program
(A) Extern
(B) Static
(C) Auto
(D) Register
ANSWER : A

6.//What is the output of the program
void main()
{
char s[]="oracle is the best";
char t[40];
char *ss,*tt;
while(*tt++=*ss++);
printf("%s",t);
getch();
}
// A. oracle is the best
// B. Core dump
// c. Error Message
// D. Goes into infinite loop
// Ans: B. core dump (Garbage value)

7.//What is the output of the program
void main()
{
int j[10]={9,7,5,3,1,2,4,6,9};
int i=1;
clrscr();
for(;i<9 br="" i="">printf("%d ",--j[i++]);
getch();
}
// A. 6,2,1,5
// B. 6,2,1,5,7
// c. Error Message
// D. core dump
// Ans: A. 6,2,1,5

8.//What is the output of the program
void main()
{
int i,j,k,n=5;
clrscr();
for(i=5;i>0;i--)
{
j=1k=n&j;
k==0?printf("0"):printf("1");
}
getch();
}
// A. 00011
// B. 11110
// c. 11001
// D. 11100
// Ans: B. 11110
9.Which of the following storage class(es) became
the global variable =
for the entire program
A. Extern
B. Static=20
c. Auto
D. Register
Ans: A

10.//What is the output of the program, if integer
occupies 2 bytes =
memory?
union
{
int a;
char b;
char c[10];
}u1;
void main()
{
int l=sizeof(u1);
printf("%d",l);
getch();
}
// A. 13
// B. 10
// c. 16
// D. None of the above
// Ans: B. 10
11.//What is the output of the program
void main()
{
fork();
printf(" Hello World");
getch();
}
// A. Hello World
// B. Hello World Hello World
// c. Error Message
// D. None of these
// Ans: B

12.//What is the output of the program
void main()
{
struct a
{
int i;
char *st1;
};
typedef struct a ST;
ST *str1;
str1=(ST*)malloc(100);
str1->i=100;
strcpy(str1->st1,"Welcome to Oracle");
printf(" %d%s\n",str1->i,str1->st1);
getch();
}
// A. core dump
// B. will not compile
// c. 100,Welcome to Oracle
// D. None of these
// Ans: C

13.//What is the output of the program
void main()
{
int i,j,k;
i=2;
j=4;
k=i++>j&2;
printf("%d\n",k);
if(++k && ++i<--j br="" i="">{
j=++k;
}
printf(" %d %d %d",i,-j--,k);
getch();
}
// A. 4,-3,2
// B. 5,-3,2
// c. 4,-2,2
// D. 5,-2,2
// Ans: D

14.Which of the following is not true incase of
Command line arguments
A.The argc parameter is used to hold the number
of arguments in the =
command line and is an integer
B. The argv parameter is a pointer to an array of
a character =
pointer and each one points to command line
arguments
C. The argv[1] always point to program name
D. None of above
Ans: C

15. A function without any return type declares
return=20
A. Integer
B. Float
C. Void
D. Syntax Error
Ans: A

16.//What is the output of the program
#include
#include
#define sqr(a) a*a
void main()
{
int a=10,b=1,c;
c=sqr(10+1);
printf("Sqr Root of (10+1)is %d",c );
getch();
}
// A. 121
// B. 21
// c. 13
// D. Syntax Error
// Ans: B

17.//What is the output of the program
#include
#include
void main()
{
int i,j=20;
clrscr();
for(i=1;i<3 br="" i="">{
printf("%d,",i);
continue;
printf("%d",j);
break;
}
getch();
}
// A. 1,20
// B. 1,20,1,20
// c. 1,2
// D. 1,2,20,20
// Ans: c

18.//What is the output of the program
#include
#include
void main()
{
int i=1*4/3-27%3^2+100*0.5-(4>3?1:2);
clrscr();
printf("%d",i);
getch();
}
// A. 49
// B. compile error
// c. 51
// D. 48
// Ans: b

19.What is the output of the program
#include
#include
void main()
{
char *st1[3]= {"Hello","World","Oracle"};
*st1=st1[2];
st1[1]=*st1;
free(st1[0]);
free(st1[1]);
clrscr();
printf("%s %s %s",st1,st1[1],st1[2]);
getch();
}
// A. Garbage Garbage Oracle
// B. oracle oracle oracle
// c. Hello World Oracle
// D. Core Dump:cannot Print after freeing the
memory
// Ans: D

20.Consider the following structure =20
Struct {
int data;
struct node *prev;
struct node *next;
}NODE;
NULL <-- --="" 5=""> 8 --> 10 --> NULL
p <-- br="" q="" r="20">WHAT WILL BE THE VALUE OF r-->prev-->-->next-->data
?
A. 8
B. Null
C. 5
D. 10
Ans: 10

21. what will be the output of the fallowing SELECT
statement ?
SELECT count(*)
FROM emp
Where exist (select 'X' From dept
where dept_name ='Stores'
and dept.dept_id=emp.dept_id)
A. select total number of employees belonging to
department " stores "
B. select all employees belonging to department "X"
C. select all employees belonging to department
"stores"
D. select total number of employees belonging to
department "X"

22. Denormalisation is done to=20
A. Check for Data Integrity
B. Reduce Data Redundancy
C. Intoduce Security Check
D. Increase Query performance .

23. How many columns are retrived from this query:
SELECT address1 || ',' ||address2 ||','
||address2 "Address" FROM =
employee;
A. 3
B. 2
C. 1
D. 0

24. What is the is the result of the fallowing Code
Piece=20
Insert into table A value(a1):
CREATE TABLE B AS SELECT * FROM A;
ROLLBAACK ;
A. Table B gets created with the row inserted in the
first statement.
B. Table B is not created
C. Table B gets created , but no row gets inserted
into Table A
D. Rollback throws up an exception .

25. The key word used in Oracle for string searching
is=20
A. SOUNDEX
B. DECODE
C. LIKE
D. HAVING

26. What does the ROLLBACK statement wil do in the
fool segment of =
code
PROGRAM STARTS HERE
........
SOME DML STAT.
...SAVEPOINT1
SOME DML STAT.
...SAVEPOINT2
SOME DML STAT.
...ROLLBACK
A. Rollback Dml changes to savepoint 1
B. Rollback Dml changes to savepoint 2
C. Rollback Dml changes of the last DML
ststs. just before =
ROllback stats
D. Rollback DML changes to the place whre the
program starts

27. Which clause u use to exclude the rows before
grouping them?
A. Group By
B. Having
C. Where
D. Minus

28. Which of the following statements is not true
about views?
A. u can create a index on views
B. Views donot have permanent data
C. Views can be based on one or more tables
D. Views can be dropped without dropping
Tables

29 How many JION conditions are needed in JOIN query
to avoid a =
Cartesian Product?
A. No of tables + 1
B. No of tables - 1
C. No of colums + 1
D. No of colums – 1

30. "An item could be either a component or spare ".
How can u =
represent this scenerio in a E-R=20
A. Subtype Relation
B. Arc Relation
C. Recursive Relation
D. Many to Many Relationscription




EXAMPAPERS123.BLOGSPOT.COM


Keane s Chennai Centre Interview questions



SUCCESS FOR CAREER






Keane s Chennai centre The company s hard line sent ripples across the industry Less than a month later the $1 billion US company with software development and BPO operations in India was



1) c concepts,programs asked to write
2) c++(virtual functions,static ,polymorphism)
3) cobol divisions
4) project questions(asp)
5) data base questions
6) some personal details and 3 puzzles like largest number
with 6 numbers etc.
7) about my ur self.


1) project
2) dead lock and prevention,detection methods
3) page faults with example
4) OSI reference model
5) swaping with out using 3rd variable
6) inorder, preorder, postorder(data structures traversals with example)
7) some sql queries containing having, orderby, groupby and subqueries
8) multi level threads, multi tasking difference
9) query for count the employees departmentwise
10) database types
11) diff. b/w dbms and rdbms
12) tcp/ip networking model
13) diff. b/w ring topology and bus topology
14) hr question : if u r officer incharge of hitech city like a plane
crashes into wto towers a plane crashes into the hitech city
then what r the measures taken by you to save the people inside
the building ?
15) diff b/w physical memory and logical memory ?
16) query for converting one to many relation in to a one to one relation ?
for this he was given his own table !
17) binary search algorithm ?


1) about my self
2) about project
3) computer networks- in which layer router is used
4) stack program
5) types of a database - explain them
main stress on relational database.
6) what is compaction.
7) operating system.


1) normalization
2) data abstraction
3) use of trees
4) types of data base systems
5) finding an element in hierarchical database
6) sql queries
7) operator overloading, overloading ---> difference
8) polymorphism implementation
9) tcp / ip
10) osi/iso layers
11) differences in tcp and iso
12) functions of layers in tcp,iso
13) relation between primary key,foreign key

1) questions on my project
2) what is ur favourite subject
i answered 'neutral networks'
3) what is ur favourite programming lang.
my answer is 'c'
4) they asked me to write a program for bubble sort ?
5) wap to print pyramid of stars?
6) program to check whether the given no is armstrong
number or not?
7) they asked one question on o.s.concepts ?
8) a puzzle "there are three bulbs in a room and there
r three switches outside the room........" ?
9) another puzzle "there r 2 stations a and b of distance of 200km
and two trains start from each station oppositely...."
10) do u have any doubts ?


1) referential integrity constraint
2) different sql statements(dml,ddl,dcl) ?
3) diff. b/w commit and rollback(save point) ?
explain with example?
4) primary key, foreign key ?
5) write a query to get maximum salary from
each dept with all details?
6) paging ?
7) segmentation ?
8) what is OS ?
9) cpu scheduling algorithms all explain ?
10) network layers ?
11) do we require all layers?
ans : no (don't require presentation and session layer)
12)a) diff. b/w javascript and vbscript ?
ans : java script for client side and vbscript for server side
b) can i use java script for server side scripting ?
ans : yes
13) hashing in datastructers
14) in cobol
do u know cobol ?(ans is no,not comfortable)
15) what happens if u have tables with many to many relationships ?
ans: redundancy ,anamolies etc will occur


1) acadamic and family background ?
2) favourite subjects in MCA curriculam ?
i have selected SE,CPP,OS
3) what is SDLC and explain phases ?
4) what is requirement analysis and how it is?
5) what are different types of testing techniques ?
6) what is OS ?
7) what are the functions of OS ?
8) how cpu time is scheduled and what are the algorithm
9) explain round robin algorithm ?
10) what is deadlock situation ?
11) how we can prevent deadlocks
12) how a program can be run ?
13) draw computer block diagram ?
14) write a program to print as follows
* * * *
* * *
* *
*
15) program to sort the array (any sorting technique
ur wish)
16) what is .obj file and when it will be generated?
17) how .exe file will come into existance ?
18) they the subject what i have in curriculum and
asked randomly ?
19) what is osi reference model ?
20) explain layers in osi
21) where the error will be caught while transmitting ?
22) diff. b/w queues and stacks ?
23) how linked list different from stacks and queues?
24) how many sorting techniques are there
25) what is a register,how it will be useful ?


1) operating system - system calls,disk scheduling algorithms
2) RDBMS - embedded sql,4-5 queries
3) normalization
4) write 2nd normalization form of a table
5) s/w engg : reverse engg
6) how you used s/e engg in ur project
7) c: dynamic memory alloaction
8) project details


1) tell me about ur self
2) what is ur opinion about hyderabad and which places u like ?
3) normalization ?
4) diff. b/w primary key and unique key
ans: unique key accepts null value
primary key dont accept any null value
5) whether one null value is equal to another null value ?
6) types of dbms ?
7) constraints and their types ?
8) query to retrive the ename start with A ?
9) 200km dist,both trains started at speed 100km oppositely and one bird
is starting with one train at 120 km then what is the distance travelled
by bird if both the trains collide ? (ans: 120 km)
10) if u litting a thread it will take one hour for complete buring
of thread what do u do if i want to burn it in halfen hour ?
11) three bulbs, three switches how to identify which switch is for which bulb?
0
12) how to prove A =1(a power zero is equal to one)


1) tell me about ur self
2) how will u store the data in oracle from vb form and how will u retrive
data from oracle to vb ?
3) what is referential integrity ?
4) diff between primary key and unique ?
5) what is foreign key ?
6) display the employs those who r getting salary greater than
average of all employees ?
7) count the no of employees for question 6 ?
8) display all the details of deptname and deptcode whose no of employees
in a particular department is < 2 ?
9) types of databases
10) display each deptname and no of employees exist in that particular dept
11) SDLC phases,what is the output of analysis ?
12) types of testing,regression testing,integration testing ?
13) what do u do in analysis phase ?
14) how much % u got in ur mca ?
15) why do u fail in dcf 1st sem of mca ?
16) c program for sum of digits of a number ?
17) c program for swaping numbers without using third variable ?
18) 200km dist,both trains started at speed 100km oppositely and one bird
is starting with one train at 120 km then what is the distance travelled
by bird if both the trains collide ? (ans: 120 km)
19) if u litting a thread it will take one hour for complete buring
of thread what do u do if i want to burn it in halfen hour ?
20) what do u call in oracle %,_ (wild characters)


1) tell me about ur project ?
2) dbms normalization,queries,referential integrity,constraints ?
3) what is paging,virtual memory ?
4) program to insert a node into linked list ?
5) about trees and their uses ?
6) microprocessors : 8085 (explain instrctutions)


Data Structures


1.what is meant by tree
2.draw a binary tree
write postorder,preorder,inorder for that tree
3.complexties of sortings
4.write aprogram for stack
5.applications of stacks,tree
6.something on linked list


Operating System


1.jobscheduling
2.paging
3.os services
4.system calls
5.file management
DBMS


1.how mant primary keys can exist for a table
2.define constraints one by one
sql(nearly ten+ queries )
1.subqueries
2.joins
3.select 2nd highest salary
4.groupby,having,orderby rules with examples
cn
1.osi model
2.function of each layer
3.protocol means tell some protocol
4.ethernet
C Programing


1.write a program for prime number checking
2.write a program for quicksort
3.explain quick sort with a example
4.break,continue

1)ell about ur self
2)about project, favorite subs in mca
3)diff b/w array,stack and queue
4)normalisation
5)cobol divisions
6)what did u learn in mobile computing,sys adm,s/w reuse tech
7)cobol format
8)s/w eng phases
9)write prog on factorial
10)more questions on cobol
11)page fault
12)testing and types of testing
13)primary key,foreign key

1. what is ur project ?
2. which algorithms used and why ? why don't choose other algorithms ?
3. some basic questions on my project
Microprocessors


4. do you know assembly lang(8085)? [i am btech ece]
5. tell me basic structure of that lang ?
6. can you explain JNC,JZ commands ?
7. what do u know mean cisc and risc and what is the diff b/w them ?
8. do you know the functions of risc ?
digital electronics
9. what do you mean by switching ?
10. can you write the truth table of NAND and NOR gates ?
11. can you tell about logic families ?

1. introduction to c
2. pointers in c
3. swap two numbers without using temparory variable
4. what is object based lang ?
5. what is object oriented lang ?
6. what is normalization(1nf,2nf,3nf) ?
7. DataBase models
8. prove a power zero is equal to one ?
9. integrity constraints
10. what is diff. b/w inline functions and macros ?



EXAMPAPERS123.BLOGSPOT.COM

Monday, July 26, 2010

The Infosys Question Paper





SUCCESS FOR CAREER




1. There is a circle race going on. One of them says,”1/3 of those in front of me and ¾ of those behind me, give the total number of children in the race”. Then the number of children took part in the race?
Ans : 13

2. In an Island the natives lie and visitors speak truth. A man wants to whether a salesman beside him in a bar is a native or visitor. He asked him to ask a woman beside him whether she is a native or visitor. He replied that she says “she is a visitor”. Whether the salesman is a native or visitor?
Ans : Visitor

3.A man fixed an appointment to meet Mr.X, X asked him to meet two days after the day before the day after tomorrow. Today is Friday. Whats the appointed day.
Ans: Monday

4. A jewel problem, with some conditions and it is quite easy to solve.

5.A man said he spent 1/6 of his as a child, 1/12 as salesman in a liquor shop, 1/7 and 5 years as a politician and a good husband respectively. At that time Jim was born. Jim was elected as Alderman four years back. when he was half of his age. What is his age.
Ans: 84 ( It is same as diaphantus problem given in shakuntala devi -2 part)

6.Jack,Dough and Ann, 3 children had a race when returning from school. Ann takes 28 steps when Droug takes 24 steps, meantime Jack takes 21 steps. Jack explained that his 6 steps equals Droug’s 7 steps and Ann’s 8 steps. Who won the race?
Ans: Dough

7. Every day a cyclist meets a car at the station. The road is straight and both are traveling in the same direction. The cyclist travels with a speed of 12 mph. One day the cyclist comes late by 20 min. and meets the car 5miles before the Station. What is the speed of the car?
Ans: 60 mph

8. A problem of persons and profession. 4 persons were there- Jack, Clove, Smith, Morgan. Some conditions were there. I do’t remember, but I remember the answer.
Ans: Clove : Druggist
Jones: Grocer
Morgan : Butcher
Smith : Policeman

9.A lady goes for shopping. She bought some shoestrings. 4 times the number of shoestrings, she bought pins and 8 times, handkerchiefs. She paid each item with their count as each piece’s cost. She totally spent Rs. 3.24. How many handkerchiefs did she buy?
Ans : 16

10. Complete the series :
a) 3,6,13,26,33,66,____
b) 364,361,19,16,4,1,___
Ans : a) 73
b) 1



EXAMPAPERS123.BLOGSPOT.COM