Sunday, September 25, 2016

Accenture Oracle SQL PL/SQL 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?

No comments :

Post a Comment