AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
ITC
Compare
Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
Clear (1)
ITC Plsql Developer Interview Questions and Answers
ITC Plsql Developer Interview Experiences
1 interview found
surbhi goyal
I applied via Naukri.com and was interviewed in Dec 2024. There was 1 interview round.
(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.
- 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)
Top trending discussions
Interview questions from similar companies
Anonymous
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.
- 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.
Interview Preparation Tips
Moderate level. It was easy to crack. There was few aptitude and coding questions associated
(1 Question)
- Q1. Questions on SQL
(2 Questions)
- Q1. Tell me about yourself
- Q2. Tell positive and negative points about you
They ask nothing only few questions on dsa
They ask previous projects knowledge
Interview Preparation Tips
(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...
(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
- 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
Interview Questionnaire
2 Questions
- Q1. Tell me about yourself
- Q2. Why do you want to change
Interview Preparation Tips
I applied via Walk-in and was interviewed before Oct 2021. There were 3 interview rounds.
Its all about the overview of marketing
(2 Questions)
- Q1. Whether Capable to perform a task or not?
- Q2. How much salary do you Expect from our company?
Interview Preparation Tips
Be confident
Keep eye contact
Make a perfect resume mentioning suitable skills and perfect objective .
Selected
I applied via Referral and was interviewed before Aug 2022. There were 3 interview rounds.
(2 Questions)
- Q1. Questions GST concepts
- Q2. Checking Excel Skills
(1 Question)
- Q1. Asking personal Detaiuls
Interview Preparation Tips
I applied via LinkedIn and was interviewed in Apr 2024. There was 1 interview round.
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
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
ITC Interview FAQs
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 Interviews By Designations
- ITC AUT - Assistant Under Training Interview Questions
- ITC Area Executive Interview Questions
- ITC Sales Trainee Interview Questions
- ITC Area Sales Executive Interview Questions
- ITC Sales Officer Interview Questions
- ITC Intern Interview Questions
- ITC Finance Executive Interview Questions
- ITC Area Sales Manager Interview Questions
- Show more
Interview Questions for Popular Designations
- Oracle SQL and PLSQL Developer Interview Questions
- Senior Plsql Developer Interview Questions
- Front end Developer Interview Questions
- Web Developer Interview Questions
- Software Developer Intern Interview Questions
- Backend Developer Interview Questions
- Junior Software Developer Interview Questions
- Full Stack Software Developer Interview Questions
- Show more
ITC Plsql Developer Interview Process
based on 1 interview
Interview experience
Interview Questions from Similar Companies
Fast track your campus placements
|
Area Executive
1.2k
salaries
|  ₹0 L/yr - ₹0 L/yr |
|
Assistant Manager
600
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Area Sales Executive
565
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Sales Officer
488
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Area Sales Manager
431
salaries
| ₹0 L/yr - ₹0 L/yr |
Hindustan Unilever
Nestle
Britannia
Godrej Consumer Products
- Home >
- Interviews >
- ITC Interview Questions >
- ITC Plsql Developer Interview Questions
