ICON Plc Senior Engineer Interview Questions and Answers

Q1. Anagram of two strings in java
Ans. 
Java program to check if two strings are anagrams
• Create a function that takes two strings as input

• Convert both strings to character arrays and sort them

• Check if the sorted arrays are equal to determine if they are anagrams
Answered by AI
Add your answer
Q2. Insert and select query in MySQL
Ans. 
Insert and select data in MySQL using SQL queries
• Use INSERT INTO table_name (column1, column2, ...) VALUES (value1, value2, ...); to insert data

• Use SELECT * FROM table_name; to select all data from a table

• Use SELECT column1, column2 FROM table_name WHERE condition; to select specific data based on a condition
Answered by AI
Add your answer
Q3. Get and Post APIs in rest
Ans. 
GET and POST are HTTP methods used in REST APIs for retrieving and sending data.
• GET method is used to retrieve data from a server

• POST method is used to send data to a server

• GET requests are idempotent, while POST requests are not

• GET requests should only be used for retrieving data, not for modifying data

• Example: GET request to retrieve a list of users - GET /users

• Example: POST request to create a new user - POST /users
Answered by AI
Add your answer

It was very easy basic qns

Q1. Why would you like to work for this company
Add your answer

There were two question on DSA

Q1. Will be full on previous experience technical found
Add your answer
Q2. Previous company technical questions
Add your answer

Q1. What is JAVA in software
Ans. 
JAVA is a high-level programming language used for developing applications and software.
• Object-oriented programming language

• Platform-independent

• Used for web development, mobile apps, enterprise software

• Has a large standard library

• Supports multithreading and networking
Answered by AI
Add your answer
Q2. What is oracle in software
Ans. 
Oracle in software refers to Oracle Corporation, a multinational computer technology corporation known for its database management systems.
• Oracle is a leading provider of relational database management systems (RDBMS).

• It offers a wide range of products and services for data management, cloud applications, and more.

• Oracle databases are widely used in enterprise applications for storing and managing data efficiently.

• Exam...read more
Answered by AI
Add your answer

Q1. Code for Hello World
Ans. 
Simple code to print 'Hello World'
• Use a print statement to display 'Hello World'

• In Python: print('Hello World')

• In Java: System.out.println('Hello World')
Answered by AI
Add your answer
Q2. Code for printing algo
Ans. 
Code for printing algorithm in software development.
• Use loops to iterate through the data to be printed.

• Consider formatting options such as spacing and alignment.

• Handle edge cases like empty input or invalid data.

• Example: for (int i = 0; i < array.length; i++) { System.out.println(array[i]); }
Answered by AI
Add your answer

Q1. Different arrays in string types
Ans. 
Arrays of string types are collections of strings stored in a single variable.
• Arrays can be declared and initialized with string values like ['apple', 'banana', 'cherry'].

• Access individual strings in the array using index like array[0] for 'apple'.

• Perform operations like sorting or filtering on arrays of strings.
Answered by AI
Add your answer
Q2. Different strings in array texts
Ans. 
Comparing different strings in an array of texts.
• Iterate through the array and compare each string with the others.

• Use a nested loop to compare each pair of strings.

• Consider using a hash map to store the frequency of each unique string for efficient comparison.
Answered by AI
Add your answer

Q1. Different dS in software engineer
Ans. 
Different design patterns in software engineering
• Creational patterns (e.g. Singleton, Factory)

• Structural patterns (e.g. Adapter, Decorator)

• Behavioral patterns (e.g. Observer, Strategy)
Answered by AI
Add your answer
Q2. Diff types in string test types
Ans. 
Different types of string test types include equality, containment, length, case sensitivity, and pattern matching.
• Equality test: comparing two strings to see if they are exactly the same

• Containment test: checking if a string contains a specific substring

• Length test: determining the length of a string

• Case sensitivity test: checking if two strings are equal while considering case

• Pattern matching test: using regular expr
Answered by AI
Add your answer

Q1. Explain Behaviour subject in Angular.
Ans. 
Behaviour subject in Angular is a special type of subject that allows both subscribing and emitting values.
• BehaviourSubject is a type of subject in RxJS library.

• It has an initial value that will be emitted to new subscribers.

• It stores the latest value and emits it immediately to new subscribers.

• Example: const subject = new BehaviorSubject('initial value');

• Example: subject.next('new value');
Answered by AI
Add your answer
Q2. Explain Design Principles
Ans. 
Design principles are guidelines for designing software solutions that are maintainable, scalable, and efficient.
• Design principles help in creating software that is easy to understand, modify, and maintain.

• They promote code reusability, modularity, and flexibility.

• Examples of design principles include SOLID principles, DRY (Don't Repeat Yourself), KISS (Keep It Simple, Stupid), and YAGNI (You Aren't Gonna Need It).
Answered by AI
Add your answer

Q1. SQL interview question
Add your answer
Q2. Stored Procedure and function differences
Ans. 
Stored procedures are precompiled and stored in the database, while functions are compiled and stored in memory.
• Stored procedures are precompiled and stored in the database for reuse.

• Functions are compiled and stored in memory for faster execution.

• Stored procedures can return multiple values, while functions return a single value.

• Functions can be called from within a stored procedure, but stored procedures cannot be ca
Answered by AI
Add your answer
Q3. SQL query flow and window function they will ask
Add your answer