PL-SQL Interview Questions
- What is ref cursor?
- What is Data type?
- What is PL/SQL table?
- What is Set Transaction?
- What is a stored procedure?
- How to debug the procedure?
- What is Character Functions?
- What is Correlated Sub query?
- What are two parts of package?
- What is Raise_application_error?
- What are the two parts of a procedure?
- Operators used in Select statements are?
- What will happen after commit statement?
- What are the components of a PL/SQL block?
- How we can create a table through procedure?
- Where the Pre_defined_exceptions are stored?
- What are the Restrictions on Cursor Variables?
- What are the data types a available in PL/SQL?
- State the advantage and disadvantage of Cursor?
- The most important DDL statements in SQL are?
- What is pl/sql? What are the advantages of pl/sql?
- What is meant by forward declaration in functions?
- How to disable multiple triggers of a table at a time?
- What is difference between a Procedures & Functions?
- Explain the usage of Where Current OF clause in cursors?
- Explain rowid, rownum? What are the pseduocolumns we have?
- What is a database trigger? Name some usages of database trigger?
- Explain how procedures and functions are called in a PL/SQL block?
- What are two virtual tables available during database trigger execution?
- Which set of statements will successfully invoke this function within SQL*Plus?
- How many types of database triggers can be specified on a table? What are they?
- What is trigger, cursor, functions in pl-sql and we need sample programs about it?
- What occurs if a procedure or function terminates with failure without being handled?
- How to avoid using cursors? What to use instead of cursor and in what cases to do so?
- What happens if a procedure that updates a column of table X is called in a database trigger of the same table?
- Name the tables where characteristics of Package, procedure and functions are stored?
- What is the starting “oracle error number”?
- What is difference between stored procedures and application procedures, stored function and application function?
- What is difference between a Cursor declared in a procedure and Cursor declared in a package specification?
- What is the maximum number of handlers processed before the PL/SQL block is exited when an exception occurs?