Upload Button Icon Add office photos

ITC

Compare button icon Compare button icon Compare

Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards

zig zag pattern zig zag pattern

Filter interviews by

Clear (1)

ITC Plsql Developer Interview Questions and Answers

Updated 15 Jan 2025

ITC Plsql Developer Interview Experiences

1 interview found

Plsql Developer Interview Questions & Answers

user image surbhi goyal

posted on 15 Jan 2025

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 questions from similar companies

I applied via Recruitment Consultant and was interviewed before May 2020. There were 3 interview rounds.

Interview Questionnaire 

3 Questions

  • Q1. Related to sales automation.
  • Q2. What is SFA?
  • Ans. 

    SFA stands for Sales Force Automation.

    • SFA is a software system that automates sales processes.

    • It helps sales teams manage customer interactions, track leads, and close deals.

    • SFA can also provide analytics and reporting on sales performance.

    • Examples of SFA software include Salesforce, HubSpot, and Zoho CRM.

  • Answered by AI
  • Q3. What is DMS?
  • Ans. 

    DMS stands for Document Management System.

    • DMS is a software system used to manage, store, and track electronic documents and images.

    • It allows for easy retrieval and sharing of documents within an organization.

    • DMS can also provide version control and security features to ensure document integrity.

    • Examples of DMS include Microsoft SharePoint, Google Drive, and Dropbox Business.

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - It was a long session and was an interesting one.
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

Moderate level. It was easy to crack. There was few aptitude and coding questions associated

Round 2 - Technical 

(1 Question)

  • Q1. Questions on SQL
Round 3 - HR 

(2 Questions)

  • Q1. Tell me about yourself
  • Q2. Tell positive and negative points about you
Interview experience
4
Good
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 Resume tips
Round 2 - Coding Test 

They ask nothing only few questions on dsa

Round 3 - Group Discussion 

They ask previous projects knowledge

Interview Preparation Tips

Interview preparation tips for other job seekers - Go with full of confidence but if you're non it background
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. How indexing works internally?
  • Ans. 

    Indexing in databases is a way to optimize search queries by creating a data structure that allows for faster retrieval of data.

    • Indexing creates a data structure (like B-trees or hash tables) that maps keys to the locations of corresponding data entries.

    • When a query is made, the database engine uses the index to quickly locate the relevant data entries instead of scanning the entire database.

    • Indexes can be created on o...

  • Answered by AI
Round 2 - One-on-one 

(2 Questions)

  • Q1. Intoduce yourself
  • Ans. 

    I am a passionate software developer with experience in Java, Python, and web development.

    • Experienced in Java and Python programming languages

    • Proficient in web development technologies such as HTML, CSS, and JavaScript

    • Strong problem-solving skills and ability to work in a team environment

  • Answered by AI
  • Q2. Your Projects
  • Ans. 

    Developed a web application for tracking personal fitness goals

    • Used React.js for front-end development

    • Implemented RESTful APIs for data retrieval and storage

    • Utilized MongoDB for database management

  • Answered by AI

Interview Questionnaire 

2 Questions

  • Q1. Tell me about yourself
  • Q2. Why do you want to change

Interview Preparation Tips

Interview preparation tips for other job seekers - Average just prepare it

I applied via Walk-in and was interviewed before Oct 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 Resume tips
Round 2 - Group Discussion 

Its all about the overview of marketing

Round 3 - HR 

(2 Questions)

  • Q1. Whether Capable to perform a task or not?
  • Q2. How much salary do you Expect from our company?

Interview Preparation Tips

Interview preparation tips for other job seekers - Don't be nervous
Be confident
Keep eye contact
Make a perfect resume mentioning suitable skills and perfect objective .
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed before Aug 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 - Technical 

(2 Questions)

  • Q1. Questions GST concepts
  • Q2. Checking Excel Skills
Round 3 - One-on-one 

(1 Question)

  • Q1. Asking personal Detaiuls

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare well & Be confident
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

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

Round 1 - Coding Test 

Python c java etc more about code

I was interviewed in Apr 2017.

Interview Questionnaire 

1 Question

  • Q1. Family background, father's job, personal details

Interview Preparation Tips

Round: Technical + HR Interview
Experience: There were three panelists.As I went in, I was first asked to present my CV. All of them were asking questions together. One was asking technical questions related to chemical engineering while the other two were taking the HR interview. They were all very polite and gentle.At first. I had to tell them my 10th and 12th percentage and my ranks in JEE Main, JEE Advanced and WBJEE. Then I was asked why I chose chemical engineering and what were my areas or subjects of interest. I answered Mass transfer and Chemical Reaction Engineering. They were quite impressed to hear as they said I was the first one who mentioned it. I was mainly asked questions from distillation and gas absorption. All the questions were very basic and required clear understanding of the concepts. I was asked to give a brief summary about my industrial visit to RCF, Mumbai. I was also asked some questions on my ongoing project work at college. Overall, it was a pleasant experience.

College Name: Jadavpur University, Kolkata
Contribute & help others!
anonymous
You can choose to be anonymous

ITC Interview FAQs

How many rounds are there in ITC Plsql Developer interview?
ITC interview process usually has 1 rounds. The most common rounds in the ITC interview process are Technical.
What are the top questions asked in ITC Plsql Developer interview?

Some of the top questions asked at the ITC Plsql Developer interview -

  1. What is the difference between varchar and varcha...read more
  2. Explain composite inde...read more

Recently Viewed

PHOTOS

InsuranceDekho

3 office photos

LIST OF COMPANIES

Credit Bajaar

Overview

REVIEWS

Kotak Mahindra Bank

No Reviews

JOBS

GlobalLogic

No Jobs

JOBS

Kotak Mahindra Bank

No Jobs

JOBS

Kotak Mahindra Bank

No Jobs

INTERVIEWS

KOHINOOR TELEVIDEO

No Interviews

INTERVIEWS

HCL Group

No Interviews

INTERVIEWS

ITC

No Interviews

REVIEWS

Zydus Lifesciences

No Reviews

Tell us how to improve this page.

ITC Plsql Developer Interview Process

based on 1 interview

Interview experience

3
  
Average
View more

Interview Questions from Similar Companies

Asian Paints Interview Questions
4.0
 • 644 Interviews
Dabur Interview Questions
4.0
 • 271 Interviews
Nestle Interview Questions
3.9
 • 233 Interviews
RSPL Group Interview Questions
4.1
 • 187 Interviews
Britannia Interview Questions
4.0
 • 164 Interviews
Titan Company Interview Questions
4.3
 • 149 Interviews
Procter & Gamble Interview Questions
4.1
 • 114 Interviews
Adani Wilmar Interview Questions
4.2
 • 106 Interviews
View all
ITC Plsql Developer Salary
based on 5 salaries
₹3 L/yr - ₹7 L/yr
33% less than the average Plsql Developer Salary in India
View more details
Area Executive
1.2k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Assistant Manager
600 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Area Sales Executive
565 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Sales Officer
488 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Area Sales Manager
431 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare ITC with

Hindustan Unilever

4.2
Compare

Nestle

3.9
Compare

Britannia

4.0
Compare

Godrej Consumer Products

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