Plsql Interview Questions And Answers

1. What is the starting "oracle error number"? 2)What is meant by forward declaration in functions?
2. Can Commit,Rollback ,Savepoint be used in Database Triggers?If yes than HOW? If no Why?With Reasons
3. Can we declare a column having number data type and its scale is larger than pricesion ex: column_name NUMBER (10,100), column_name NUMBAER(10,-84)
4. Explain how procedures and functions are called in a PL/SQL block ?
5. Explain the two type of Cursors ?
   
6. Explain the usage of WHERE CURRENT OF clause in cursors ?
7. Explian rowid,rownum?What are the pseduocolumns we have?
8. Give the structure of the function ?
9. Give the structure of the procedure ?
10. How many types of database triggers can be specified on a table ? What are they ?
11. How packaged procedures and functions are called from the following? a. Stored procedure or anonymous block b. an application program such a PRC *C, PRO* COBOL c. SQL *PLUS
12. How to avoid using cursors? What to use instead of cursor and in what cases to do so?
13. How to debug the procedure ?
14. How to disable multiple triggers of a table at at a time?
15. How we can create a table in PL/SQL block. insert records into it??? is it possible by some procedure or function?? please give example...
16. How we can create a table through procedure ?
17. In a Distributed Database System Can we execute two queries simultaneously ? Justify ?
18. In pl/sql functions what is use of out parameter even though we have return statement.
19. Whar are Integarity Constraints?
20. Is it possible to use Transaction control Statements such a ROLLBACK or COMMIT in Database Trigger ? Why ?
21. Name the tables where characteristics of Package, procedure and functions are stored ?
22. Open C1; Fetch c1 into Z; Commit; Fetch c1 in to Z; end;
23. State the advantage and disadvantage of Cursor?
24. State the difference between implicit and explicit cursor's.
25. What are % TYPE and % ROWTYPE ? What are the advantages of using these over datatypes?
26. What are advantages fo Stored Procedures
27. What are the PL/SQL Statements used in cursor processing ?
28. What are the Restrictions on Cursor Variables?
29. What are the components of a PL/SQL Block ?
30. What are the cursor attributes used in PL/SQL ?
31. What are the datatypes a available in PL/SQL ?
32. What are the modes of parameters that can be passed to a procedure ?
33. What are the return values of functions SQLCODE and SQLERRM ?
34. What are the two parts of a procedure ?
35. What are two parts of package ?
36. What are two virtual tables available during database trigger execution ?
37. What happens if a procedure that updates a column of table X is called in a database trigger of the same table ?
38. What is Overloading of procedures ?
39. What is PL/SQL ?
40. What is PL/SQL table ?
41. What is Pragma EXECPTION_INIT ? Explain the usage ?
42. What is Raise_application_error ?
43. What is a cursor ? Why Cursor is required ?
44. What is a cursor for loop ?
45. What is a database trigger ? Name some usages of database trigger ?
46. What is a stored procedure ?
47. What is an Exception ? What are types of Exception ?
48. What is difference between % ROWTYPE and TYPE RECORD ?
49. What is difference between a Cursor declared in a procedure and Cursor declared in a package specification ?
50. What is difference between a PROCEDURE & FUNCTION ?
51. What is difference between stored procedures and application procedures,stored function and application function?
52. What is pl/sql?what are the advantages of pl/sql?
53. What is ref cursor.
54. What is the basic structure of PL/SQL ?
55. What is trigger,cursor,functions in pl-sql and we need sample programs about it?
56. What will happen after commit statement ?
57. What will the Output for this Coding> Declare Cursor c1 is select * from emp FORUPDATE; Z c1%rowtype; Begin
58. Where the Pre_defined_exceptions are stored ?
59. Write the order of precedence for validation of a column in a table ? I. done using Database triggers. ii. done using