20+ ITC Limited Foods Division Interview Questions and Answers

Regular expression for 10-digit numeric characters starting with 1, 2, or 3.

• Use the pattern ^[1-3]\d{9}$ to match the criteria

• The ^ symbol denotes the start of the string

• The [1-3] specifies that the first digit must be 1, 2, or 3

• \d{9} matches exactly 9 numeric digits

• $ indicates the end of the string

A join in SQL is used to combine rows from two or more tables based on a related column between them.

• Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

• INNER JOIN returns rows when there is at least one match in both tables.

• LEFT JOIN returns all rows from the left table and the matched rows from the right table.

• RIGHT JOIN returns all rows from the right table and the matched rows from the left table.

• FULL JOIN returns rows when there is a match in one of t...read more

OOPS stands for Object-Oriented Programming System. It is a programming paradigm based on the concept of objects.

• OOPS focuses on creating objects that contain data in the form of fields (attributes) and code in the form of procedures (methods).

• Encapsulation, inheritance, and polymorphism are key principles of OOPS.

• Encapsulation refers to the bundling of data and methods that operate on the data into a single unit (object).

• Inheritance allows a class to inherit properties and b...read more

Basic SQL skills include querying databases, manipulating data, and understanding database structures.

• Writing basic SQL queries to retrieve data from databases

• Understanding and using SQL functions and operators

• Creating and modifying database tables and relationships

• Using SQL to filter, sort, and group data

• Understanding basic SQL syntax and commands

SQL is a language used to manage and query databases, PL/SQL is an extension that adds procedural programming capabilities.

• SQL is used for querying and manipulating data in databases.

• PL/SQL is a procedural language extension for SQL, allowing for more complex logic and programming capabilities.

• Data structures in SQL refer to the way data is organized and stored in tables.

• PL/SQL allows for the creation of custom data structures using variables, arrays, and records.

• Differences ...read more

To convert hours into seconds, multiply the number of hours by 3600.

• Multiply the number of hours by 3600 to get the equivalent seconds.

• For example, 2 hours = 2 * 3600 = 7200 seconds.

I have used a variety of programming languages including Java, Python, C++, and JavaScript.

• Java

• Python

• C++

• JavaScript

SQL is a language used for managing and querying databases, while PL/SQL is an extension of SQL used for procedural programming.

• SQL stands for Structured Query Language and is used for managing and querying relational databases.

• PL/SQL stands for Procedural Language/SQL and is an extension of SQL that adds procedural programming capabilities.

• SQL is used to retrieve and manipulate data in databases using queries like SELECT, INSERT, UPDATE, DELETE.

• PL/SQL allows for the creation...read more

Forms are used to input data while reports are used to display data.

• Forms are used to collect and input data into a system.

• Reports are used to display and present data in a structured format.

• Forms are interactive and allow users to input data, while reports are static and provide information based on the data entered.

• Examples: A registration form on a website vs. a sales report generated from a database.

Spring MVC is a framework for building web applications in Java, following the Model-View-Controller design pattern.

• Spring MVC follows the Model-View-Controller design pattern, where the model represents the data, the view represents the UI, and the controller handles the user input.

• It provides components like DispatcherServlet, Controller, Model, and ViewResolver to handle requests and responses.

• It supports the use of annotations like @Controller, @RequestMapping, and @Model...read more