Cigniti Technologies Interview Questions, Process, and Tips

Array code to sort array in descending order

Q1. LINQ question, write LINQ statement for 2nd highest salary?, singleton design pattern, lazy loading implementation.
Add your answer
Q2. What is the use of CTE in SQLSERVER ?
Ans. 
CTE stands for Common Table Expression and is used to create a temporary result set that can be referenced within a SELECT, INSERT, UPDATE, or DELETE statement.
• CTE is used to simplify complex queries by breaking them down into smaller, more manageable parts.

• It can be used to create recursive queries, which are queries that reference themselves.

• CTE is defined using the WITH keyword followed by the name of the CTE and th...read more
Answered by AI
Add your answer
Q3. What is Defered Execution ?
Ans. 
Defered Execution is a technique where the execution of a query or operation is delayed until it is actually needed.
• Defered Execution is used in LINQ queries to improve performance by delaying the execution of the query until the results are actually needed.

• It allows for more efficient use of resources by avoiding unnecessary computations.

• Examples of Defered Execution include using the .Where() method in LINQ to filter...read more
Answered by AI
Add your answer
Q4. What is magic table in SQLSERVER ?
Ans. 
Magic table is a temporary table created by SQL Server during DML operations.
• It is also known as inserted and deleted tables.

• Inserted table contains the new rows being added to a table.

• Deleted table contains the rows being deleted from a table.

• It is used in triggers to access the data being modified.

• It cannot be directly queried or modified by the user.
Answered by AI
Add your answer
Q5. What is the use of extension method ?
Ans. 
Extension methods allow adding new methods to existing types without modifying the original type.
• Extension methods are defined as static methods in a static class.

• They must be in the same namespace as the type being extended.

• They are called like instance methods on the extended type.

• They can be used to add functionality to third-party or system types.

• Example: adding a method to the string type to convert a string to ti
Answered by AI
Add your answer

Q1. Functional Testing QA, Agile testing, Team build, Scenario Based Questions
Add your answer

Q1. Manager round with some technical qa on reports and Matrix RTM etc
Add your answer

Q1. Client round full on testing QA and DB QA
Add your answer

Q1. Manager round projects worked till the time
Add your answer

Q1. What is full form of RPA How many robot types are there etc Tq
Ans. 
RPA stands for Robotic Process Automation. It is a technology that uses software robots to automate repetitive tasks.
• RPA is a technology that uses software robots to automate repetitive tasks.

• It helps in streamlining business processes and improving efficiency.

• There are three types of robots in RPA: Attended robots, Unattended robots, and Hybrid robots.

• Attended robots work alongside humans and assist them in completing...read more
Answered by AI
View 1 more answer

Q1. Giving one task about RPA course
Add your answer

Q1. We are not able to work in Cigniti
Add your answer
Q2. It employees are not able to work in cigniti
Add your answer

General English, Aptitude in online exam

Q1. Manual testing technical questions F2F
Add your answer

Q1. Client interview in online at the company
Add your answer

Q1. Salary discussions and some background details F2F
Add your answer