Ciklum Office Manager Interview Questions and Answers

Q1. About Profile & Previous related experience
Add your answer

Q1. Situational and analytical questions to understand the roles performed previously.
Add your answer

Q1. Offer discussion
Add your answer

Aptitude test

Current affairs

Q1. Puzzle , sql related questions
Add your answer

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

Moderate difficult with business reasoning

Q1. Prior work Ex mostly and a case study
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