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 …
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. …
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.
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 …
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? …
11. What Happens when you execute a program? When you execute a program on your UNIX system, the system creates a special environment for that program. This environment contains everything …
1. Brief about the initial process sequence while the system boots up. While booting, special process called the ‘swapper’ or ‘scheduler’ is created with Process- ID 0. The swapper manages …
31. Name two paging states for a page in memory? The two paging states are: The page is aging and is not yet eligible for swapping, The page is eligible …
21. What is “the principle of locality”? It’s the nature of the processes that they refer only to the small subset of the total data space of the process. i.e. …
11. What is Fork swap? “fork()” is a system call to create a child process. When the parent process calls “fork()” system call, the child process is created and if …
