Accenture PLSQL Interview Questions
Accenture PLSQL Interview Questions
- What are different types of queries
- Write a correlated sub query and explain how it works
- What are different type of statements
- What TCL do
- What is difference between stored procedure and function
- How you handle errors
- What is %type and %row type
- What are different types of cursors
- How implicit cursor works
- What are different type of triggers
- Write a pl/sql block for trigger at the time of insertion for inserting old and new values auditing table.
- What are different types of joins
- What self join do
- Write an example and explain about self join
- Write an example for left outer join and how output comes
- What is difference between in and = operator
- What is package
- Tell some advantages of packages
- What are collections in pl/sql
- What are pointers in c
- How you connect to data base
- some more interview questions asked in scope
- Difference between cursor for loop and for loop, which is faster?
- In proc and PL/SQL, which is faster?
- Which is best method to kill the process (unix or oracle)?
- Difference between c shell, bourn shell, k shell?
- What is inode?
- How to search two patterns using grep pattern?
- Difference between ls and find?
- Difference between view and snapshot?
- Difference between function and procedure?
- Why we cannot use DDL commands in procedure?
- Difference between global variable and static global variable?
- How to access variable of nested procedure?
- If we have both user exception and system exception, which will be handled first?
- Difference between anonymous block and normal block?
- Can we create snapshot for another schema?
- How to access table from another database?
*/
