Programming Interview Questions

“We have the following schema of a table:

  create table Test (id number, name varchar2(32), desc varchar2(400));
  create index index_test on Test (name);

Which of the following statements will invoke an index scan by oracle
execution plan

 a) select * from test where name='name';
 b) select * from test where name like 'name%';
 c) select * from test where name like '%name';
 d) select * from test where name like '%name%';"”

View Answers (1)

“Consider the following function:

    int f (int num)
        {
                int out = 0;

                for (; num > 0; num /= 10) {
                        int d = num % 10;
                        out *= 10;
                        out += d;
                }

                return out;
        }

1) What does it do?

2) Write the same algorithm using recursion”

View Answers (3)

“What is the output from this code (assume int is 32 bit)

int f(int n)
{
    return n * f(n-1);
}

print(f(100));”

Answer Question

“Analyse a situation where you get a segmentation fault and whats the reason”

Answer Question

“How would you find bugs in a very large program. This is one of the few questions I wasn't able to answer to my satisfaction at least, since I hadn't worked with large programs and were still limited to small simple debugging techniques”

View Answers (1)

“typically questions consist of book defination of class and object, polymorphism , over riding etc”

View Answers (1)

“What is inheritance?”

Answer Question

“What is a class?”

Answer Question

“Write the code in c++ to remove a node in a singly linked list”

Answer Question