41. Explain autonomous transaction. An autonomous transaction is an independent transaction of the main or parent transaction. It is not nested if it is started by another transaction. There are Continue Reading »
Home / Posts Tagged "PL/SQL"
31. How would you reference column values BEFORE and AFTER you have inserted and deleted triggers? Using the keyword “new.column name”, the triggers can reference column values by new collection. Continue Reading »
21. Show the two PL/SQL cursor exceptions. Cursor_Already_Open Invaid_cursor 22. What operators deal with NULL? NVL converts NULL to another specified value. (41)
11. What are the rules to be applied to NULLs whilst doing comparisons? 1) NULL is never TRUE or FALSE 2) NULL cannot be equal or unequal to other values Continue Reading »
1.What is PL/SQL? PL/SQL is a procedural language that has both interactive SQL and procedural programming language constructs such as iteration, conditional branching. 2.What is the basic structure of PL/SQL? Continue Reading »
1.What is PL/SQL? PL/SQL is a procedural language that has both interactive SQL and procedural programming language constructs such as iteration, conditional branching. (187)
41.What do you understand by explicit cursors? Explicit cursors are defined explicitly using the CURSOR statement, with a general syntax − CURSOR cursor_name [(parameters)] IS query_expression; It allows processing queries Continue Reading »
31.Say True or False. If False, explain why. A trigger can execute the COMMIT, ROLLBACK, or SAVEPOINT commands. A trigger cannot execute the COMMIT, ROLLBACK, or SAVEPOINT commands. (174)
21.Say True or False. If False, explain why. PL/SQL supports the CREATE command. False. PL/SQL doesn’t support the data definition commands like CREATE. (172)
11.Which of the following operator has the lowest precedence among the following − **, OR, NULL ? OR (180)