LEARNING ORACLE BECOMES EASY
Apps Technical Interview Questions Part 5
Apps Technical Interview Questions Part 4
Apps Technical Interview Questions Part 3
Apps Technical Interview Questions Part 2
Apps Technical Interview Questions Part 1
PL/Sql Interview Questions Part 4
1. What will you get by the cursor attribute SQL%FOUND? It returns the Boolean value TRUE if at least one row was processed. 2. What will you get by …
Read More »PL/Sql Interview Questions Part 3
1. What are some predefined exceptions in PL/SQL? A list of predefined exceptions in PL/SQL: DUP_VAL_ON_INDEX ZERO_DIVIDE NO_DATA_FOUND TOO_MANY_ROWS CURSOR_ALREADY_OPEN INVALID_NUMBER INVALID_CURSOR PROGRAM_ERROR TIMEOUT _ON_RESOURCE STORAGE_ERROR LOGON_DENIED VALUE_ERROR etc. 2. What …
Read More »PL/Sql Interview Questions Part 2
1. What is PL/SQL? PL/SQL stands for procedural language extension to SQL. It supports procedural features of programming language and SQL both. It was developed by Oracle Corporation in early of …
Read More »PL/Sql Interview Questions Part 1
1. What are Procedure, functions and Packages? Procedures and functions consist of set of PL/SQL statements that are grouped together as a unit to solve a specific problem or …
Read More »Real Application Cluster(RAC) Interview Questions Part 6
1.What is Partition Pruning ? Oracle optimizes SQL statements to mark the partitions or subpartitions that need to be accessed and eliminates (prunes) unnecessary partitions or subpartitions from access by …
Read More »