Upload Button Icon Add office photos

Filter interviews by

Blueware Technologies And Services Plsql Developer Interview Questions and Answers

Updated 28 Dec 2020

Blueware Technologies And Services Plsql Developer Interview Experiences

1 interview found

Interview Questionnaire 

1 Question

  • Q1. Defference between char and varchar2
  • Ans. 

    Char is fixed length while Varchar2 is variable length.

    • Char takes up the same amount of space regardless of the data it contains.

    • Varchar2 only takes up as much space as the data it contains.

    • Char is useful for storing data that is always the same length, like a phone number.

    • Varchar2 is useful for storing data that can vary in length, like a name or address.

  • Answered by AI

Skills evaluated in this interview

Top trending discussions

View All
Interview Tips & Stories
2w
toobluntforu
·
works at
Cvent
Can speak English, can’t deliver in interviews
I feel like I can't speak fluently during interviews. I do know english well and use it daily to communicate, but the moment I'm in an interview, I just get stuck. since it's not my first language, I struggle to express what I actually feel. I know the answer in my head, but I just can’t deliver it properly at that moment. Please guide me
Got a question about Blueware Technologies And Services?
Ask anonymously on communities.

Interview questions from similar companies

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. SQL based questions
  • Q2. PLSQL based questions

Plsql Developer Interview Questions Asked at Other Companies

asked in TCS
Q1. What is temp table and temp variable in plsql?
asked in TCS
Q2. What is procedure in plsql and it's syntax and difference between ... read more
asked in TCS
Q3. Write a PL/SQL program to print the sequence 103, 99, 96...3.
asked in TCS
Q4. What is a mutating table or mutating trigger?
asked in Cognizant
Q5. Write a SQL query to delete duplicate records from a table.
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
No response

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

Round 1 - Technical 

(1 Question)

  • Q1. Questioned about each and every objects in database. procedures, functions with examples write Fibonacci series using plsql block joins, subqueries written a sql query to fetch weekdays

I applied via Company Website and was interviewed before Oct 2019. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. 1. Core Java - OOPS features, Abstract classes and Interface, Inner Classes, String and Object Class, Equals and HashCode methods, Runtime and Compile time exception, Method overloading and overriding, Cus...

Interview Preparation Tips

Interview preparation tips for other job seekers - 1. Clear Core java concepts firmly
2. Basic DB queries
3. Basic Unix commands

I applied via Naukri.com and was interviewed in Mar 2020. There were 4 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. What is web service flow
  • Ans. 

    Web service flow is the sequence of steps involved in the communication between a client and a server over the internet.

    • Web service flow involves a client sending a request to a server

    • The server processes the request and sends a response back to the client

    • The response can be in various formats such as XML, JSON, or plain text

    • Web service flow can be synchronous or asynchronous

    • Examples of web services include RESTful API...

  • Answered by AI
  • Q2. How to check ports in Solaris or linux machine
  • Ans. 

    To check ports in Solaris or Linux machine, use the netstat command.

    • Open the terminal and type 'netstat -an' to display all open ports.

    • Use 'netstat -an | grep ' to check if a specific port is open.

    • To check listening ports, use 'netstat -an | grep LISTEN'.

    • For Solaris, use 'netstat -an | grep .' instead of '| grep '.

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Total pathetic experience. What job description is given to you, doesn't matters because you won't be asked for that. Your resume will get shortlisted and then it doesn't matter what u have covered up in your career path, because interview rounds will consist of questions out of your scope. Your resume doesn't needs to be shortlisted at first end if it doesn't suit thier needs. HR people, they are on another level. You share your resume to them, and they will never ever reply back to you. Not a single HR, but it seems everyone has same culture. You keep trying to connect them for support. But they will just keep finding smarter ways to avoid.

Skills evaluated in this interview

I applied via Campus Placement and was interviewed before Nov 2021. 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 tips
Round 2 - Aptitude Test 

Numerical and logical aptitude test

Round 3 - Coding Test 

There are 5 rounds on datastructure and algorithm

Interview Preparation Tips

Interview preparation tips for other job seekers - Nice hr and all team is suportive
Good and smoth interview experiance

Interview Preparation Tips

Round: Test
Experience: Approx. 30.questions in 50 min
Tips: Try solving each que in less than a minute ,don't waste time on difficult questions, complete easier once first
Duration: 50 minutes
Total Questions: 30

College Name: Pimpri chinchwad college of engineering
Are these interview questions helpful?

Interview Preparation Tips

General Tips: I asked my seniors about the interview process. Their guidelines were very helpful. Always try to bring the interviewer into your comfort zone. Also be confident and expressive while explaining. Explain your thought process while solving. Even though you don't get the solution the thought process might be very important for your selection.
College Name: NIT SURATHKAL

Interview Preparation Tips

Round: Test
Experience: Oracle had an online test which includes 3
Sections:
1. Programming: basic C++/java programming + data structure. One need to have good hand over oops
to score well in this section.

2. Aptitude: General Aptitude Questions

3. General Maths: Very simple maths problem (+2 level) but needs very very good speed.
Tips: Individual cutoff was not declared, but different cutoff for different profile is expected.
Oracle has no GD round.

Round: Interview
Experience: In 2nd round of interview, there was more programming, less resume based question and more emphasis on will I be comfortable in an IT sector. Some apti questions were also asked.

Round: Interview
Experience: 1st round was completely on resume based. Each and every project and intern is discussed in detail. Most of the extracurricular activities were also discussed. In the 1st interview, some basic program like fibonacci series by recursion, star pattern by loop etc were asked.

Round: Interview
Experience: Next round was HR. I was asked about the earlier 2 interviews and some basic HR questions.

College Name: IIT Roorkee

Interview Preparation Tips

Round: Test
Experience: The sections were Quantitative, Logical, Verbal and Computer Science.The three sections contained very basic questions of general aptitude while the Computer Science section contained questions on Database Management, OS, SQL and Programming Aptitude.

Round: Test
Experience: The question was to program a logic to test the correctness of a solved sudoku. We were allowed to code in C++, Java, C or pseudo code.

Round: Technical Interview
Experience: Were asked simple questions and program them like reversing string without temporary variables, finding the earlier date when entered as string and finding the difference in number of days between them.
I was asked to explain him my internship project in great detail and above all one should be prepared to answer the question 'Why IT?' if from a non IT background. Then I was asked to program a logic for 'Search and replace" tool of MS Word.

Round: HR Interview
Experience: Was asked about my background in detail and stressed again and again on 'Why IT?'. Then he asked me to prepare a summary on the merits and demerits of various Employee Data Management techniques for an organisation. For the end of the interview you should have a question which you would ask to the interviewer.

General Tips: Don't try to over emphasize the correctness of your logic if the interviewer finds a glitch. It irritates him. Be interactive in your HR round. In our case it was the VP of Oracle India who took the final round. So I asked him about his experience in the company. He was very happy to share it with me. But asses your interviewer before you put forth these queries cause your interviewer might not be as jolly as mine was.
Skills:
College Name: NIT Surathkal

Tell us how to improve this page.

Interview Questions from Similar Companies

Google Interview Questions
4.4
 • 897 Interviews
Oracle Interview Questions
3.7
 • 895 Interviews
Zoho Interview Questions
4.2
 • 539 Interviews
Amdocs Interview Questions
3.7
 • 533 Interviews
KPIT Technologies Interview Questions
3.3
 • 306 Interviews
SAP Interview Questions
4.2
 • 291 Interviews
Adobe Interview Questions
3.9
 • 247 Interviews
View all
Blueware Technologies And Services Plsql Developer Salary
based on 4 salaries
₹2.1 L/yr - ₹5.2 L/yr
39% less than the average Plsql Developer Salary in India
View more details
Software Engineer
54 salaries
unlock blur

₹2.4 L/yr - ₹7.2 L/yr

Software Developer
27 salaries
unlock blur

₹2 L/yr - ₹6.8 L/yr

Softwaretest Engineer
24 salaries
unlock blur

₹2 L/yr - ₹6.3 L/yr

Software Testing Engineer
21 salaries
unlock blur

₹2.8 L/yr - ₹4.2 L/yr

Devops Engineer
16 salaries
unlock blur

₹3 L/yr - ₹7.5 L/yr

Explore more salaries
Compare Blueware Technologies And Services with

Oracle

3.7
Compare

Amdocs

3.7
Compare

Carelon Global Solutions

3.8
Compare

Automatic Data Processing (ADP)

4.0
Compare
write
Share an Interview