Coredge IO Interview Questions and Answers

Q1. Explain any 1 of your Project.
Add your answer
Q2. SQL: Explain difference between Delete, Truncate and Drop. Difference between Group by and Having. Asked to write a update query.
Add your answer
Q3. Python: Difference between Set and Dictionary. Can we update key in dictionary? Write solution for given python question (nums = [1,2,3,4,5,7,10] target = 9 output = [1,5])
Ans. 
Set is a collection of unique elements, while dictionary is a collection of key-value pairs. Keys in dictionary can be updated.
• Set does not allow duplicate elements, while dictionary allows duplicate values but not duplicate keys.

• Dictionary uses key-value pairs for storing data, while set only stores individual elements.

• Example: Set - {1, 2, 3}, Dictionary - {'a': 1, 'b': 2}

• Yes, keys in dictionary can be updated by ass
Answered by AI
Add your answer

Q1. Explain projects where you have implemented ETL. Difference between aws lambda and aws glue
Add your answer
Q2. Non-Technical questions
Add your answer

Q1. How many EBS can be attached to single EC2
Ans. 
The maximum number of EBS volumes that can be attached to a single EC2 instance is 40.
• Maximum of 40 EBS volumes can be attached to a single EC2 instance

• Each EBS volume can be up to 16 TiB in size

• EBS volumes can be attached and detached while the instance is running
Answered by AI
Add your answer
Q2. Prerequisites for S3 Cross Region Replication
Ans. 
Prerequisites for S3 Cross Region Replication include enabling versioning, configuring IAM roles, and ensuring proper bucket policies.
• Enable versioning on both source and destination buckets

• Configure IAM roles with proper permissions for replication

• Ensure proper bucket policies are in place for cross region replication
Answered by AI
Add your answer
Q3. Docker Restart will change which attributes of comtainer
Ans. 
Docker Restart changes the container's attributes like IP address, hostname, and uptime.
• IP address of the container will change after restart

• Hostname of the container may change

• Uptime of the container will be reset

• Any changes made to the container's filesystem will be lost
Answered by AI
Add your answer
Q4. S3 vs EFS scenario based use cases.
Ans. 
S3 is ideal for storing static files like images and videos, while EFS is better for shared file storage among multiple EC2 instances.
• S3 is object storage, suitable for storing large amounts of unstructured data like images, videos, backups, and logs.

• EFS is a file storage service that can be mounted on multiple EC2 instances, making it ideal for shared file systems and databases.

• Use S3 for static website hosting, data ...read more
Answered by AI
Add your answer
Q5. Linux Commands and Chmod Calculation
Add your answer

Q1. Find a number in array which is greater than left and right element
Ans. 
Iterate through array and check if element is greater than its adjacent elements
• Iterate through array and check if current element is greater than element at index-1 and index+1

• Return the first element found that satisfies the condition

• Handle edge cases where element is at the beginning or end of array
Answered by AI
View 1 more answer
Q2. Find the number in the string and return the sum of numbers
Ans. 
Find and sum numbers in a string
• Iterate through each character in the string

• Check if the character is a digit

• If digit, convert to integer and add to sum
Answered by AI
View 1 more answer

Mintu Babu lives in a smaller house than her brother and in a larger house than her parents. Her children reside with her, and she has no other relatives. If Mintu Babu's relative U lives in a larger house than her relative S, then all the following may be true except: \n\n1) S is U's father \n\n2) S is U's mother \n\n3) U is younger than S \n\n4) S is younger than U

Q1. 1. merge two linked list
Ans. 
Merge two sorted linked lists without creating new nodes by rearranging existing nodes.
• Traverse both linked lists simultaneously

• Compare the values of nodes and rearrange pointers accordingly

• Continue until one of the lists is fully traversed
Answered by AI
Add your answer
Q2. 2. reverse a linked list.
Ans. 
Reverse a linked list by changing the direction of pointers.
• Start with three pointers: current, previous, and next.

• Iterate through the linked list, updating pointers to reverse the direction.

• Update the head of the linked list to be the previous node once iteration is complete.
Answered by AI
Add your answer

Q1. Network concept basics
Add your answer
Q2. Routing protocol,ospf
Add your answer

Q1. Deep knowledge testing in networking domain
Ans. 
Deep knowledge testing in networking domain involves understanding protocols, configurations, security measures, and troubleshooting techniques.
• Understanding various networking protocols such as TCP/IP, DNS, DHCP, etc.

• Knowledge of network configurations including routers, switches, firewalls, etc.

• Understanding network security measures like VPNs, encryption, firewalls, etc.

• Ability to troubleshoot network issues using t
Answered by AI
Add your answer

Q1. Can we perform data driven testing using postman
Ans. 
Yes, Postman supports data driven testing through the use of variables and data files.
• Postman allows users to define variables and use them in requests for data driven testing.

• Data files such as CSV or JSON can be imported into Postman to drive test data.

• Iterations can be set up in Postman to run tests with different data sets.
Answered by AI
Add your answer
Q2. Basic coding questions on integer array missing numbers
Add your answer

Q1. About yourself ?
Add your answer
Q2. Just asked questions on previous role
Add your answer
Q3. How many types of IOT devices are there
Ans. 
There are three main types of IoT devices: consumer, commercial, and industrial.
• Consumer IoT devices: Smart home devices like thermostats, lights, and security cameras.

• Commercial IoT devices: Smart meters, asset tracking systems, and connected vending machines.

• Industrial IoT devices: Sensors and actuators used in manufacturing, agriculture, and healthcare.
Answered by AI
Add your answer

OOPS , DBMS , OS , and DSA concepts

Q1. DBMS related concepts
Add your answer
Q2. Networking and Network Security
Add your answer

Analytical and Problem-Solving Skills:

I was asked to analyze hypothetical business scenarios and propose solutions, demonstrating my ability to identify key issues, prioritize tasks, and recommend strategic actions.


Data Interpretation and Reporting:

Questions focused on my experience with data interpretation, report generation, and using analytical tools like SQL or Excel to derive insights from complex datasets.


Stakeholder Management and Communication:

There were discussions about my previous experiences in stakeholder management and how I effectively communicated with diverse teams to gather requirements and deliver solutions.


Process Improvement and Innovation:

Interviewers were interested in my approach to process improvement and innovation within a business context, including examples of projects where I had successfully implemented changes to optimize workflows or enhance efficiency.