Geecon Global Software Trainee Interview Questions and Answers

Q1. What are the different sizes available for a virtual warehouse in Snowflake, and which sizes are currently being utilized in your current project?
Add your answer
Q2. What are stored procedures in Snowflake, and how did you utilize them?
Add your answer

Q1. How did you verify the data after transferring it from one database to another?
Add your answer
Q2. What are the different types of duplicate checks that can be performed using SQL queries?
Add your answer

Q1. Are you open to relocating to Hyderabad?
Add your answer
Q2. What information do you have about ValueLabs?
Add your answer

It contain 40 question which is very easy

It contain 3 coding question

Q1. Introduction About Your Self and About Project
Add your answer
Q2. Two dsa question of leetcode
Add your answer
Q3. Basics Concept on dsa
Add your answer
Q4. From which platform you do coding
Add your answer
Q5. Simple Simple Question
Add your answer

Aptitude, core concepts and a code

Q1. What is the one thing you learnt from college club?
Ans. 
I learned the importance of teamwork and collaboration from my college club.
• Developed strong communication skills by working with diverse group of individuals

• Learned how to delegate tasks effectively to achieve common goals

• Gained experience in problem-solving and conflict resolution through group projects
Answered by AI
Add your answer
Q2. What is the one thing you want to expereince?
Ans. 
I want to experience living in a different country and immersing myself in a new culture.
• Traveling to a foreign country and learning about their customs and traditions

• Trying new foods and experiencing different ways of life

• Making friends with locals and exploring the local attractions
Answered by AI
Add your answer

Q1. Difference between relational and non relational dbms
Ans. 
Relational DBMS stores data in tables with predefined relationships, while non-relational DBMS stores data in flexible, schema-less formats.
• Relational DBMS uses structured query language (SQL) for querying data

• Non-relational DBMS can store data in various formats like key-value pairs, document-based, graph databases

• Relational DBMS ensures data integrity through normalization and constraints

• Non-relational DBMS offers be...read more
Answered by AI
Add your answer
Q2. Difference betweeen class,abstract class,interface in python
Ans. 
Class is a blueprint for creating objects, abstract class cannot be instantiated and can have abstract methods, interface is a contract for classes to implement certain methods.
• Class is a blueprint for creating objects with attributes and methods.

• Abstract class cannot be instantiated and can have abstract methods that must be implemented by subclasses.

• Interface is a contract for classes to implement certain methods, bu
Answered by AI
Add your answer
Q3. Project related questions were asked
Add your answer

Basic DSA from the hacker rank website

Q1. Basic to medium questions on javascript, nodejs, MySQL joints, html5 tags
Add your answer

Q1. Real life problems, Use cases
Add your answer

Q1. Difference between Scheduled script and Map reduce script?
Ans. 
Scheduled script runs on a predefined schedule, while Map reduce script processes large datasets in parallel.
• Scheduled script is used for automating tasks at specific times, like sending reports daily at 8am.

• Map reduce script is used for processing large datasets by splitting them into smaller chunks and processing them in parallel.

• Scheduled script is typically used for routine tasks, while Map reduce script is used fo...read more
Answered by AI
Add your answer
Q2. Types of scripts in NetSuite.
Ans. 
Types of scripts in NetSuite include SuiteScript, SuiteTalk, SuiteFlow, and SuiteBuilder.
• SuiteScript: JavaScript-based scripts for customizing NetSuite functionality.

• SuiteTalk: Web services integration for connecting NetSuite with external systems.

• SuiteFlow: Visual workflow tool for automating business processes.

• SuiteBuilder: Customization tool for modifying NetSuite forms, fields, and records.
Answered by AI
Add your answer

Technology advantage or not

All aptitude topics,logical reasoning

Q1. Oops,2 coding questions
Add your answer
Q2. Palindrome,even number
Add your answer

Q1. What do you know
Add your answer
Q2. Do you have any questions
Add your answer

Q1. What is Dependency Injection?
Ans. 
Dependency Injection is a design pattern in which components are given their dependencies rather than creating them internally.
• Allows for easier testing by providing mock dependencies

• Promotes loose coupling between components

• Improves code reusability and maintainability

• Examples: Constructor injection, Setter injection, Interface injection
Answered by AI
Add your answer
Q2. How to handle exception in java
Ans. 
In Java, exceptions can be handled using try-catch blocks to catch and handle specific exceptions.
• Use try-catch blocks to catch exceptions and handle them gracefully

• Use multiple catch blocks to handle different types of exceptions

• Use finally block to execute code regardless of whether an exception is thrown or not

• Throw custom exceptions using throw keyword
Answered by AI
Add your answer

Q1. In Java8, different between flatmap and map
Ans. 
map transforms each element in a stream, while flatMap transforms each element into multiple elements
• map applies a function to each element in a stream and returns a new stream of the results

• flatMap applies a function that returns a stream for each element in the original stream, then flattens the streams into a single stream

• Example: map - stream.map(x -> x * x), flatMap - stream.flatMap(str -> Arrays.stream(str.split(
Answered by AI
Add your answer
Q2. How to handle the ConcureentModificationException
Ans. 
ConcurrentModificationException occurs when a collection is modified while iterating over it.
• Use Iterator to iterate over the collection instead of foreach loop.

• If modification is necessary, use Iterator's remove() method instead of collection's remove() method.

• Consider using synchronized collections or ConcurrentHashMap to avoid ConcurrentModificationException.
Answered by AI
Add your answer