Cognizant Interview Questions, Process, and Tips

Q1. What is the order of Annotations in TestNG
Ans. 
The order of Annotations in TestNG is @BeforeSuite, @BeforeTest, @BeforeClass, @BeforeMethod, @Test, @AfterMethod, @AfterClass, @AfterTest, @AfterSuite.
• Annotations are executed in the following order: @BeforeSuite, @BeforeTest, @BeforeClass, @BeforeMethod, @Test, @AfterMethod, @AfterClass, @AfterTest, @AfterSuite.

• Annotations are used in TestNG to perform actions before or after a test method or test class.

• For example, ...read more
Answered by AI
Add your answer
Q2. Write the XPath to identify “CNN Logo” on CNN’s official website
Ans. 
XPath to identify 'CNN Logo' on CNN's official website
• Use the 'contains' function to search for the alt attribute containing 'CNN Logo'

• XPath: //img[contains(@alt, 'CNN Logo')]
Answered by AI
View 1 more answer
Q3. What is the difference between “Sprint Review” and “Sprint Retrospective” meeting?
Ans. 
Sprint Review focuses on the product increment, while Sprint Retrospective focuses on the process and team dynamics.
• Sprint Review is a meeting held at the end of the sprint to review the product increment and get feedback from stakeholders.

• Sprint Retrospective is a meeting held at the end of the sprint to reflect on the process, identify what went well and what could be improved.

• Sprint Review is focused on the product ...read more
Answered by AI
Add your answer
Q4. How can you re-run failed test cases in TestNG?
Ans. 
Failed test cases in TestNG can be re-run using the 'rerunFailedTests' feature.
• Add 'rerunFailedTests' listener in testng.xml file

• Specify the number of times to re-run failed tests

• Failed tests will be re-run based on the specified count
Answered by AI
Add your answer

Q1. Tell me about Your Education?
Add your answer
Q2. WAP to get 3rd largest odd number in an array?
Ans. 
Find the 3rd largest odd number in an array of strings.
• Convert the array of strings to an array of integers.

• Filter out the odd numbers from the array.

• Sort the odd numbers in descending order.

• Return the 3rd element from the sorted array.
Answered by AI
Add your answer
Q3. Table vs views in sql
Ans. 
Tables store data in a structured format, while views are virtual tables that display data from one or more tables.
• Tables store actual data, while views store queries that display data

• Tables can be modified directly, while views are read-only

• Views can simplify complex queries by combining data from multiple tables

• Tables are physical structures, while views are logical structures
Answered by AI
Add your answer

Q1. Use of %TYPE and %ROWTYPE ?
Add your answer
Q2. How to check dependencies of a table ?
Ans. 
To check dependencies of a table, you can query system tables/views or use tools like SQL Server Management Studio.
• Query system tables/views like sys.foreign_keys to check foreign key dependencies

• Use tools like SQL Server Management Studio to visually see table dependencies

• Check stored procedures, functions, and triggers that reference the table
Answered by AI
Add your answer

Q1. How to delete duplicate records from a table without using primary key?
Add your answer
Q2. What is a hint? Explain its usage?
Add your answer

Q1. Self introduction
Add your answer
Q2. What are your current roles and responsibilities?
Add your answer

Q1. What is property and casualty insurance?
Ans. 
Property and casualty insurance provides coverage for property damage and liability risks.
• Property insurance covers damage to physical property such as homes, buildings, and personal belongings.

• Casualty insurance covers liability risks such as bodily injury or property damage caused to others.

• Examples include homeowners insurance, auto insurance, and commercial property insurance.
Answered by AI
Add your answer
Q2. What is the endorsement and policy lifecycle in insurance?
Ans. 
Endorsement and policy lifecycle in insurance involves making changes to an existing policy and managing it throughout its duration.
• Endorsements are changes made to an existing insurance policy, such as adding or removing coverage, changing policy limits, or updating personal information.

• The policy lifecycle includes the issuance of the policy, endorsements, renewals, and eventual cancellation or expiration.

• Insurance c...read more
Answered by AI
Add your answer

It was a general aptitude test consisting all possible topics.

General simple competitive coding questions with multiple programming language options.

Q1. Tell me about yourself.
Add your answer
Q2. Tell me about your projects.
Ans. 
I have worked on various projects including a mobile app for tracking fitness goals and a website for a local non-profit organization.
• Developed a mobile app using React Native to help users track their fitness goals

• Designed and built a website for a local non-profit organization using HTML, CSS, and JavaScript

• Collaborated with a team to create a database management system for a small business
Answered by AI
Add your answer
Q3. Questions regarding the cluster you have chosen while applying.
Add your answer