Accenture & HCL PL/SQL Interview question

We heartily thanks Barnwal for sharing collections of PL/SQL interview question asked in various companies.

Exp: 3 Year
comp: HCL, ACCENTURE

1- What are differences between delete and truncate statement ?

2-What is bulk sql?

3- What is bulk collect clause?

4-How many types of Exception Handling are there ?

5- What is ref cursor?

6- How many types of Views are there?

7- What is Materialized View?

8-What is Deterministic Function?

9-What is PRAGMA_Exception_Init?

10-What is Autonomous Transaction?

11-Wha is difference between DDL and DML command?

12-How we can see all the tables in one Schema?

13-What Exception Propagation?

14- What is Force View?

15- What is Instead of Trigger?

16- For Query Optimization, what methods you can use?

17-How you can use Cursor under Procedure?

18-What is commit, savepoint and Rollback?

19-What is difference between Procedure and Function?

20-What is correlated subquery?

21- What is Cursor and How many types of Cursor you have used?

22- What is self join?

23- What is Mutation of Tables?

24- What is Collection? And how many types of Collections are there?

25-What is FORALL statement?

26- What is RANK and DENS_RANK?

27-What is INDEX and how many types of INDEX are there?

28-What is CONNECT_BY clause?

29-What is Analytic function?

30- What is difference between View and Force View?

31- What is MERGE statement?

32- What is Cartesian Product?

 

 

 

 

HCL Telephonic Interview Question

HCL Bangalore Interview question (Telephonic Round)

1. Tell Me about yourself and projects in which you have worked so far. 

2. Then there were questions from project.

---- Now the real question start ..... he asked to have a notebook and a pen

3. How confident are you in c - rate yourself in a scale of 10

4. what is a volatile keyword

5. what is the output of the program <first he ask me to write each line, then output.>

#include<stdio.h>

int main(){

int i = -1, j=0,k=1;

int r = ++i || j++ && --k;

printf("%d %d %d %d", i, j, k, r);

return 0;

}

6. Will this program runs,if so then what is the output

#include<stdio.h>

int main(){

if() 

printf("Empty");

else

printf("not Empty");

return 0;

}

7. What will be the output of the program

#include<stdio.h>

int main(){

char *cptr=0;

int *iptr=0;

void *vptr=0;

cptr++;

iptr++;

vptr++;

printf("%u %u %u",cptr,iptr,vptr);

return 0;

}

HCL (Chennai) Telephonic Interview

HCL Interview Question

HCL (Chennai) Telephonic Interview

1. Tell me about yourself.
2. explain each step of compilation in c.
3. what is difference in macro and inline function.
4. I have multiple line of code and I want to use some part of code for one project requirement and other part of code or other project requirement, how you can achieve it.
5. what type of variable declaration in c.
6. In C program what type of main() function will be, whether it is declaration or definition. what is prototype of main.
7. What is the use of extern variable.
8. what is null pointer, where we use it.
9.What is an Opaque pointer.
10. what is memory leak.
11. can you tell me simple program of stack corruption.
12. what is difference between structure and union.
13. what is structre padding.
14. what is difference in malloc & calloc.
15. what does router do. do u konw any routing protocol.what does it user for.
16. Having single linklist there are 5 nodes and if I have address of third node, then how can I delete it.

CLICK --> For more fresh question being asked in various company follow us at facebook.

17. How you can find the middle of linklist.
18. how can u find the 2/3 of linklist.
19. which sorting technice is best as per you, can you explaion it.
20. what are the field of pkt will be modified in the below topology, form host A to server.
  Host A --- router A ------- router B -------router C -------- server.
21. What is NAT.
22. what is ARP, does arp pkt have ip hadder.
23. what is difference between trunk and access port.
24. What is use of fork system call.
25. what is difference betwwen fork and vfork.
26. having process in kernal and it recived an sigkill, what will happen, what will happen if process have child process.
27. what is IPC, what is difference in pipe and fifo.
28. Do you have any question for me.

CLICK --> For more fresh question being asked in various company follow us at facebook.