McAfee Software Development Engineer 1 Interview Questions and Answers

Finding all unique pairs of BST

Given stream of numbers , return yes/no - for a series of numbers if each number is present or not

Q1. Fully Optimized SQL Query for some scenario
Add your answer
Q2. Joins vs Subqueries
Ans. 
Joins are used to combine rows from two or more tables based on a related column, while subqueries are nested queries used to return data for the main query.
• Joins are used to retrieve data from multiple tables based on a related column.

• Subqueries are used to return data for the main query by nesting a query within another query.

• Joins are typically more efficient than subqueries for retrieving data from multiple tables.

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

Question related to operating system and computer network

Q1. Traverse all child nodes in tree
Ans. 
Traverse all child nodes in a tree data structure
• Use depth-first or breadth-first traversal algorithms

• Recursively visit each child node starting from the root node

• Consider using a stack or queue data structure for traversal

• Example: Traverse all nodes in a binary tree
Answered by AI
Add your answer

Q1. Question related to cloud and oops
Add your answer

Q1. Question related to my background and how web site work
Add your answer

Q1. Basics of oops, .net framework and .net core
Add your answer
Q2. Sql query for student department id
Ans. 
SQL query to retrieve student department id.
• Use SELECT statement to retrieve data

• Specify the columns to be selected, including the department id column

• Specify the table where the student data is stored

• Use WHERE clause to filter the results based on student information
Answered by AI
Add your answer
Q3. Solid principles and design patterns
Add your answer

Q1. Asked to code palindrome
Add your answer
Q2. Code duplicate string from main string and get index of sub string
Ans. 
Code to find index of sub string in main string and duplicate the sub string
• Use a loop to iterate through the main string and check for the sub string

• If sub string is found, duplicate it and store the index

• Return the index of the duplicated sub string
Answered by AI
Add your answer

Q1. Manager asked me to code the count index of substring and sum of substring
Add your answer
Q2. Questions as HR informed, it was worst and all interviews were scheduled at night time.he was more technical than the second round team lead instead of asking manager round
Add your answer

1st round is aptitude and pesudocode

Q1. Mostly python questions
Add your answer
Q2. List questions and basic to mediumprogram
Add your answer

In first round 4 coding question like 1 dsa 2 database and one is api and question is very simple . coding round was conducted in hackerrank

Q1. DSA QUESTION LIKE TREE AND GRAPH
Add your answer
Q2. DP AND SORTING APPROACH
Add your answer

Again same but dsa question and oops concept in deep level

Q1. Basic java fundamentals
Add your answer
Q2. Spring boot,sql
Add your answer

Q1. Some technical questions from manager
Add your answer
Q2. Some challenges or scenario based questions
Add your answer

Q1. Salary discussion mostly
Add your answer
Q2. Benifts that they offer with TR
Add your answer

Q1. What is the inheritance?
Ans. 
Inheritance is a mechanism in object-oriented programming where a class inherits properties and behaviors from another class.
• Allows a class to inherit attributes and methods from another class

• Promotes code reusability and reduces redundancy

• Creates a parent-child relationship between classes

• Derived class can override or extend the functionality of the base class
Answered by AI
Add your answer
Q2. What are the types of joins in mysql
Ans. 
Types of joins in MySQL include inner join, left join, right join, and full join.
• Inner join: Returns rows when there is a match in both 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 table.

• Full join: Returns rows when there is a match in one of the tables.
Answered by AI
Add your answer

Q1. How to handle multiple api's
Ans. 
Use a centralized API gateway to manage and route requests to multiple APIs efficiently.
• Implement a centralized API gateway to handle incoming requests and route them to the appropriate API based on the endpoint.

• Utilize API management tools like Apigee, Kong, or AWS API Gateway to manage and monitor multiple APIs.

• Consider implementing a caching layer to improve performance and reduce the number of requests to external
Answered by AI
Add your answer
Q2. What does strstr function do?
Ans. 
strstr function searches for a substring within a string and returns a pointer to the first occurrence of the substring.
• Used in C programming language

• Syntax: char *strstr(const char *haystack, const char *needle)

• Example: char *str = strstr("hello world", "world")
Answered by AI
Add your answer

Maths ,english ,reasoning, puzzles

Jackeron was the platform