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