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 …
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.
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.
11.Which of the following operator has the lowest precedence among the following − **, OR, NULL ? OR
1.What is the purpose of the PL/SQL language? PL/SQL is an extension of SQL. SQL is non-procedural. PL/SQL is a procedural language designed by oracle to overcome the limitations that …
