SoftDEL Systems 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. Some questions related to APIs/Postman.
Add your answer
Q2. Some questions related to stakeholder management.
Add your answer
Q3. Some easy questions related to SQL
Add your answer

Q1. What are some key traits that an implementation analyst must have?
Add your answer
Q2. Explain about your previous experience
Add your answer

Q1. Have you ever mentored someone and have you ever led a team?
Add your answer
Q2. How many micro-services you've worked with in a single project?
Add your answer
Q3. How do you communicate among your team?
Add your answer

Consisted of HTML , Javascript, React coding questions

Q1. Theroitacal qestions on Javascript
Add your answer
Q2. Code absed questions
Add your answer

Q1. How does a cell communicates between 2 sites.
Ans. 
Cells communicate between 2 sites through various signaling pathways, including direct cell-to-cell contact and chemical signaling.
• Cells can communicate through direct cell-to-cell contact, such as gap junctions or cell adhesion molecules.

• Cells can also communicate through chemical signaling, such as paracrine signaling (local signaling) or endocrine signaling (long-distance signaling).

• Examples include neurotransmitter...read more
Answered by AI
Add your answer
Q2. L3 layer details
Add your answer

Q1. DSA problem to find the count of characters in a string
Ans. 
Use a hashmap to count the occurrences of each character in the string.
• Create a hashmap to store character counts

• Iterate through the string and update counts in the hashmap

• Return the hashmap with character counts
Answered by AI
Add your answer
Q2. VOiP related questions
Add your 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