Ciklum Senior Software Engineer and Lead Interview Questions and Answers

If you are a fresher , then this is for you else almost no coding test for experienced candidates.

Q1. Javascript basics, Angular react general questions depends upon profile.
Add your answer

Q1. They asked general questions related to some hectic situation faced in previous company / project..
Add your answer

Q1. What is Synonyms in SQL Server
Ans. 
Synonyms in SQL Server are alternate names for database objects like tables, views, stored procedures, etc.
• Synonyms provide a way to simplify queries by providing a single name for an object that may have a long or complex name.

• They can be used to reference objects in a different schema or database without changing the code.

• Synonyms can be created using the CREATE SYNONYM statement and dropped using the DROP SYNONYM st
Answered by AI
Add your answer
Q2. What are the different joins used in SQL
Ans. 
Different types of joins in SQL include inner join, outer join, left join, right join, and full join.
• Inner join: Returns rows when there is at least one match in both tables

• Outer join: Returns all rows when there is a match in one of the 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 tabl...read more
Answered by AI
Add your answer
Q3. What is the difference between Factory and Singleton design Pattern
Ans. 
Factory pattern is used to create objects without exposing the instantiation logic to the client, while Singleton pattern ensures a class has only one instance and provides a global point of access to it.
• Factory pattern is used to create objects based on a common interface, without specifying the exact class of the object being created.

• Singleton pattern restricts the instantiation of a class to one object, ensuring tha...read more
Answered by AI
Add your answer
Q4. Difference between Functions and stored procedure
Ans. 
Functions are used to perform specific tasks and return a value, while stored procedures are used to perform a series of actions.
• Functions return a single value, while stored procedures can return multiple values or none at all.

• Functions are called in SQL statements, while stored procedures are called using their name.

• Functions cannot modify the database state, while stored procedures can.

• Functions are easier to test a...read more
Answered by AI
Add your answer

Simple calculator in C# console apllication that can take strings as input with operators and values

Q1. Project flow? and how do you handle the Exceptions in current project?
Ans. 
Project flow involves understanding the sequence of tasks in a project. Exceptions are handled using try-catch blocks.
• Project flow involves defining the sequence of tasks from start to finish.

• Exceptions are handled using try-catch blocks to catch and handle errors gracefully.

• Logging and alerting mechanisms are implemented to track and notify about exceptions.

• Unit tests are written to cover different scenarios and ensur...read more
Answered by AI
Add your answer
Q2. Oops concepts and basic core java questions
Add your answer

Q1. Database related questions ?
Add your answer
Q2. Write program to reverse string ?with out using pre defined methods
Ans. 
Program to reverse a string without using predefined methods
• Create an empty string to store the reversed string

• Iterate through the input string from end to start and append each character to the new string

• Return the reversed string as the output
Answered by AI
Add your answer

Q1. What is HashMap?
Ans. 
HashMap is a data structure that stores key-value pairs and provides constant time complexity for basic operations.
• HashMap allows quick access to values based on their keys

• Keys must be unique and values can be duplicated

• HashMap is not thread-safe and requires synchronization for concurrent access

• Java's HashMap implementation uses hashing to distribute keys across buckets
Answered by AI
Add your answer
Q2. It’s a collection framework.
Add your answer

Q1. Questions related to Java, Spring, Rest API
Add your answer

Q1. Basic java collection questions
Add your answer

Q1. Spring boot basic questions
Add your answer

Q1. Why should we hire you
Ans. 
I have a strong technical background, proven track record of delivering high-quality software, and a passion for continuous learning and improvement.
• I have a Bachelor's degree in Computer Science and X years of experience in software development.

• I have successfully led multiple projects from conception to completion, delivering high-quality software on time and within budget.

• I am proficient in a variety of programming ...read more
Answered by AI
View 1 more answer

Share the link for codesignal

Q1. Java related questions
Add your answer
Q2. Based on the resume
Add your answer