Monday, April 25, 2011

Oracle interview questions !

1). How to find that an .so file is linked to how many other .so(s)?
2). How to read first 10 lines from a file?
3). How to change a word in a file without opening it?
4). How do you customize invoice number modification?
5). How to expose custom fields?
6). How will you check how many source files are linked to a given library (.so)?
7). What are the different types of joins?
Ans: Check this : http://en.wikipedia.org/wiki/Join_(SQL)

Thursday, February 24, 2011

Roamware interview questions !

Few questions from Roamware interview . Although it depends on who takes your interview. These were the questions asked to me :


1). Write a program for Binary Search.
2). Differnce between macro and constant.
3). what is #?
4). Difference between index and primary key?
5). Different types of joins in relational database.
6). Write a sql query to find the name of employee who gets second highest salary. The tables are :
         EmpDetail { EmpId, EmpName}
         SalaryDetail {EmpId, Salary}
7). SS7 description
8). SCP, SSP, MSC, VLR, HLR related basic questions.
9). Call flow and the various components interfaced during a call flow.
10). If a subscriber has placed a call to another subscriber, and some oss feature is comes in picture during the call, what would be the process of charging in case of prepaid customer.

But anyways, Roamware will try to ask you more and more difficult questions to lower down your salary expections. They can hire you if you can join them in 10% to 20% hike.

Tuesday, November 24, 2009

RBS Interview Questions

1. Write a program in Java to return fibonacci series in an array upto n numbers of the series :

int[] getFibonacci(int n);

2. Write a program to set a given name-value pair in cache so that the value expires after 5 min, the methods could be :

String getValue(String name); // Returns value corresponding to given name, if getValue is called after 5 min of calling setValue for the same pair, this will return null
String setValue(String name, String value); // Sets name, value pair in the cache and expires the data from cache after 5 min of upload

3. Give a design for desktop search engine including different components, data structure used, designs

4. Design a schema for School Management System for teachers, students and subjects where :

a). A teacher can teach to any number of studetns
b). A student can be taught by any number of teachers
c). A teacher can teach many subjects and a subject can be taught by many teachers
d). A student can study any number of subjects

Design the schema considering there are 15 subjects, 100 teachers and 1000 students so that the reports can be generated for conditions like
- Generate report for all the teachers who are teaching a particular subject to students

5. How can we make a class clonable?

6. Give a design for a system which has :
a). A flat-file database system
b). 10-20 processes reading/updating the DB system

Design this considering in mind that there could be clashes when more than 1 process will update the DB and you've to manage this so this conflict can never happen.

7. Why is java platform independent?

8. How you will design a system which needs 100 identical processes to perform some tasks? How many threads can be spawned to optimize this without degrading system performance?

Amazon Interview Questions

1. Write a Java program to find the number of words in a given string, the signature could be like :

int getWords(String s); or,
int getWords(char[] s);

2. Modify the above program to print the different words in different lines.

3. Write a program in O(n) or less order to find a unique character in an array of duplicates, e.g. the content of the array could be like ['a','c','a','b','b' ...]

4. Optimize the above algorithm when the array is sorted.

Wednesday, December 6, 2006

Agilent Interview Questions !

Few Questions from Agilent Interview :

1]. What are the default member functions included in the class definition ?
2]. Does default destructor provided by the compiler?
3]. How to make a class to restrict its number of instances to 5?
4]. What is singleton class? Design it.
5]. What will happen?

main(){
A a1;
a1=a1;
/* Some other code */
}

6]. main(){
int x=5;
printf("%d%d%d",x,++x,x++);
}

7]. main(){
int x=5;
printf("%d%d%d",x,x<<1,x>>1);
}

8]. What are the various storage classes ?
A. Extern, Static, Auto, Register

9]. Is this right ? Why or Why not?
static extern int x;

Ans: No, It will give compilation error. "more than one storage class specified", Reason is obvious.

10]. What is the need of writing our own copy constructor when it is by default provided by the compiler?

11]. What is object slicing?

12]. What is stack unwinding?

13]. Can we use references as class member variables?
Ans: Yes, we can. But then it must be initialized in constructor base/member initializer list. e.g.

class A{
int x;
int &y;
public:
A():x(1),y(x){
cout<<"A x="<

Friday, December 1, 2006

Freescale Interview Questions !

Hi,
Till now I haven't got any chances to get interviewed at freescale. So please if you can share some questions please post them.

Monday, November 27, 2006

Yahoo Interview Questions !

1). What is the output?
main()

{
char hi[2]="HI";
cout<< hi<<' '<<"Hello";
}

Ans: It will give error. 'HI' : array bounds overflow (Because string contains '\0' implicitly. "Hi" is of length 3.
2). Write a STRING class. Implement
- default constructor,
- Copy Constructor,
- Assignment Operator,
- String length function
- String Copy function
- String concatenation,
- Destructor

3). How to find the only unique number from a list of N integers where all are duplicates except one. Find the unique number in O(n) time.

Ans: start from the first element of the array and keep XORing it with the rest of the elements saving the result.
{
j=a[0];
for(i=1;i
{
j=j^a[i];
}
printf("\n\nThe Unique is %d\n\n",j);
}

4). Design patterns in c++