Cognizant Junior Programmer Analyst Interview Questions and Answers

Q1. Interviewer was rude
Add your answer
Q2. Oops c# basics sql azure
Add your answer

Q1. What is work of team lead? how do you handle workload of yours and the junior assigned to you? how do u handle conflicts?
Ans. 
Team lead is responsible for managing the workload of the team, including assigning tasks, providing guidance, and resolving conflicts.
• Assign tasks to team members based on their skills and workload capacity

• Provide guidance and support to junior team members to help them complete their tasks successfully

• Monitor progress of tasks and ensure deadlines are met

• Resolve conflicts within the team by listening to all parties i...read more
Answered by AI
Add your answer
Q2. Other deep technical questions
Add your answer

Q1. How to connect to PHP to SQL ?
Ans. 
To connect PHP to SQL, use functions like mysqli_connect or PDO to establish a connection and execute queries.
• Use mysqli_connect function to establish a connection with MySQL database

• Use PDO class to connect to various types of databases like MySQL, PostgreSQL, etc.

• Execute SQL queries using functions like mysqli_query or PDO::query
Answered by AI
Add your answer
Q2. Full form of PHP?
Ans. 
Hypertext Preprocessor
• Stands for Hypertext Preprocessor

• Server-side scripting language

• Used for web development

• Open source and free to use
Answered by AI
Add your answer
Q3. Haepar text pre prosesar
Add your answer
Q4. Php and SQL opsn sorss language
Add your answer

Q1. Covered all areas of dot net developments
Add your answer
Q2. C#,oops,entity framework,.net mvc,sql server
Add your answer

Arithmetic, reasoning, English

100 questions were there related to html, css, web api and javascript

Group discussion was on Functional programming verses OOPs

Q1. Why you want to join this company.
Add your answer
Q2. Where you see yourself after 5 years.
Add your answer

Q1. Basics of object oriented programming
Add your answer
Q2. Roles and domains worked
Add your answer
Q3. Types of cursors and joins in sql
Ans. 
Types of cursors and joins in SQL
• Cursors: Forward-only, Static, Dynamic, Keyset-driven

• Joins: Inner, Left, Right, Full, Cross

• Cursors are used to iterate through a result set

• Joins are used to combine data from multiple tables based on a common column
Answered by AI
Add your answer
Q4. Security mechanism apart from authorisation and Authentication
Ans. 
Data encryption, firewalls, intrusion detection and prevention systems.
• Data encryption

• Firewalls

• Intrusion detection and prevention systems
Answered by AI
Add your answer
Q5. Basics of model view controller
Add your answer

Implement of gang of 4 patterns and program execution

Q1. Performance Tunings Joins
Add your answer
Q2. SSIS Bufferr and memories related queries Parallel processing in SSIS Power BI reporting life cycle DAX questions on power BI
Add your answer

Q1. Role of CPU AND Cores in Performance Improvement Sharding concepts TABLE PARTITION DATA WAREHOUSE
Add your answer

Q1. Role based questions
Add your answer

Q1. What do you mean by OOPS?
Ans. 
OOPS stands for Object-Oriented Programming System.
• OOPS is a programming paradigm that focuses on objects and their interactions.

• It involves concepts like inheritance, polymorphism, encapsulation, and abstraction.

• OOPS allows for modular and reusable code, making it easier to maintain and scale.

• Examples of OOPS languages include Java, C++, Python, and Ruby.
Answered by AI
Add your answer
Q2. Write a program on Random number
Ans. 
A program to generate random numbers.
• Use the random module in Python to generate random numbers.

• Specify the range of numbers to be generated using the randint() function.

• Seed the random number generator for reproducibility using the seed() function.

• Use the random() function to generate random floating-point numbers.

• Use the choice() function to randomly select an item from a list.
Answered by AI
Add your answer
Q3. What is join in SQL?
Ans. 
Join in SQL is used to combine rows from two or more tables based on a related column between them.
• Join is used to retrieve data from multiple tables in a single query

• Types of join include inner join, left join, right join, and full outer join

• Join is performed using the JOIN keyword followed by the table name and ON keyword to specify the related column
Answered by AI
Add your answer

Q1. Tell me about yourself.
Add your answer
Q2. Why you choose this organization rather than other
Add your answer