Cognizant Interview Questions, Process, and Tips

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

Q1. Ini files in powerbuilder.
Ans. 
Ini files in Powerbuilder are used to store configuration settings for applications.
• Ini files are text files with a .ini extension

• They contain key-value pairs in sections

• Powerbuilder provides functions to read and write ini files
Answered by AI
Add your answer
Q2. Powerbuilder functions and events
Ans. 
Powerbuilder functions are used to perform specific tasks, while events are triggered by user actions or system events.
• Functions in Powerbuilder are used to encapsulate a set of instructions that perform a specific task.

• Events in Powerbuilder are triggered by user actions (such as clicking a button) or system events (such as a timer expiring).

• Examples of functions in Powerbuilder include calculating a sum or formatting...read more
Answered by AI
Add your answer
Q3. Filters and buffers
Add your answer
Q4. Simple Database and sql questions
Add your answer

Aptitude test include communication and aptitude test

Coding test according to cluster

Q1. What are oops pillars
Ans. 
OOPs pillars refer to the four main concepts of Object-Oriented Programming: Inheritance, Encapsulation, Abstraction, and Polymorphism.
• Inheritance: Allows a class to inherit properties and behavior from another class.

• Encapsulation: Bundling data and methods that operate on the data into a single unit.

• Abstraction: Hiding the complex implementation details and showing only the necessary features of an object.

• Polymorphism...read more
Answered by AI
Add your answer
Q2. Tell me about your project
Ans. 
Developed a web application for tracking inventory and sales data.
• Used HTML, CSS, and JavaScript for front-end development.

• Utilized PHP and MySQL for back-end development.

• Implemented user authentication and authorization features.

• Integrated data visualization tools for reporting purposes.
Answered by AI
Add your answer