Tor.ai 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. What is test case
Ans. 
A test case is a set of conditions or variables under which a tester will determine whether a system under test satisfies requirements or works correctly.
• Test case is a detailed procedure that outlines a series of steps to be taken to verify the functionality of a software application.

• It includes input data, expected results, and execution conditions.

• Test cases are designed to cover different scenarios and edge cases t...read more
Answered by AI
Add your answer
Q2. Why do you prefer qa role rather than coding role
Ans. 
I prefer QA role over coding role because I enjoy ensuring quality and finding bugs in software.
• I have a keen eye for detail and enjoy identifying issues in software.

• I like the variety in tasks that QA role offers, such as writing test cases, executing tests, and reporting bugs.

• I find satisfaction in improving the overall quality of a product by catching and fixing bugs before they reach customers.
Answered by AI
Add your answer
Q3. Tell a eg and tell me the test cases that is to be checked in the product
Ans. 
Test cases for an e-commerce website
• Verify that users can successfully add items to their cart

• Check that the correct shipping options are displayed based on user location

• Ensure that the payment gateway is secure and functional

• Test the search functionality to ensure accurate results are returned

• Verify that discounts and promotions are applied correctly
Answered by AI
Add your answer
Q4. Tell the test cases thats been checked for a pen and water bottle
Ans. 
Test cases for a pen and water bottle include functionality, durability, and usability checks.
• Functionality test: Check if the pen writes smoothly and the water bottle opens and closes properly.

• Durability test: Drop the pen and water bottle from a certain height to check for damage.

• Usability test: Check if the pen is comfortable to hold and write with, and if the water bottle is easy to drink from.

• Leak test: Fill the w...read more
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

Q1. Baisc Linux, what is diff b/w linux and Unix
Ans. 
Linux is a free and open-source operating system based on Unix, with some key differences in licensing and development.
• Linux is open-source and freely available, while Unix is a proprietary operating system.

• Linux is developed by a community of developers worldwide, while Unix is developed by various companies.

• Linux has a wider range of distributions (e.g. Ubuntu, Fedora), while Unix has fewer variations (e.g. Solaris, ...read more
Answered by AI
Add your answer
Q2. Databases like Mongodb, sql
Add your answer

Q1. Basic Introduction to company
Add your answer
Q2. What does company do
Ans. 
The company specializes in developing innovative software solutions for various industries.
• Develops software solutions for industries such as healthcare, finance, and retail

• Focuses on creating cutting-edge technology to improve efficiency and productivity

• Provides customized software solutions to meet specific business needs
Answered by AI
Add your answer

Q1. How does you day look like? You roles and responsibilities
Ans. 
My day as a Project Manager involves overseeing project timelines, communicating with team members, and resolving any issues that arise.
• Review project timelines and milestones

• Communicate with team members to ensure tasks are on track

• Hold meetings to discuss progress and address any issues

• Coordinate with stakeholders and clients

• Resolve conflicts and make decisions to keep the project on schedule

• Update project documentat
Answered by AI
Add your answer
Q2. Major challenge you face in your current organization and role
Ans. 
Balancing multiple projects with limited resources and conflicting priorities
• Prioritizing tasks based on deadlines and impact on overall project goals

• Communicating effectively with stakeholders to manage expectations and resources

• Finding creative solutions to resource constraints, such as outsourcing or reallocating tasks

• Utilizing project management tools to track progress and identify potential bottlenecks
Answered by AI
Add your answer

Q1. Generate a Dataframe
Add your answer