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

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 - 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
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Coding Test 

Simple map question basically it was frequency based sorting

Round 2 - One-on-one 

(2 Questions)

  • Q1. Explain about oops
  • Ans. 

    Object-oriented programming paradigm where data and behavior are encapsulated within objects

    • Encapsulation: bundling data and methods that operate on the data within a single unit

    • Inheritance: ability for a class to inherit properties and behavior from another class

    • Polymorphism: ability for objects of different classes to respond to the same method call

  • Answered by AI
  • Q2. Tell me about the threads in Operating system
  • Ans. 

    Threads in operating system are lightweight processes that share the same memory space and resources.

    • Threads allow for concurrent execution within a single process

    • Threads share the same memory space, allowing for efficient communication and data sharing

    • Threads can be created and managed by the operating system or by the application itself

    • Examples of threading models include user-level threads and kernel-level threads

  • Answered by AI

Skills evaluated in this interview

Web Developer Interview Questions & Answers

Affine user image Manasa jagadeesh

posted on 9 Apr 2020

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

I applied via Naukri.com and was interviewed before Apr 2019. There were 4 interview rounds.

Interview Questionnaire 

3 Questions

  • Q1. Casual talk with the manager/director of the domain.
  • Q2. Basic questions about frontend technologies
  • Q3. Basic HR questions regarding salary

I applied via Company Website and was interviewed in Nov 2021. There were 2 interview rounds.

Round 1 - Coding Test 

2 JavaScript Programs , Aptitude, MCQs for JavaScript and React

Round 2 - Technical 

(1 Question)

  • Q1. Higher Order Functions, Code output questions related to data types, react theory questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Learn core principals of JavaScript and practice coding for JavaScript.
Go to leetcode and practice.

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 HR, Group Discussion and Aptitude 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.

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
114 salaries
unlock blur

₹2 L/yr - ₹11.1 L/yr

Software Developer
31 salaries
unlock blur

₹1 L/yr - ₹10.1 L/yr

Machine Learning Engineer
26 salaries
unlock blur

₹3.5 L/yr - ₹12 L/yr

Test Engineer
24 salaries
unlock blur

₹2.8 L/yr - ₹7 L/yr

Senior Software Engineer
23 salaries
unlock blur

₹4.1 L/yr - ₹10 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