i
ITC Infotech
Filter interviews by
I applied via Naukri.com and was interviewed before Feb 2023. There was 1 interview round.
A primary key is a unique identifier for a record in a database table.
Primary key ensures each record in a table is unique.
It is used to establish relationships between tables.
Primary key can be a single column or a combination of columns.
It enforces data integrity and allows efficient data retrieval.
Example: In a table of students, the student ID can be the primary key.
The PRIMARY KEY constraint uniquely identifies each row in a table and must contain unique values.
A primary key is a column or a combination of columns that uniquely identifies each row in a table.
It ensures data integrity by preventing duplicate or null values in the primary key column(s).
Primary keys are used to establish relationships between tables through foreign keys.
Primary keys can be composed of a single colum...
Top trending discussions
posted on 3 Jan 2025
I applied via Referral and was interviewed in Dec 2024. There were 2 interview rounds.
Deep copy creates a new copy of an object with its own unique memory space, while shallow copy creates a new object that references the same memory locations as the original object.
Deep copy duplicates all nested objects, while shallow copy only duplicates the references to nested objects.
Deep copy ensures that changes to the copied object do not affect the original object, while shallow copy may lead to unintended sid...
Use a loop to swap characters of two strings without using strcpy function.
Create two arrays of characters to store the strings
Use a loop to iterate through each character of the strings and swap them
Ensure to handle cases where strings have different lengths
I applied via Walk-in and was interviewed in Nov 2024. There were 3 interview rounds.
It's walkin, so they conducted 1 technical mcqs round.
HashMap in Java is a data structure that stores key-value pairs and uses hashing to efficiently retrieve values based on keys.
HashMap uses an array of buckets to store key-value pairs.
Keys are hashed to determine the index in the array where the key-value pair will be stored.
In case of hash collisions, a linked list or a balanced tree is used to store multiple key-value pairs in the same bucket.
HashMap allows null keys...
Function to find and return all non-repeating characters in an array of strings.
Iterate through the array and count the occurrences of each character using a HashMap.
Then iterate through the array again and check if the count of each character is 1, if so add it to the result list.
Return the list of non-repeating characters.
To find the 3rd highest salary in a database, we can use a SQL query with the 'LIMIT' and 'OFFSET' keywords.
Use a SQL query with 'ORDER BY salary DESC' to sort the salaries in descending order.
Use 'LIMIT 1 OFFSET 2' to skip the first two highest salaries and retrieve the third highest salary.
Example: SELECT salary FROM employees ORDER BY salary DESC LIMIT 1 OFFSET 2;
A qualifier in Java is used to specify additional information about a primary, which is the main data type or variable.
A primary in Java is the main data type or variable, while a qualifier provides additional information about the primary.
Qualifiers can be used to modify the behavior or characteristics of a primary.
For example, in Java, 'final' is a qualifier that can be used to make a variable constant.
The main difference is that @RestController is a specialized version of @Controller that is used for RESTful web services.
Both @Controller and @RestController are used in Spring MVC to handle HTTP requests, but @RestController is specifically used for RESTful web services.
@Controller is used to create web pages, while @RestController is used to return data in JSON or XML format.
@RestController is a convenience annotati...
OOP concepts include inheritance, encapsulation, polymorphism, and abstraction.
Inheritance: Allows a class to inherit properties and behavior from another class. Example: class Dog extends Animal.
Encapsulation: Bundling data and methods that operate on the data into a single unit. Example: private variables with public getter and setter methods.
Polymorphism: Ability for objects to be treated as instances of their paren...
Microservices communicate with each other through various communication protocols like HTTP, messaging queues, and gRPC.
Microservices can communicate over HTTP using RESTful APIs.
Messaging queues like RabbitMQ or Kafka can be used for asynchronous communication between microservices.
gRPC is a high-performance, open-source RPC framework that can be used for communication between microservices.
Service discovery mechanism...
Microservice endpoints can be accessed using HTTP requests with the appropriate URL
Use HTTP methods like GET, POST, PUT, DELETE to interact with the microservice
Construct the URL with the base URL of the microservice and the specific endpoint path
Include any necessary headers or parameters in the request for authentication or data filtering
Microservices allow for modular, scalable, and flexible software development by breaking down applications into smaller, independent services.
Microservices enable easier maintenance and updates as each service can be developed, deployed, and scaled independently.
They improve fault isolation, as failures in one service do not necessarily affect the entire application.
Microservices promote agility and faster time-to-mark...
posted on 20 Dec 2024
Concurrency in Swift can be handled using Grand Central Dispatch (GCD) and Operation Queues.
Use GCD to perform tasks concurrently by creating dispatch queues.
Use Operation Queues to manage and execute multiple operations concurrently.
Avoid race conditions by using serial queues or synchronization techniques like semaphores or locks.
iOS app distribution methods include App Store, Ad Hoc, Enterprise, and TestFlight.
App Store distribution is for public release and requires Apple's review process.
Ad Hoc distribution allows sharing apps with a limited number of devices.
Enterprise distribution is for in-house apps within a company.
TestFlight is for beta testing with external testers before App Store release.
Developed a web application for tracking employee attendance and performance
Implemented user authentication and authorization using Spring Security
Utilized Hibernate for database interaction and data persistence
Designed and developed RESTful APIs for frontend integration
Used AngularJS for frontend development to create interactive user interfaces
I applied via Company Website and was interviewed in Nov 2024. There were 3 interview rounds.
A standard online test conducted through one of the testing platforms.
I applied via Approached by Company and was interviewed in Sep 2024. There was 1 interview round.
Promises are objects representing the eventual completion or failure of an asynchronous operation.
Promises are used to handle asynchronous operations in JavaScript.
They can be in one of three states: pending, fulfilled, or rejected.
Promises can be chained using .then() to handle success and .catch() to handle errors.
Example: const myPromise = new Promise((resolve, reject) => { ... });
Box model in CSS refers to the way elements are rendered in a web page. CSS preprocessors like SASS or LESS help streamline CSS development.
Box model in CSS includes content, padding, border, and margin.
CSS preprocessors like SASS or LESS allow for variables, nesting, and mixins to be used in CSS.
Example: box-sizing: border-box; in CSS changes the box model to include padding and border in the element's total width and
I applied via Approached by Company and was interviewed in Jun 2024. There was 1 interview round.
Yes, future methods can be called from a batch class in Salesforce.
Future methods can be called from batch classes to perform asynchronous processing.
This can be useful for offloading long-running tasks to future methods to avoid hitting governor limits.
Example: Calling a future method from a batch class to update records in Salesforce asynchronously.
The @track decorator in Salesforce is used to track changes to a property in a Lightning web component.
Used to make a property reactive and trigger re-renders when its value changes
Not mandatory but recommended for properties that need to be reactive
Use @track when you want changes to a property to be reflected in the UI
APEX CPU Limit Exceeded error happens when code consumes too much CPU time. Best practices include optimizing code, reducing loops, and using asynchronous processing.
Avoid using nested loops and optimize code for better performance
Use asynchronous processing like @future or Queueable to offload CPU intensive tasks
Limit the use of SOQL queries inside loops to reduce CPU consumption
Mixed DML Exception occurs when DML operations are performed on setup and non-setup objects in a single transaction.
Occurs when DML operations are performed on both setup and non-setup objects in a single transaction
Setup objects include User, Profile, PermissionSet, etc.
Non-setup objects include custom objects, standard objects like Account, Contact, etc.
The code will output 'undefined' because variable 'a' is hoisted within the function.
Variable 'a' is hoisted to the top of the function scope, so when 'console.log(a)' is called, 'a' is undefined.
To fix this, move the declaration of 'var a=2;' above the 'console.log(a);' statement.
SOQL query to fetch description field from Account and reason for inability to filter
SOQL query: SELECT Description FROM Account
Description field is not filterable because it is a long text field
Long text fields cannot be filtered in SOQL queries
Write a Code related to the Trigger
Batch job is a process that allows you to process large volumes of data in smaller chunks.
Batch job is used to handle large data volumes that would exceed the normal processing limits.
It breaks down the data into smaller batches for processing, improving performance and efficiency.
Batch jobs can be scheduled to run at specific times or triggered manually.
Examples include data imports, updates, and deletions in Salesfor
LWC (Lightning Web Components) are a modern UI framework for building web components on the Salesforce platform.
Pros: Faster performance, better security, easier to debug, reusable components, better encapsulation.
Cons: Steeper learning curve for developers new to web components, limited browser support compared to Aura components.
based on 3 reviews
Rating in categories
Associate Information Technology Consultant
5.2k
salaries
| ₹4.1 L/yr - ₹15 L/yr |
Lead Consultant
4.4k
salaries
| ₹9 L/yr - ₹35.4 L/yr |
Associate Consultant
834
salaries
| ₹2.5 L/yr - ₹16.5 L/yr |
Software Engineer
496
salaries
| ₹4 L/yr - ₹14 L/yr |
Software Developer
363
salaries
| ₹3.1 L/yr - ₹12 L/yr |
TCS
Wipro
HCLTech
Tech Mahindra