Upload Button Icon Add office photos

Filter interviews by

Sears Holdings Plsql Developer Interview Questions and Answers

Updated 5 Jul 2017

Sears Holdings Plsql Developer Interview Experiences

1 interview found

I was interviewed in May 2017.

Interview Questionnaire 

5 Questions

  • Q1. Over all Oracle DB related Ex (Architectural to PL/SQL)
  • Q2. 1) What is Instance, how to recover instance . 2) Oracle logical/physical file system and processors . 3) SQL / PL/SQL Queries . 4) Unix Commands . 5) ITIL related questions . Ex- What is SLA, how many typ...
  • Ans. 

    The interview questions cover topics such as Oracle instance recovery, file systems, SQL/PL/SQL queries, Unix commands, and ITIL concepts.

    • An instance in Oracle refers to the memory structures and background processes that manage a database.

    • Instance recovery is the process of bringing a database instance back to a consistent state after a failure.

    • Oracle has both logical and physical file systems. The logical file system...

  • Answered by AI
  • Q3. Your Last project and work related qsns for experience guy.
  • Q4. Salary related .
  • Q5. About your last project issues and challenges .

Interview Preparation Tips

Round: Technical Interview
Experience: The interviewer are very friendly .
Tips: Be Confident with your skill and experience .

Round: Technical Interview
Experience: Interviewer asked about all work-related issues .
Tips: Briefly Explain about your last project roles and responsibilities .

Round: Behavioural Interview
Experience: Managerial Round.
Tips: Try to give a good approach for the issues .

Skills: Technical Skills, communication

Skills evaluated in this interview

Interview questions from similar companies

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

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

Round 1 - Coding Test 

Question related to java , springboot , hibernate, one dsa question based on two pointer

Interview Preparation Tips

Interview preparation tips for other job seekers - If it's tech specific like - java developer -> be prepare for questions related to java and spring boot
Interview experience
2
Poor
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via campus placement at National Institute of Technology,(NIT), Meghalaya and was interviewed in Oct 2023. There were 2 interview rounds.

Round 1 - Coding Test 

Aptitude and coding test was there

Round 2 - HR 

(1 Question)

  • Q1. Return the maximum element of an array
  • Ans. 

    Return the maximum element of an array

    • Iterate through the array and keep track of the maximum element found so far

    • Compare each element with the current maximum and update if a larger element is found

    • Return the maximum element after iterating through the entire array

  • Answered by AI

Skills evaluated in this interview

Round 1 - Technical 

(1 Question)

  • Q1. Unique elements in an array using es6
  • Ans. 

    Using Set and spread operator to get unique elements in an array.

    • Create a Set from the array using Set constructor

    • Use spread operator to convert Set back to array

    • Alternatively, use Array.from() method to convert Set to array

  • Answered by AI
Round 2 - Coding Test 

Coding question of react application.

Round 3 - One-on-one 

(1 Question)

  • Q1. Project related discussion.

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare well JS concepts & React Js coding.

Skills evaluated in this interview

Sears Holdings Interview FAQs

What are the top questions asked in Sears Holdings Plsql Developer interview?

Some of the top questions asked at the Sears Holdings Plsql Developer interview -

  1. 1) What is Instance, how to recover instance . 2) Oracle logical/physical file ...read more
  2. Over all Oracle DB related Ex (Architectural to PL/S...read more

Tell us how to improve this page.

Interview Questions from Similar Companies

Reliance Retail Interview Questions
3.9
 • 1.5k Interviews
ITC Interview Questions
3.9
 • 540 Interviews
Walmart Interview Questions
3.8
 • 405 Interviews
Tata Group Interview Questions
4.2
 • 357 Interviews
Adani Group Interview Questions
3.9
 • 177 Interviews
Landmark Group Interview Questions
4.0
 • 142 Interviews
Lowe's Interview Questions
4.2
 • 128 Interviews
View all
Senior Technical Associate
174 salaries
unlock blur

₹7 L/yr - ₹25.1 L/yr

Technical Associate
137 salaries
unlock blur

₹3.2 L/yr - ₹14 L/yr

Technical Lead
86 salaries
unlock blur

₹11.4 L/yr - ₹33 L/yr

Advisor
46 salaries
unlock blur

₹2.2 L/yr - ₹5.8 L/yr

Senior Advisor
38 salaries
unlock blur

₹2.3 L/yr - ₹7.9 L/yr

Explore more salaries
Compare Sears Holdings with

Future Group

4.3
Compare

Reliance Industries

4.0
Compare

Tata Group

4.2
Compare

Aditya Birla Group

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