Upload Button Icon Add office photos

Sears Holdings

Compare button icon Compare button icon Compare

Filter interviews by

Clear (1)

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
Hard
Process Duration
Less than 2 weeks
Result
Not Selected

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

Round 1 - Technical 

(2 Questions)

  • Q1. What is the difference between varchar and varchar2?
  • Ans. 

    VARCHAR can store up to 2000 bytes while VARCHAR2 can store up to 4000 bytes.

    • VARCHAR can store variable-length character strings up to 2000 bytes.

    • VARCHAR2 can store variable-length character strings up to 4000 bytes.

    • VARCHAR will occupy space for NULL values while VARCHAR2 will not.

    • VARCHAR2 is more efficient in terms of storage and performance compared to VARCHAR.

  • Answered by AI
  • Q2. Explain composite indexes
  • Ans. 

    Composite indexes are indexes that are created on multiple columns in a database table.

    • Composite indexes improve query performance for queries that involve multiple columns

    • They can be created using the CREATE INDEX statement in SQL

    • Example: CREATE INDEX idx_name ON table_name (column1, column2)

  • Answered by AI

Interview Questionnaire 

2 Questions

  • Q1. OOPS Concepts
  • Q2. Threads Concepts

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepared on basic java
Interview experience
3
Average
Difficulty level
Easy
Process Duration
2-4 weeks
Result
Not Selected

I applied via LinkedIn and was interviewed in Aug 2023. There were 2 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 

(2 Questions)

  • Q1. Basic Oops Concepts
  • Q2. 4 Pillars of oops
  • Ans. 

    Encapsulation, Inheritance, Polymorphism, Abstraction are the 4 pillars of OOPs

    • Encapsulation: Bundling data and methods that operate on the data into a single unit

    • Inheritance: Ability of a class to inherit properties and behavior from another class

    • Polymorphism: Ability to present the same interface for different data types

    • Abstraction: Hiding the complex implementation details and showing only the necessary features

  • Answered by AI
Interview experience
4
Good
Difficulty level
Hard
Process Duration
Less than 2 weeks
Result
Not Selected

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

Round 1 - Box test 

(2 Questions)

  • Q1. Tell me about yourself
  • Q2. What is the difference between HTTp and HTTPS
  • Ans. 

    HTTP is unsecured protocol while HTTPS is secured protocol using SSL/TLS encryption.

    • HTTP stands for Hypertext Transfer Protocol, while HTTPS stands for Hypertext Transfer Protocol Secure.

    • HTTPS uses SSL/TLS encryption to secure the communication between the client and server, while HTTP does not.

    • HTTPS uses port 443 by default, while HTTP uses port 80.

    • HTTPS URLs begin with 'https://' and are secured with a padlock icon i...

  • Answered by AI

Skills evaluated in this interview

I was interviewed in May 2021.

Round 1 - Coding Test 

(1 Question)

Round duration - 120 Minutes
Round difficulty - Easy

  • Q1. 

    Check Word Presence in String

    Given a string S and a list wordList containing N distinct words, determine if each word in wordList is present in S. Return a boolean array where the value at index 'i' indi...

  • Ans. 

    Given a string and a list of words, determine if each word in the list is present in the string and return a boolean array indicating their presence.

    • Iterate through each word in the word list and check if it is present in the string.

    • Use a boolean array to store the presence of each word in the string.

    • Consider case sensitivity when checking for word presence.

    • Do not use built-in string-matching methods.

    • Return the boolean

  • Answered by AI
Round 2 - Video Call 

Round duration - 20 Minutes
Round difficulty - Easy

Interview Preparation Tips

Eligibility criteria6.75+ CGPATata interview preparation:Topics to prepare for the interview - Data Structures, OOPS, DBMS, OOPs, Algorithms, DP, GreedyTime required to prepare for the interview - 3 monthsInterview preparation tips for other job seekers

Tip 1 : Try solving Love Babbar 450 Prog questions
Tip 2 : Have a good resume
Tip 3 : Do learn some extra technologies eg. ML/AI

Application resume tips for other job seekers

Tip 1 : Do not lie at all
Tip 2 : Have some projects listed

Final outcome of the interviewSelected

Interview Questionnaire 

7 Questions

  • Q1. 1. Introduction, it's a common question?
  • Q2. Why you want to switch your job?
  • Q3. Is job your passion or it's your need?
  • Q4. How should you handled the critical situation?
  • Ans. 

    Handling critical situations requires quick thinking, clear communication, and a calm demeanor.

    • Assess the situation and prioritize actions

    • Communicate clearly and effectively with all parties involved

    • Remain calm and focused

    • Take decisive action while considering potential consequences

    • Seek assistance or advice from colleagues or superiors if necessary

  • Answered by AI
  • Q5. How you managed 2 problems in a same time?
  • Ans. 

    I prioritize the problems based on urgency and importance, and then allocate time and resources accordingly.

    • Assess the urgency and importance of each problem

    • Create a plan of action for each problem

    • Allocate time and resources based on the plan

    • Regularly reassess and adjust the plan as needed

    • Example: If one problem is a deadline that cannot be missed and the other is a minor issue, prioritize the deadline and allocate mor

  • Answered by AI
  • Q6. Describe your last vacation or last memorable day?
  • Q7. Talk on profession, topic, "for ex. why you choose french, why you do B.tech etc?

Interview Preparation Tips

Interview preparation tips for other job seekers - asked only 4 to 5 questions not too much. with in 5 question an interviewer know about the skill of that candidate.
Thanks
Regard Richa

I applied via Campus Placement and was interviewed in Apr 2022. There were 3 interview rounds.

Round 1 - Coding Test 

Ninja Coding Round Basic Coding questions available on youtube or sources online

Round 2 - Technical 

(1 Question)

  • Q1. Panel of 2 people will ask basic technical questions and it depends on what you have mentioned in your resume
Round 3 - HR 

(1 Question)

  • Q1. Basic HR questions about relocation etc.

Interview Preparation Tips

Interview preparation tips for other job seekers - Practise basic coding and math aptitude questions. To crack TCS

I applied via Naukri.com and was interviewed in Oct 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 - HR 

(4 Questions)

  • Q1. What is java? What is variable?
  • Ans. 

    Java is a popular programming language used for developing various applications. A variable is a named memory location used to store data.

    • Java is an object-oriented language

    • It is platform-independent

    • Variables in Java have a specific data type

    • Variables can be assigned values and their values can be changed

    • Example: int age = 25; String name = "John";

  • Answered by AI
  • Q2. What is inheritance? types of inheritance
  • Ans. 

    Inheritance is a concept in object-oriented programming where a class inherits properties and behaviors from another class.

    • Inheritance allows code reuse and promotes code organization.

    • There are different types of inheritance: single inheritance, multiple inheritance, multilevel inheritance, and hierarchical inheritance.

    • Single inheritance involves a class inheriting from a single base class.

    • Multiple inheritance involves...

  • Answered by AI
  • Q3. 1.Java is a high level language 2.java is a programme is called a set of instructions 3.java run time environment (jre) 4.java is a platform independent. Variable: A variable which is container that some d...
  • Q4. Inheritance; 1.Acquring the properties of parent class to the child class with out changeing the properties of parent class is known as inheritance 2.inheritanc is a is relationship 3.extends keyword is us...
  • Ans. 

    Inheritance is acquiring properties of parent class to child class without changing parent class properties. It is classified into 5 types.

    • Inheritance is a way to reuse code and establish a relationship between classes

    • The 'extends' keyword is used to implement inheritance in Java

    • Examples of inheritance include a 'Car' class inheriting properties from a 'Vehicle' class

    • Single level inheritance involves one parent class a...

  • Answered by AI
Round 3 - Group Discussion 

May I about you ? Which your qualification and which stream

Interview Preparation Tips

Topics to prepare for Tata Group Software Developer interview:
  • Core Java
  • Web Technologies
Interview preparation tips for other job seekers - My strength is quick learner, self motivated, Hard working
My weakness is if any body ask for help me,I never say know.

Skills evaluated in this interview

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

(1 Question)

  • Q1. Describe yourself
Contribute & help others!
anonymous
You can choose to be anonymous

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

Recently Viewed

INTERVIEWS

Nokia

No Interviews

LIST OF COMPANIES

Discover companies

Find best workplace

SALARIES

Sears Holdings

INTERVIEWS

Sears Holdings

No Interviews

INTERVIEWS

ITC

No Interviews

INTERVIEWS

Whitehat jr

No Interviews

INTERVIEWS

Namekart

No Interviews

INTERVIEWS

Sears Holdings

No Interviews

INTERVIEWS

Sears Holdings

5.6k top interview questions

INTERVIEWS

PwC

No Interviews

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
 • 545 Interviews
Walmart Interview Questions
3.8
 • 386 Interviews
Tata Group Interview Questions
4.2
 • 358 Interviews
Adani Group Interview Questions
3.9
 • 187 Interviews
Landmark Group Interview Questions
4.0
 • 147 Interviews
Lowe's Interview Questions
4.2
 • 127 Interviews
View all
Senior Technical Associate
171 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Technical Associate
133 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Technical Lead
91 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Advisor
46 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Advisor
36 salaries
unlock blur

₹0 L/yr - ₹0 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
Rate your experience using AmbitionBox
Terrible
Terrible
Poor
Poor
Average
Average
Good
Good
Excellent
Excellent