Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by OptiSol Business Solutions Team. If you also belong to the team, you can get access from here

OptiSol Business Solutions Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Clear (1)

OptiSol Business Solutions Plsql Developer Interview Questions and Answers

Updated 3 Sep 2024

OptiSol Business Solutions Plsql Developer Interview Experiences

2 interviews found

Plsql Developer Interview Questions & Answers

user image Saranya shankar

posted on 3 Sep 2024

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Walk-in and was interviewed in Aug 2024. There were 4 interview rounds.

Round 1 - Group Discussion 

Round 1 group discussion

Round 2 - Aptitude Test 

Round 2 aptitude test

Round 3 - Coding Test 

Pls SQL basing theory questions and 2 programs factorial and exceptional handling

Round 4 - Technical 

(1 Question)

  • Q1. Basic technical questions expecting little higher
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I was interviewed in Dec 2022.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all Resume tips
Round 2 - HR 

(2 Questions)

  • Q1. Tell me abt urself ,previous
  • Q2. Previous office project

Interview Preparation Tips

Interview preparation tips for other job seekers - reports,plsql,sql ,hdkuwu kaskdo bjswjk kjnwkd hdi ok/o;mdw h hdq /okljd hjkwh lkjw.lkdj

Plsql Developer Interview Questions Asked at Other Companies

asked in TCS
Q1. What is procedure in plsql and it's syntax and difference between ... read more
asked in TCS
Q2. What is temp table and temp variable in plsql?
asked in TCS
Q3. A plsql programme to print 103,99,96...3?
asked in TCS
Q4. What is mutating table or mutating trigger?
asked in TCS
Q5. How do you find if two table having similer data

Interview questions from similar companies

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(2 Questions)

  • Q1. CREATE A FUNCTION BASED ONLOGIC SHARED
  • Ans. 

    Create a function based on shared logic

    • Identify common logic that can be reused in multiple functions

    • Create a separate function to encapsulate the shared logic

    • Call the shared function from other functions where the logic is needed

  • Answered by AI
  • Q2. FOR AN ENTITY GIVE DTAILS OF PREVOUS AND NEXT DATE FOR PARTICULAR DEPATMENT
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Naukri.com and was interviewed in Oct 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. EXPLAIN ABOUT UR PRJECT
  • Ans. 

    Developed a PL/SQL project for managing inventory and sales data in a retail store.

    • Designed database tables to store product information, sales transactions, and customer details.

    • Implemented PL/SQL procedures and functions for adding, updating, and querying data.

    • Created triggers to enforce business rules and maintain data integrity.

    • Developed reports using PL/SQL queries to analyze sales performance and inventory levels

  • Answered by AI
  • Q2. How do you work on performance optimization
  • Ans. 

    I work on performance optimization by analyzing query execution plans, indexing, and code refactoring.

    • Analyzing query execution plans to identify bottlenecks

    • Creating appropriate indexes to improve query performance

    • Refactoring code to optimize resource usage

    • Using tools like Explain Plan and SQL Tuning Advisor

  • Answered by AI

Interview Questionnaire 

2 Questions

  • Q1. They have only one phone interview
  • Q2. They asking about full sql and plsql

Interview Preparation Tips

Round: Resume Shortlist
Experience: Detailed description of explaination full topics

Round 1 - Technical 

(3 Questions)

  • Q1. SQL queries, joins, views, functions , advanced functions, exceptions.. Lot of Scenario based question
  • Q2. About resume and past experiences
  • Q3. Interview happened almost 1hr
Round 2 - HR 

(1 Question)

  • Q1. After 30 days.. Do u have any other offer in hand? How much they offered

Interview Preparation Tips

Interview preparation tips for other job seekers - After 30 days after n number of follow up mail
Hr discussion happened. Which was surprising one. The package they offfered is very less for an experienced candidate .. It doesn't even have 20%hike from current salary.
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Company Website and was interviewed in Sep 2024. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. What is packages and types
  • Ans. 

    Packages and types are two important components in PL/SQL used for organizing and defining reusable code and data structures.

    • Packages are containers for related procedures, functions, variables, and other PL/SQL constructs.

    • Types are user-defined data structures that can be used to define new data types in PL/SQL.

    • Packages can contain types as well as other PL/SQL constructs, providing a way to organize and encapsulate r...

  • Answered by AI

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
No response

I applied via Naukri.com and was interviewed in Dec 2023. There were 2 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. It was good but not selected
  • Q2. How to delete duplicate records
  • Ans. 

    To delete duplicate records in PL/SQL, use a combination of SELECT DISTINCT and DELETE statements.

    • Identify duplicate records using SELECT DISTINCT with a COUNT(*) function.

    • Use a DELETE statement with a subquery to remove duplicate records.

    • Consider creating a temporary table to store unique records before deleting duplicates.

  • Answered by AI
Round 2 - Technical 

(1 Question)

  • Q1. What is collation
  • Ans. 

    Collation is the set of rules determining how data is sorted and compared in a database.

    • Collation defines the order in which characters are sorted and compared in a database

    • It includes rules for comparing characters with diacritics, case sensitivity, and special characters

    • Different collations can affect sorting order and comparison results

  • Answered by AI

Skills evaluated in this interview

I applied via Naukri.com and was interviewed in Feb 2022. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all Resume tips
Round 2 - Technical 

(8 Questions)

  • Q1. What is temp table and temp variable in plsql?
  • Ans. 

    Temp table is a table created temporarily in memory. Temp variable is a variable that holds temporary data.

    • Temp table is used to store data temporarily during a session

    • Temp variable is used to hold temporary data that is not needed after a certain point

    • Temp table and variable are created using the 'CREATE GLOBAL TEMPORARY' and 'DECLARE' statements respectively

    • Example: CREATE GLOBAL TEMPORARY TABLE temp_table (id NUMBER...

  • Answered by AI
  • Q2. What is mutating table or mutating trigger?
  • Ans. 

    A mutating table or mutating trigger occurs when a trigger tries to update a table that is currently being modified.

    • Mutating table occurs when a trigger references the table that is being modified.

    • It can happen when a trigger is fired by an INSERT, UPDATE, or DELETE statement on the table.

    • This can lead to unpredictable results or errors, such as ORA-04091: table is mutating, trigger/function may not see it.

    • To avoid mut...

  • Answered by AI
  • Q3. What is autonomous transaction?
  • Ans. 

    Autonomous transaction is a separate transaction initiated by a parent transaction.

    • It allows a subtransaction to commit or rollback independently of the parent transaction.

    • It is useful for logging or auditing purposes.

    • It can be created using the PRAGMA AUTONOMOUS_TRANSACTION statement.

    • Example: A parent transaction updates a table, while an autonomous transaction logs the changes made.

    • Example: An autonomous transaction ...

  • Answered by AI
  • Q4. Cursors definition and types explained
  • Ans. 

    Cursors are used to retrieve and manipulate data from a database in PL/SQL.

    • Cursors are like pointers to a result set, allowing us to fetch and process rows one by one.

    • There are two types of cursors: implicit and explicit.

    • Implicit cursors are automatically created by Oracle when executing a SQL statement.

    • Explicit cursors are declared and used by the programmer.

    • Explicit cursors provide more control and flexibility compar...

  • Answered by AI
  • Q5. Explain about Triggers ?
  • Ans. 

    Triggers are database objects that automatically execute in response to certain events.

    • Triggers can be used to enforce business rules, audit data changes, and maintain referential integrity.

    • They can be defined to execute before or after an event, such as a row being inserted, updated, or deleted.

    • Triggers can also be nested, meaning one trigger can execute another trigger.

    • Examples of triggers include automatically updat...

  • Answered by AI
  • Q6. Truncate vs delete difference?
  • Ans. 

    Truncate removes all data, delete removes selected data.

    • Truncate is faster than delete as it doesn't log individual row deletions.

    • Truncate cannot be rolled back, delete can be.

    • Truncate resets identity columns, delete doesn't.

    • Truncate doesn't fire triggers, delete does.

    • Truncate is a DDL operation, delete is a DML operation.

  • Answered by AI
  • Q7. A plsql programme to print 103,99,96...3?
  • Q8. What is procedure in plsql and it's syntax and difference between procedure and function?
  • Ans. 

    A procedure in PL/SQL is a named block of code that can be called and executed multiple times.

    • Syntax: CREATE [OR REPLACE] PROCEDURE procedure_name [(parameter1 [mode1] datatype1 [, parameter2 [mode2] datatype2]...)] IS

    • Difference between procedure and function: Procedures do not return a value, while functions return a value.

    • Procedures are used to perform an action, while functions are used to calculate and return a val...

  • Answered by AI
Round 3 - HR 

(5 Questions)

  • Q1. What are your salary expectations?
  • Q2. Share details of your previous job.
  • Q3. Tell me about yourself.
  • Q4. How do you find if two table having similer data
  • Ans. 

    To find if two tables have similar data, compare the records in both tables using a join or a subquery.

    • Use a join operation to compare the records in both tables based on a common column.

    • If the tables have a primary key, you can join them on that key to check for similar data.

    • Alternatively, you can use a subquery to compare the data in both tables and check for matching records.

    • Consider using the MINUS operator to find...

  • Answered by AI
  • Q5. Difference between having and group by?
  • Ans. 

    HAVING is used to filter groups while GROUP BY is used to group rows based on a column.

    • HAVING is used with GROUP BY to filter groups based on a condition

    • GROUP BY is used to group rows based on a column

    • HAVING is used after GROUP BY in a query

    • GROUP BY is used before HAVING in a query

    • Example: SELECT department, AVG(salary) FROM employees GROUP BY department HAVING AVG(salary) > 5000;

  • Answered by AI

Interview Preparation Tips

Topics to prepare for TCS Plsql Developer interview:
  • Crack concepts ,
Interview preparation tips for other job seekers - Learn everything explain it in your way interviewers may confuse with some questions be aware

Skills evaluated in this interview

Interview experience
3
Average
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
No response

I applied via Approached by Company and was interviewed in Feb 2024. There was 1 interview round.

Round 1 - Technical 

(4 Questions)

  • Q1. Sql loader questions - Give command
  • Q2. Difference in procedure and function
  • Ans. 

    Procedure is used to perform an action, while function returns a value.

    • Procedure does not return a value, while function does

    • Functions can be used in SQL queries, procedures cannot

    • Functions can be called from SQL statements, procedures cannot

  • Answered by AI
  • Q3. What is init in performance tuning?
  • Ans. 

    In performance tuning, init refers to the initialization parameter file used by Oracle Database to configure various settings.

    • init is a text-based configuration file that contains parameters to optimize the performance of Oracle Database.

    • It is used to set parameters such as memory allocation, parallel processing, and resource utilization.

    • By tuning the init file, developers can improve the overall performance of the dat...

  • Answered by AI
  • Q4. Exception handling - Named and unnamed. Give exceptions names.
  • Ans. 

    Named and unnamed exceptions in PL/SQL with examples

    • Named exceptions are user-defined exceptions with specific names like 'custom_exception'

    • Unnamed exceptions are predefined exceptions like 'NO_DATA_FOUND' or 'TOO_MANY_ROWS'

    • Named exceptions can be raised using RAISE statement with the exception name

    • Unnamed exceptions are raised automatically by the system in case of errors

    • Example of named exception: DECLARE custom_exce...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Just know the basics. But Infosys keeps people waiting in queue for months before giving out the results.
Contribute & help others!
anonymous
You can choose to be anonymous

OptiSol Business Solutions Interview FAQs

How many rounds are there in OptiSol Business Solutions Plsql Developer interview?
OptiSol Business Solutions interview process usually has 3 rounds. The most common rounds in the OptiSol Business Solutions interview process are Group Discussion, Aptitude Test and Coding Test.
How to prepare for OptiSol Business Solutions Plsql Developer interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at OptiSol Business Solutions. The most common topics and skills that interviewers at OptiSol Business Solutions expect are Oracle Forms, Oracle Reports, PLSQL, Oracle 10G and Performance Tuning.

Recently Viewed

PHOTOS

InsuranceDekho

3 office photos

LIST OF COMPANIES

Credit Bajaar

Overview

INTERVIEWS

Godrej Industries Group

No Interviews

INTERVIEWS

Godrej Industries Group

No Interviews

INTERVIEWS

Godrej Industries Group

No Interviews

INTERVIEWS

Godrej Industries Group

No Interviews

INTERVIEWS

Godrej Industries Group

No Interviews

INTERVIEWS

OptiSol Business Solutions

No Interviews

INTERVIEWS

Godrej Industries Group

No Interviews

INTERVIEWS

Godrej Industries Group

No Interviews

Tell us how to improve this page.

OptiSol Business Solutions Plsql Developer Interview Process

based on 2 interviews

Interview experience

4
  
Good
View more
OptiSol Business Solutions Plsql Developer Salary
based on 4 salaries
₹3.3 L/yr - ₹5.5 L/yr
33% less than the average Plsql Developer Salary in India
View more details

OptiSol Business Solutions Plsql Developer Reviews and Ratings

based on 1 review

5.0/5

Rating in categories

5.0

Skill development

5.0

Work-life balance

5.0

Salary

5.0

Job security

5.0

Company culture

5.0

Promotions

5.0

Work satisfaction

Explore 1 Review and Rating
Software Engineer
111 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Software Developer
31 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Machine Learning Engineer
27 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Test Engineer
24 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Software Engineer
23 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare OptiSol Business Solutions with

TCS

3.7
Compare

Infosys

3.6
Compare

Wipro

3.7
Compare

HCLTech

3.5
Compare
Did you find this page helpful?
Yes No
write
Share an Interview