Upload Button Icon Add office photos
Engaged Employer

i

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

Kishore Tech Solutions Overseas Verified Tick

Compare button icon Compare button icon Compare
5.0

based on 6 Reviews

Filter interviews by

Kishore Tech Solutions Overseas Plsql Developer Interview Questions and Answers

Updated 25 Aug 2023

Kishore Tech Solutions Overseas Plsql Developer Interview Experiences

1 interview found

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
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 tips
Round 2 - Coding Test 

Create a employee salary and find seconth highest salary

Round 3 - Technical 

(1 Question)

  • Q1. How to find query in SQL
  • Ans. 

    To find a query in SQL, you can use tools like SQL Developer, SQL Server Management Studio, or by querying system tables/views.

    • Use SQL Developer or SQL Server Management Studio to search for specific queries.

    • Query system tables/views like v$sql, v$sqlarea, v$session, v$open_cursor to find currently running queries.

    • Use SQL trace or SQL profiler to capture and analyze queries being executed.

    • Check database logs for execut...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Learn well and don't waste your time

Skills evaluated in this interview

Interview questions from similar companies

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Campus Placement and was interviewed in Jun 2024. There were 3 interview rounds.

Round 1 - Aptitude Test 

All apptitude and english communication

Round 2 - Group Discussion 

10 members per gd and 10 minutes provided

Round 3 - Technical 

(2 Questions)

  • Q1. Types of sql commands
  • Q2. Explain about projects

Interview Preparation Tips

Interview preparation tips for other job seekers - sql is must
Interview experience
1
Bad
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
No response

I applied via Job Portal and was interviewed in Mar 2024. There were 3 interview rounds.

Round 1 - Assignment 

They discuss the coding capabilities, and personal things discussion so company never face any loss.

Round 2 - Coding Test 

Coding related output based questions and answers.

Round 3 - Group Discussion 

They discuss codding based questions and too much personal things, they project manager will visite to our basic things like house, family, Current financial condition so on...

Interview Preparation Tips

Interview preparation tips for other job seekers - Don't be friendly with hr or project manager, keep discuss only technology relevant nor too much personal.
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed in Feb 2024. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. 1. what is react 2.create a tab strcture like when u click add css and open that tab
  • Ans. 

    React is a JavaScript library for building user interfaces.

    • React is a popular JavaScript library for building user interfaces.

    • To create a tab structure in React, you can use components like Tabs and TabPanels.

    • When a tab is clicked, you can use state to show or hide the content of that tab.

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - best company to join, very big learning curve

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

There was aptitude and coding question essy to medium

Round 2 - Coding Test 

There was some aptitude question and coding question easy to medium

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Coding Test 

Dsa predict the output

Round 2 - Coding Test 

One medium problem. Based on that the students are selected. And modifications in code has been asked

Round 3 - HR 

(1 Question)

  • Q1. Coding related questions
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Campus Placement and was interviewed in Feb 2023. There were 4 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 tips
Round 2 - Coding Test 

No of Questions : 4 questions
Difficulty : Difficult
Topics : Sieve of eratosthenis, DP, Hashing

Round 3 - Technical 

(3 Questions)

  • Q1. Search in the rotated Sorted array. (Binary Search - pivot)
  • Ans. 

    Search for an element in a rotated sorted array using binary search with pivot.

    • Find the pivot element using binary search.

    • Compare the target element with the first element of the array to determine which half to search.

    • Perform binary search on the selected half of the array.

    • Repeat until the target element is found or the array is exhausted.

  • Answered by AI
  • Q2. Sort the array which consists of 0's, 1's , 2's. (Two Pointer approach)
  • Ans. 

    Sort an array of 0's, 1's, and 2's using two pointer approach.

    • Initialize two pointers, one at the beginning and one at the end of the array.

    • Traverse the array and swap 0's to the beginning and 2's to the end using the pointers.

    • Stop when the pointers meet or cross each other.

  • Answered by AI
  • Q3. Tell me about id selector in CSS
  • Ans. 

    ID selector is used to select an element with a specific ID attribute in CSS.

    • ID selector is denoted by '#' followed by the ID name.

    • ID should be unique on a page.

    • ID selector has higher specificity than class selector.

    • Example: #header { color: blue; }

  • Answered by AI
Round 4 - Technical 

(5 Questions)

  • Q1. Differences between ShallowCopy & DeepCopy
  • Ans. 

    ShallowCopy copies only the reference of an object while DeepCopy creates a new object with a new reference.

    • ShallowCopy creates a new reference to the same object, so changes made to the copy will reflect in the original object.

    • DeepCopy creates a new object with a new reference, so changes made to the copy will not reflect in the original object.

    • ShallowCopy is faster and less memory-intensive than DeepCopy.

    • DeepCopy is ...

  • Answered by AI
  • Q2. Define Copy Constructor
  • Ans. 

    Copy constructor is a special constructor that creates a new object by copying an existing object.

    • It is used to create a new object with the same values as an existing object.

    • It takes an object of the same class as a parameter.

    • It is automatically called when a new object is created from an existing object.

    • It creates a deep copy of the object, meaning that all the member variables are copied.

    • Example: class MyClass { pub...

  • Answered by AI
  • Q3. Define Operator overloading
  • Ans. 

    Operator overloading allows operators to have different meanings based on the context of their usage.

    • Operator overloading is a feature in object-oriented programming languages.

    • It allows operators to be redefined for custom classes.

    • For example, the '+' operator can be overloaded to concatenate strings or add numbers.

    • It can improve code readability and reduce the amount of code needed for certain operations.

  • Answered by AI
  • Q4. Differences between struct and class
  • Ans. 

    Struct is a value type while class is a reference type in C#.

    • Structs are stored on the stack while classes are stored on the heap.

    • Structs cannot be inherited while classes can be inherited.

    • Structs do not support destructors while classes do.

    • Structs are used for small data structures while classes are used for larger, more complex objects.

    • Example of struct: struct Point { public int X; public int Y; }

    • Example of class: c...

  • Answered by AI
  • Q5. DSA : Search an element in infinite soted array
  • Ans. 

    Search an element in an infinite sorted array using binary search.

    • Initialize low as 0 and high as 1.

    • Double the high index until arr[high] is greater than the target element.

    • Perform binary search between low and high indexes.

  • Answered by AI

Interview Preparation Tips

Topics to prepare for Moveinsync Technology Solutions Backend Developer interview:
  • OS
  • DBMS
  • OOPS
  • Binary Search
  • DP
Interview preparation tips for other job seekers - Dont neglect Core CS Fundamentals . Even you are so good in Dev or DSA. You'll be asked questions based on CS Fundamentals like OS, DBMS, OOP etc
Dont get tensed if something doesn't goes well in middle of interview. Interviewers are friendly and will help us in middle.

Skills evaluated in this interview

Interview experience
1
Bad
Difficulty level
Hard
Process Duration
Less than 2 weeks
Result
Selected Selected

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

Round 1 - Aptitude Test 

Test on paper , cbt

Round 2 - Technical 

(1 Question)

  • Q1. Oops C# .net sql html

Interview Preparation Tips

Interview preparation tips for other job seekers - Good place to laern
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Company Website and was interviewed before Apr 2023. There were 2 interview rounds.

Round 1 - Assignment 

Create a small appilcation and send the code via email

Round 2 - Technical 

(1 Question)

  • Q1. Questions related to javascript

Interview Preparation Tips

Interview preparation tips for other job seekers - To be good with all basics
Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
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 tips
Round 2 - Coding Test 

Easy to Medium Data Structures Question they will ask

Round 3 - Technical 

(2 Questions)

  • Q1. Basic DSA questions and basic core topics
  • Q2. Java easy to medium difficulty questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Have your fundamentals clear, and do the questions from leetcode

Kishore Tech Solutions Overseas Interview FAQs

How many rounds are there in Kishore Tech Solutions Overseas Plsql Developer interview?
Kishore Tech Solutions Overseas interview process usually has 3 rounds. The most common rounds in the Kishore Tech Solutions Overseas interview process are Resume Shortlist, Coding Test and Technical.

Tell us how to improve this page.

Kishore Tech Solutions Overseas 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
Compare Kishore Tech Solutions Overseas with

Yalamanchili Software Exports

3.4
Compare

ScoreMe Solutions

4.4
Compare

Global Edge Software

3.5
Compare

Logelite

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