Cornerstone OnDemand Lead Software Engineer Interview Questions and Answers

Q1. Two sum of an array
Ans. 
Find two numbers in an array that add up to a specific target value.
• Use a hashmap to store the difference between the target value and each element in the array.

• Iterate through the array and check if the current element's complement exists in the hashmap.

• Return the indices of the two numbers that add up to the target value.
Answered by AI
Add your answer
Q2. Stack balance parenthesis
Add your answer

Q1. Is circular loop is there in a linkedList
Ans. 
No, a circular loop is not present in a linked list.
• A linked list does not have a circular loop by default.

• If a linked list has a circular loop, it is considered a circular linked list.

• Circular linked lists can be detected using Floyd's Cycle Detection Algorithm.
Answered by AI
Add your answer
Q2. How to identify the duplicates in circular linkedList
Ans. 
To identify duplicates in a circular linked list, use a hash set to keep track of visited nodes.
• Traverse the circular linked list while adding each node to a hash set.

• If a node is already in the hash set, it is a duplicate.

• Consider edge cases such as an empty list or a list with only one node.
Answered by AI
Add your answer

Time and Speed, Percentages, Averages, Ratio and Proportion, Time and Work etc.

Platform was Mettle Assessment, Topics were Tree and Binary Search

Work from office vs Work from Home

Q1. Multi-threading, Communication between thread, dynamic programming, trees, sorting techniques.
View 1 more answer
Q2. What is TCP, UDP, Difference between TCP and UDP, Three way handshaking problem, socket programming, HTTP Protocol.
Ans. 
TCP (Transmission Control Protocol) and UDP (User Datagram Protocol) are protocols used for data transmission over networks.
• TCP is a connection-oriented protocol that guarantees reliable delivery of data.

• UDP is a connectionless protocol that does not guarantee reliable delivery of data.

• The main difference between TCP and UDP is that TCP provides reliable, ordered, and error-checked delivery of data, while UDP does not.

• ...read more
Answered by AI
View 1 more answer
Q3. Write code to print bottom view of Binary Search Tree
Ans. 
Print the bottom view of a Binary Search Tree.
• Use a map to store the horizontal distance and the bottom-most node at that distance.

• Traverse the tree in level order and update the map with each node's horizontal distance and level.

• Print the nodes in the map in ascending order of their horizontal distance.
Answered by AI
Add your answer

Q1. Why you want to work from office
Ans. 
I believe working from the office allows for better collaboration and communication with colleagues.
• Better collaboration and communication with colleagues

• Opportunity for face-to-face interactions

• Easier access to resources and equipment

• Faster problem-solving through immediate discussions

• Building stronger relationships with team members
Answered by AI
Add your answer
Q2. Why should we hire you
Ans. 
I have the technical skills, experience, and passion for software engineering that make me a valuable asset to your team.
• I have a strong background in computer science and software development

• I have experience working on various software projects and have a proven track record of delivering high-quality code

• I am a quick learner and can adapt to new technologies and programming languages

• I am a team player and can effect...read more
Answered by AI
Add your answer
Q3. Tell any moment when you felt motivated and depressed at same time. etc
Ans. 
Yes
• When I received a promotion at work but also had to deal with the loss of a loved one

• When I achieved a personal goal but also faced criticism from others

• When I received positive feedback on a project but also experienced imposter syndrome
Answered by AI
Add your answer

Q1. Be prepared with your strength and weakness and just be yourself.
Add your answer

1 hr test, simple aptitude questions

Simple coding questions

Q1. Reverse the string
Ans. 
Reverse a given string
• Iterate through the string from end to start and append each character to a new string

• Use built-in functions like reverse() in Python or StringBuilder.reverse() in Java

• Convert the string to an array, reverse the array, and convert it back to a string
Answered by AI
Add your answer
Q2. Basic Networking questions
Add your answer
Q3. Questions on working of jvm
Add your answer

2 questions Based on arrays level of medium

Q1. 2 questions based on array and linked list
Add your answer

Q1. Question based on metrix
Add your answer

Q1. Behavioural questions
Add your answer

Machine learning advantages and disadvantage
hello world hello OWRLD2

Q1. What is u r name
Ans. 
My name is John Doe.
• Full name is John Doe

• Common first and last name combination

• No middle name provided
Answered by AI
Add your answer
Q2. What is salary expectation?
Ans. 
I am looking for a competitive salary based on my skills, experience, and the industry standard.
• Research the average salary for Associate Software Engineers in the industry

• Consider your level of experience and skills when determining your salary expectation

• Be prepared to negotiate based on the company's offer and benefits package
Answered by AI
Add your answer

Aptitude test will a hackerrank test where it might have technical MCQ and/or coding test.

Q1. Interviewer will test your logic building capability with puzzel/coding and technical questions and experience discussion.
Add your answer

Q1. Its a normal discussion with HR about CTC and all.
Add your answer

Round duration - 60 minutes
Round difficulty - Easy

This was a technical round with questions on DBMS.

Q1. What is data integrity?
Ans. 
Data integrity refers to the accuracy, consistency, and reliability of data throughout its lifecycle.
• Data integrity ensures that data is accurate and consistent in storage and transmission.

• It involves maintaining the quality and reliability of data over time.

• Methods for ensuring data integrity include checksums, encryption, and error detection codes.

• Examples of data integrity violations include data corruption, unautho
Answered by AI
Add your answer
Q2. What is a trigger in the context of a database management system?
Ans. 
A trigger is a special type of stored procedure that automatically executes when certain events occur in a database.
• Triggers are used to enforce business rules, maintain data integrity, and automate repetitive tasks.

• They can be triggered by INSERT, UPDATE, or DELETE operations on a table.

• Examples of triggers include auditing changes to a table, updating related tables when a record is modified, or enforcing referential
Answered by AI
Add your answer
Q3. What is the difference between clustered and non-clustered indexes in a database management system?
Ans. 
Clustered indexes physically order the data in the table, while non-clustered indexes do not.
• Clustered indexes determine the physical order of data in the table, while non-clustered indexes do not.

• A table can have only one clustered index, but multiple non-clustered indexes.

• Clustered indexes are faster for retrieval of data, especially range queries, compared to non-clustered indexes.

• Non-clustered indexes are stored se...read more
Answered by AI
Add your answer

Round duration - 60 minutes
Round difficulty - Easy

Technical interview round with questions on DBMS.

Q1. What is the difference between UNION and UNION ALL in SQL?
Ans. 
UNION combines and removes duplicates, UNION ALL combines without removing duplicates.
• UNION merges the result sets of two or more SELECT statements and removes duplicates.

• UNION ALL merges the result sets of two or more SELECT statements without removing duplicates.

• UNION is slower than UNION ALL as it involves removing duplicates.

• Example: SELECT column1 FROM table1 UNION SELECT column1 FROM table2;

• Example: SELECT column...read more
Answered by AI
Add your answer
Q2. What are the functions of a cursor in PL/SQL?
Ans. 
A cursor in PL/SQL is used to retrieve and process multiple rows of data one at a time.
• Allows iteration over a result set

• Retrieves data row by row

• Can be used to update or delete rows in a table

• Must be declared, opened, fetched, and closed
Answered by AI
Add your answer
Q3. Write a SQL query to fetch the nth highest salary from a table.
Ans. 
SQL query to fetch the nth highest salary from a table
• Use the ORDER BY clause to sort salaries in descending order

• Use the LIMIT clause to fetch the nth highest salary
Answered by AI
Add your answer

Round duration - 30 minutes
Round difficulty - Easy

This was a managerial round with typical behavioral problems.