List of top 30 most frequently asked oracle pl/sql interview questions and answers pdf download free
Oracle Pl/SQL Interview Questions and Answers List
- What is difference b/w stored procedures and application procedures, stored function and application function?
- Explian rowid, rownum?what are the psoducolumns we have?
- what is the starting oracle error number?
- In a Distributed Database System Can we execute two queries simultaneously? Justify?
- 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?
- How to avoid using cursors? What to use instead of cursor and in what cases to do so?
- State the difference between implict and explict cursors?
- How to know the last executed procedure?
- How can a function retun more than one value in oracle with proper example?
- If the application is running very slow? At what points you need to go about the database in order to improve the performance?
- What is the basic structure of PL/SQL?
- What are the components of a PL/SQL block?
- What are the datatypes a available in PL/SQL?
- What are % TYPE and % ROWTYPE? What are the advantages of using these over datatypes?
- What is difference between % ROWTYPE and TYPE RECORD?
- What will the Output for this Coding.
- What are the Restrictions on Cursor Variables?
- Can we declare a column having number data type and its scale is larger than pricesion.
- What will happen after commit statement?
- Explain the usage of WHERE CURRENT OF clause in cursors?
- What is a database trigger? Name some usages of database trigger?
- How many types of database triggers can be specified on a table? What are they?
- Is it possible to use Transaction control Statements such a ROLLBACK or COMMIT in Database Trigger? Why?
- What are two virtual tables available during database trigger execution?
- What happens if a procedure that updates a column of table X is called in a database trigger of the same table?
- Write the order of precedence for validation of a column in a table?
- What is an Exception? What are types of Exception?
- What is Pragma EXECPTION_INIT? Explain the usage?
- What is Raise_application_error?
- What are the return values of functions SQLCODE and SQLERRM?