GoComet Software Developer Intern Interview Questions and Answers

70 questions in 90 minutes with 7 sections

Q1. Introduce yourself
Add your answer
Q2. Project description
Ans. 
Developed a web application for tracking project progress and managing tasks
• Used React.js for front-end development

• Implemented RESTful APIs using Node.js and Express for back-end

• Utilized MongoDB for database storage

• Incorporated authentication and authorization features for user security
Answered by AI
Add your answer
Q3. Second highest salary
Ans. 
To find the second highest salary in a table, you can use a SQL query with the MAX() function and a subquery.
• Use a SQL query to select the MAX() salary from the table.

• Use a subquery to select the MAX() salary that is less than the overall MAX() salary.

• Combine both queries to get the second highest salary.
Answered by AI
Add your answer
Q4. What is indexing
Ans. 
Indexing is a technique used to optimize the performance of databases by creating a data structure that allows for quick retrieval of data.
• Indexing involves creating a data structure that maps the values of specific columns in a database table to their physical location on disk.

• It helps in speeding up data retrieval operations by allowing the database to quickly locate the rows that match a certain condition.

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

Q1. Introduce yourself
Ans. 
I am a passionate software developer with experience in Java, Python, and web development.
• Experienced in Java, Python, and web development technologies

• Strong problem-solving skills

• Team player with excellent communication skills
Answered by AI
Add your answer
Q2. Project description
Ans. 
Developed a web application for tracking project progress and managing tasks
• Used React.js for front-end development

• Implemented RESTful APIs using Node.js and Express for back-end

• Utilized MongoDB for database storage

• Incorporated authentication and authorization features for user security
Answered by AI
Add your answer
Q3. Difference between truncate and delete
Ans. 
Truncate is a DDL command that removes all records from a table, while delete is a DML command that removes specific records.
• Truncate is faster than delete as it does not log individual row deletions.

• Truncate resets the identity seed of the table, while delete does not.

• Truncate cannot be rolled back, while delete can be rolled back using a transaction.

• Truncate does not fire triggers, while delete does.
Answered by AI
Add your answer

Q1. Why you join company
Add your answer
Q2. Where you see yourself after 5 years
Ans. 
In 5 years, I see myself as a senior software developer leading a team and working on cutting-edge technologies.
• Leading a team of developers on innovative projects

• Continuing to enhance my technical skills and knowledge

• Contributing to the growth and success of the company

• Possibly pursuing further education or certifications in software development
Answered by AI
Add your answer

Q1. Jump Game - II
Add your answer
Q2. Number of Island
Ans. 
Count the number of islands in a given grid of '1's and '0's.
• Iterate through the grid and for each '1' encountered, perform a depth-first search to mark all connected '1's as visited.

• Increment the island count for each new island encountered.

• Consider edge cases like grid boundaries and handling visited cells.
Answered by AI
Add your answer

Q1. Questions on Django middleware, models and queries
Add your answer

Q1. Design an algorithm to efficiently to send office bus to all location in the city
Ans. 
Use a greedy algorithm to send the office bus to all locations in the city efficiently.
• Start from the office location and pick the nearest location to visit next.

• Continue picking the nearest unvisited location until all locations are covered.

• Repeat the process until all locations are visited.

• Consider using Dijkstra's algorithm or a similar approach for finding the nearest location.

• Optimize the route by considering traf
Answered by AI
Add your answer

Q1. Round with CTO, mostly behavioural and expected pay
Add your answer

The exam duration is one and a half hours.

The total exam time is one and a half hours.

It encompasses all topics related to full stack development.

Q1. Asks questions on SQL
Add your answer
Q2. Asks question in typical topics
Add your answer

Q1. Where do you see yourself in two years?
Ans. 
In two years, I see myself as a senior software developer leading a team on innovative projects.
• Advancing to a senior software developer role

• Leading a team on new and innovative projects

• Continuing to enhance my technical skills through ongoing learning and training
Answered by AI
Add your answer

Q1. Tell what is your name
Ans. 
My name is John Smith.
• Full name is John Smith

• Common name in English-speaking countries

• No middle name or initial
Answered by AI
Add your answer
Q2. What do you do in free time
Ans. 
In my free time, I enjoy hiking, playing video games, and learning new programming languages.
• Hiking in local trails and national parks

• Playing video games like Overwatch and Minecraft

• Learning new programming languages like Python and JavaScript
Answered by AI
Add your answer

The basic questions asked in an interview .

DP, graph, and array questions asked in 2nd round also asked my company project

Q1. Angular18 updates`
Add your answer
Q2. Angular Ivy features
Add your answer
Q3. Dif between var, let, const
Ans. 
var is function scoped, let is block scoped, const is block scoped and cannot be reassigned.
• var is function scoped, let is block scoped, const is block scoped and cannot be reassigned

• var can be redeclared and updated, let can be updated but not redeclared, const cannot be redeclared or updated

• Example: var x = 10; let y = 20; const z = 30;
Answered by AI
Add your answer
Q4. What is Closure
Ans. 
Closure is a function that captures the variables from its surrounding scope, even after the surrounding function has finished executing.
• Closure allows a function to access and manipulate variables from its outer scope.

• It maintains a reference to its outer scope, even after the outer function has returned.

• Closure is commonly used in event handlers and callbacks.
Answered by AI
Add your answer
Q5. Dependency injection
Add your answer
Q6. Rxjs operators used
Ans. 
Rxjs operators are used for handling asynchronous operations in reactive programming.
• Map operator: transforms the items emitted by an Observable

• Filter operator: emits only those items from an Observable that pass a specified condition

• Merge operator: combines multiple Observables into one by merging their emissions

• SwitchMap operator: switches to a new Observable each time it is emitted

• DebounceTime operator: emits a valu...read more
Answered by AI
Add your answer
Q7. Change detection strategy in Angular
Ans. 
Change detection strategy in Angular is a mechanism used to detect changes in the application state and update the view accordingly.
• Angular uses Zone.js for change detection by default

• Change detection can be triggered manually using ChangeDetectorRef

• Optimizing change detection using OnPush strategy
Answered by AI
Add your answer