Scope international PLSQL Interview Questions

Scope international PL/SQL Interview Questions

1. How to see invalid indexes?
2. How to rebuild invalid indexes using pl/sql block
3. Which cursor are used in u r project,how to idenified which cursor are wrritten in u r  requirement?
4. which is better explict or implict?
5. Create small procedure in u r project you are created?
6. Do u know m_views? Explain wat is disadvantages and advantages?
7. When m_views are created mainly?if base table deleted what happen m_views?
8. Why are u creating m_views in u r project?main purpose?
9. In exceptions, write ora errors?
10. Ora errors where stored?
11. What are different types of queries
12. Write a correlated sub query and explain how it works
13. What are different type of statements
14. What tcl do
15. What is difference between stored procedure and function
16. How you handle errors
17. What is %type and %row type
18. What are different types of cursors
19. How implicit cursor works
20. What are different type of triggers
21. Write a pl/sql block for trigger at the time of insertion for inserting old and new values auditing table.
22. What are different types of joins
23. What self join do
24. Write an example and explain about self join
25. Write an example for left outer join and how output comes
26. What is difference between in and = operator
27. What is package
28. Tell some advantages of packages
29. What are collections in pl/sql
30. What are pointers in c
31. How you connect to data base
32. Some more interview questions asked in scope
33. Difference between cursor for loop and for loop, which is faster?
34. In proc and pl/sql, which is faster?
35. Which is best method to kill the process (unix or oracle)?
36. Difference between c shell, bourn shell, k shell?
37. What is inode?
38. How to search two patterns using grep pattern?
39. Difference between ls and find?
40. Difference between view and snapshot?
41. Difference between function and procedure?
42. Why we cannot use ddl commands in procedure?
43. Difference between global variable and static global variable?
44. How to access variable of nested procedure?
45. If we have both user exception and system exception, which will be handled first?
46. Difference between anonymous block and normal block?
47. Can we create snapshot for another schema?
48. How to access table from another database?