Ciklum Senior Software Engineer Interview Questions and Answers

Q1. Go Lang related questions
Add your answer
Q2. System architecture
Add your answer

Q1. Form based JS questions. String questions in javascript
Add your answer
Q2. React interview questions with some state management follow up questions.
Add your answer

Q1. About the project. and asked what i did in project. how to create schema in pyspark. what is ADE. what are the difficulties i faced in project. what is spark submit command how we write sparksubmit command...read more
Add your answer
Q2. No of occurrences of letter in a string.
Ans. 
Count occurrences of a letter in a string.
• Iterate through each character in the string and count occurrences of the specified letter.

• Use a hashmap to store the count of each letter.

• Handle both uppercase and lowercase letters to ensure accurate counting.
Answered by AI
Add your answer

Q1. Questions about C# language features
Add your answer
Q2. Azure functions and other services
Add your answer

Q1. DevOps concepts
Add your answer
Q2. Angular basics
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