GE PLSQL Interview Questions

PL/SQL Interview Questions, AskHareesh.blogspot.com

GE PLSQL Interview Questions

  1. Tell me about your self, educational details and u r projects
  2. Tell me about your current project.
  3. How will rate yourself in PRO*C, SQl,PL/SQL and UNIX
  4. I have 10,000 records,. The record length is 70 characters? How will insert at a time 500 records into a database
  5. After inserting 500 records, unexpectedly the program was aborted? Again we run the program. From which position the records are inserted into a database.
  6. How do you know the how many records are processed in PRO*C
  7. Explain sqlca structure
  8. What is the maximum error message length returned by sqlcode.sqlerrm.sqlerrmc?
  9. If I Want to display the error message, which is more than 70 character? How to obtain it?
  10. Until runtime I dont know the table name, to select a query. Which method u should follow?
  11. I had one varchar variable. I assign a value to that character arrary arr. Is it sufficient?
  12. How handles errors in PRO*C
  13. How to compile u r PRO*C program
  14. How to compile the C program
  15. How to run programs
  16. Do u know the oracle architecture
  17. What is meant by oracle instance
  18. What is inline view? What are the advantages
  19. What is package? What are the advantages
  20. Till now how many packages u r written
  21. Some columns having indexes. How to know which columns having indexes in a table
  22. What is index? Types of index? What is the advantages of bit-map index?
  23. How do you optimize u r query?
  24. How to know the cost of the query?
  25. What is a trigger?
  26. Have you use instead of triggers
  27. How many types of joins u know?
  28. What is meant my outer join? Can write one sample query?
  29. What is full join? Tell me one example?
  30. what is grep? How to find blank lines in a file?
  31. What is find?
  32. What are the other command u know?
  33. what are the major significant you achieve in u r experience?
  34. Your Project Leader gave a compliant on you to your PM? What u do?
  35. Have u prepared any documentation?


*/