Oracle Solutions We believe in delivering tangible results for our customers in a cost-effective manner
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 4
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 »Database Interview Questions Part 4
1.Define read-only replication and its uses?
Read More »Database Interview Questions Part 3
1.What is a full backup and name some tools you use for full backup?
Read More »Database Interview Questions Part 2
1.Which Table spaces are created automatically when you create a database?
Read More »Database Interview Questions Part 1
1.What is BLOB datatype?
Read More »