Salesforce.com Learn & Share
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 several situations to use autonomous transactions like event logging and…
Read More31. 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. By using the keyword “old.column name”, they can reference column…
Read More21. 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)
Read More11. 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 3) If a value in an expression is NULL, then…
Read More1.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? PL/SQL uses block structure as its basic structure. Anonymous blocks…
Read More1.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. (188)
Read More41.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 that return multiple rows. (174)
Read More31.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)
Read More21.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)
Read More11.Which of the following operator has the lowest precedence among the following − **, OR, NULL ? OR (180)
Read More