PL/SQL interview questions and answersFull description
Oracle Pl SQL Interview Questions for 3 years expFull description
Deskripsi lengkap
Pertanyaan dan jawaban UAS Oracle PL/SQLFull description
Guia Fundamentos Oracle PL/SQL
some of my best knowledge
Aprende el PL/SQL de Oracle 10g. Escrito en español. PDF actualizado disponible en http://solucionjava.com/manuales_gratis.phpDescripción completa
Full description
http://neworacledba.blogspot.com Plenty of useful articles on oracle, dba, oracle rac, dataguard, streams, many certification exams, project management professional, pmp and many more…Full description
Oracle Interview Questions
Oracle
oracle interview questions
1001 Oracle Interview Questions and Answers
Oracle_Interview_Questions_1_
1001 Oracle Interview Questions and Answers
http://skills9.com/30-top-oracle-p http://skills9.com/30-to p-oracle-plsql-intervie lsql-interview-questions-a w-questions-andndanswers/ 30 TOP Oracle Pl/SQL Interview Questions and Answers List of top 30 most frequen frequently tly asked oracle pl/sql interview questions and answers pdf download free
Oracle Pl/SQL Interview Questions and Answers List 1. What is difference difference b/w stored procedures procedures and application application procedures, procedures, stored stored function and and application function? 2. Explian rowid, rownum?what are the psoducolumns we have? 3. what is the starting starting oracle oracle error number? number? 4. In a Distributed Database System Can we execute two queries simultaneously? simultaneously? Justify? 5. 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? 6. How to avoid using cursors? What to use instead of cursor and in what cases to do so? 7. State the difference between implict and explict cursors? 8. How to know the last executed procedure? 9. How can a function retun more than one value in oracle with proper example? 10. If the application is running very slow? At what points you need to go about the database in order to improve the performance? 11. What is the basic basic structure of PL/SQL? PL/SQL? 12. What are the componen components ts of a PL/SQL PL/SQL block? 13. What are the datatypes a available available in PL/SQL? PL/SQL? 14. What are % TYPE and % ROWTYPE? What are the advantages of using using these over over datatypes? 15. What is difference difference between between % ROWTYPE ROWTYPE and and TYPE RECORD? RECORD? 16. What will the Output for this Coding. 17. What are the Restriction Restrictionss on Cursor Variables? Variables? 18. Can we declare a column having number data type and its scale is larger than pricesion. 19. What will happen after after commit statement? statement? 20. Explain the usage of WHERE CURRENT OF clause in cursors? 21. What is a database trigger? Name some usages of database trigger? trigger? 22. How many types of database triggers can be specified on a table? What are they? 23. Is it possible to use Transaction control Statements Statements such a ROLLBAC ROLLBACK K or COMMIT in Database Trigger? Why? 24. What 24. What are two virtual tables tables available during database trigger execution? execution? 25. What 25. What happens happens if a procedure procedure that updates a column of table X is called called in a database trigger of the same table?
26. Write 26. Write the order order of precedence precedence for validation of a column in a table? 27. What is an Exception? 27. What Exception? What are are types of Exception? Exception? 28. What 28. What is Pragma EXECPTI EXECPTION_INIT? ON_INIT? Explain Explain the usage? 29. What 29. What is Raise_application_ Raise_application_error? error? 30. What 30. What are the return values values of functions functions SQLCODE SQLCODE and SQLERRM? SQLERRM?
