Filter interviews by
I was interviewed in Oct 2022.
Replication performance issues can arise due to network latency, hardware limitations, and inefficient queries.
Network latency can cause delays in replication, leading to slower performance.
Hardware limitations such as insufficient memory or slow disk speeds can also impact replication performance.
Inefficient queries can cause replication to lag behind, leading to slower performance.
Monitoring replication lag and optim...
I was interviewed in Dec 2024.
I applied via Campus Placement and was interviewed in Sep 2024. There was 1 interview round.
I am a Cloud Engineer with a strong background in designing, implementing, and managing cloud infrastructure.
Experienced in working with AWS, Azure, and Google Cloud Platform
Skilled in automating tasks using tools like Terraform and Ansible
Proficient in monitoring and optimizing cloud resources for cost efficiency
Strong understanding of networking and security principles in cloud environments
Query to find employees with middle name 'Mohan' and salary over 2 lac.
Use SELECT statement to retrieve data from employee table
Use WHERE clause to filter employees with middle name 'Mohan' and salary over 2 lac
Example: SELECT * FROM employee WHERE middle_name = 'Mohan' AND salary > 200000
A program to convert a string into uppercase and lowercase.
Use built-in functions like toUpperCase() and toLowerCase() to convert the string.
Iterate through each character of the string and convert it to uppercase or lowercase accordingly.
Ensure to handle special characters and spaces appropriately.
Count common elements in two lists
Iterate through both lists and count occurrences of each element
Use a dictionary to store counts of elements in both lists
Return the common elements and their counts
Developed a cloud-based data analytics platform using Python and AWS services
Used AWS Lambda functions for serverless computing
Implemented data processing pipelines with AWS Glue and S3
Utilized Python libraries like Pandas and NumPy for data analysis
I have used various services in GCP including BigQuery, Dataflow, Cloud Storage, and Pub/Sub.
BigQuery for data warehousing and analytics
Dataflow for data processing and ETL
Cloud Storage for storing and accessing data
Pub/Sub for messaging and event-driven architectures
Data pipelines in GCP can be created using various tools like Dataflow, Dataproc, and Cloud Composer.
Choose the appropriate tool based on the use case and data volume
Define the data source and destination
Create a pipeline using the chosen tool and define the data transformations
Test and deploy the pipeline
Monitor and troubleshoot the pipeline for any issues
Real-time data services can be used to migrate datawarehouse with GCP services.
Use Cloud Dataflow to ingest and transform data in real-time
Use Cloud Pub/Sub to stream data to BigQuery or Cloud Storage
Use Cloud Dataproc to process data in real-time
Use Cloud Composer to orchestrate data pipelines
Use Cloud Spanner for real-time transactional data
Use Cloud SQL for real-time relational data
Use Cloud Bigtable for real-time N
66degrees interview questions for popular designations
Top trending discussions
The function checks if a string is a substring of another string.
Use the built-in string methods like 'indexOf' or 'includes' to check for substring.
If the language supports regular expressions, you can also use them to find substrings.
Consider the case sensitivity of the strings when comparing.
Code to multiply two matrices of dimension M*N and N*K.
Create a result matrix of dimension M*K.
Iterate through each row of the first matrix.
For each row, iterate through each column of the second matrix.
For each element in the row of the first matrix, multiply it with the corresponding element in the column of the second matrix.
Sum up the products and store the result in the corresponding position of the result matrix.
...
SQL query to perform matrix multiplication using two tables with row, col, and value columns.
Use JOIN operation to combine the two tables based on matching row and col values.
Use GROUP BY clause to group the result by row and col values.
Use SUM function to calculate the dot product of corresponding row and col values.
Use INSERT INTO statement to insert the result into a new table.
Prototype in JavaScript is an object that is associated with every function and object by default.
Prototype is used to add properties and methods to an object.
It allows objects to inherit properties and methods from other objects.
Modifying the prototype of a function affects all instances of that function.
Prototypes can be used to create new objects based on existing objects.
The prototype chain allows for property and
Classes in JavaScript are written using the class keyword.
Use the class keyword followed by the class name to define a class.
Use the constructor method to initialize class properties.
Add methods to the class using the class prototype.
Use the new keyword to create an instance of the class.
The number of different ways to climb a ladder of N steps by taking 1 or 2 steps at a time.
This is a classic problem that can be solved using dynamic programming.
The number of ways to climb N steps is equal to the sum of the number of ways to climb N-1 steps and N-2 steps.
The base cases are when N is 0 or 1, where there is only 1 way to climb the ladder.
For example, for N=4, there are 5 different ways: [1, 1, 1, 1], [1
Print a square matrix in spiral order
Start by defining the boundaries of the matrix
Iterate through the matrix in a spiral pattern, printing each element
Adjust the boundaries after each iteration to move inward
Repeat until all elements are printed
Retrieve the second highest marks obtained by each student from a table with student name, subject, and marks.
Use the RANK() function to assign a rank to each row based on the marks in descending order.
Filter the result to only include rows with rank 2 for each student.
Group the result by student name to get the second highest marks for each student.
The .live() method attaches an event handler to the current and future elements, while .delegate() attaches an event handler to a parent element.
The .live() method is deprecated in newer versions of jQuery.
The .delegate() method is preferred over .live() for performance reasons.
Both methods are used to handle events for dynamically added elements.
Example: $(document).live('click', 'button', function() { ... });
Example:...
Chaining in jQuery allows multiple methods to be called on a single element in a single line of code.
Chaining simplifies code and improves readability.
Each method in the chain operates on the result of the previous method.
The chain ends with a method that does not return a jQuery object.
Example: $('div').addClass('highlight').fadeOut();
A callback function is a function that is passed as an argument to another function and is executed later.
Callback functions are commonly used in event-driven programming.
They allow asynchronous execution of code.
Callback functions can be used to handle responses from APIs or user interactions.
They can be anonymous functions or named functions.
Example: setTimeout(function() { console.log('Hello!'); }, 1000);
The .bind() function in jQuery is used to attach an event handler function to one or more elements.
It allows you to specify the event type and the function to be executed when the event occurs.
The .bind() function can be used to bind multiple events to the same element.
It can also be used to pass additional data to the event handler function.
The .bind() function is deprecated in jQuery version 3.0 and above. It is reco
The angle between the hour and minute hands of a clock can be calculated using a formula.
The hour hand moves 30 degrees per hour and 0.5 degrees per minute.
The minute hand moves 6 degrees per minute.
Calculate the angle between the two hands using the formula: |30H - 11M/2|, where H is the hour and M is the minute.
Yes, it is possible to create a slideshow without using JavaScript.
Use CSS animations and transitions to create the slideshow.
Use HTML and CSS to structure and style the slideshow.
Utilize keyframe animations to create the slide transitions.
Use radio buttons or checkboxes to control the slideshow navigation.
Apply the :target pseudo-class to create a simple slideshow without JavaScript.
The men can take turns riding the scooter, allowing them to reach point B faster.
The men can form a queue and take turns riding the scooter.
The person riding the scooter can drop it off at a certain point and the next person can pick it up.
The scooter can be passed along the line of men until everyone reaches point B.
I applied via Job Portal and was interviewed in Jul 2024. There was 1 interview round.
There is a question based on Rest API and another question on Java
Multithreading is the ability of a program to perform multiple tasks concurrently.
Multithreading allows for better utilization of CPU resources
It can improve program performance and responsiveness
Examples include running multiple downloads simultaneously or updating a GUI while performing a background task
Synchronization is important to prevent race conditions and ensure thread safety
Multithreading in Java allows concurrent execution of multiple threads.
Java provides built-in support for multithreading through the java.lang.Thread class.
Threads can be created by extending the Thread class or implementing the Runnable interface.
The start() method is used to start a new thread, which calls the run() method.
Synchronization mechanisms like synchronized blocks and locks can be used to control access to ...
No, Java does not support multiple inheritance. However, interfaces can inherit multiple interfaces.
Java does not allow a class to inherit from multiple classes.
This is because multiple inheritance can lead to ambiguity and conflicts.
However, a class can implement multiple interfaces in Java.
An interface can extend multiple interfaces, allowing for inheritance of multiple interfaces.
This is known as interface inheritan
DO-WHILE loop executes the code block at least once, while WHILE loop executes only if the condition is true.
DO-WHILE loop checks the condition at the end of the loop
WHILE loop checks the condition at the beginning of the loop
DO-WHILE loop executes the code block at least once
WHILE loop may not execute the code block at all if the condition is false
I would rate myself as an 8 on a scale of 1-10.
I have a strong understanding of software development principles and practices.
I have experience working with multiple programming languages and frameworks.
I am skilled in problem-solving and debugging.
I have successfully delivered complex software projects in the past.
I continuously strive to learn and improve my skills.
Display data of two tables by joining them using a common column.
Use SQL JOIN statement to combine data from two tables based on a common column.
Choose the appropriate type of JOIN based on the relationship between the tables.
Specify the columns to be displayed in the SELECT statement.
Use aliases to differentiate between columns with the same name in both tables.
Apply any necessary filters or sorting to the result set.
Networking refers to the process of connecting devices and systems to share information and resources.
Networking involves the use of hardware and software to connect devices and systems.
It allows for the sharing of information and resources such as files, printers, and internet access.
Networking can be done through wired or wireless connections.
Examples of networking technologies include Ethernet, Wi-Fi, and Bluetooth.
...
A router is a networking device that forwards data packets between computer networks.
A router operates at the network layer of the OSI model.
It uses routing tables to determine the best path for data packets to reach their destination.
Routers can connect multiple networks together, such as LANs and WANs.
They provide network address translation (NAT) to allow multiple devices to share a single public IP address.
Routers ...
Subnetting is the process of dividing a network into smaller subnetworks, called subnets, to improve network efficiency and security.
Subnetting allows for better utilization of IP addresses by dividing a network into smaller segments.
It helps in improving network performance by reducing network congestion.
Subnetting enhances network security by isolating different departments or devices within a network.
It enables effi...
Protocols are a set of rules and guidelines that govern the communication between devices or systems.
Protocols define the format and order of messages exchanged between devices.
They ensure reliable and efficient communication by specifying error detection and correction mechanisms.
Examples of protocols include TCP/IP, HTTP, SMTP, and FTP.
Protocols can operate at different layers of the network stack, such as the applic
Static protocols are fixed and do not change, while dynamic protocols can adapt to changing network conditions.
Static protocols are typically used in simple networks with predictable traffic patterns.
Dynamic protocols are used in complex networks with varying traffic patterns.
Examples of static protocols include ARP and RARP.
Examples of dynamic protocols include OSPF and BGP.
TCS is a leading global IT services company with a strong reputation and diverse opportunities for growth.
TCS has a strong reputation in the IT industry for delivering high-quality services and solutions.
TCS offers diverse opportunities for growth and career development.
TCS has a global presence, providing exposure to different cultures and working environments.
TCS values innovation and encourages employees to think cr...
I expect to receive proper training and support to transition into the IT field successfully.
I expect to be provided with relevant training and resources to learn the necessary skills for the role.
I hope for guidance and mentorship from experienced IT professionals within the company.
I am eager to contribute my non-IT skills and knowledge to the team, bringing a fresh perspective.
I am committed to putting in the effort...
Multithreading is the ability of a program to perform multiple tasks concurrently.
Multithreading allows for better utilization of CPU resources
It can improve program performance and responsiveness
Examples include running multiple downloads simultaneously or updating a GUI while performing a background task
Synchronization is important to prevent race conditions and ensure thread safety
Java supports multithreading through the java.lang.Thread class and java.util.concurrent package.
Java threads are created by extending the Thread class or implementing the Runnable interface.
Threads can be started using the start() method.
Synchronization can be achieved using synchronized keyword or locks.
Java provides several classes and interfaces to support concurrent programming such as Executor, ExecutorService, F...
Java does not support multiple inheritance, but interfaces can inherit multiple interfaces.
Java does not allow a class to inherit from multiple classes, but it can implement multiple interfaces.
Interfaces can inherit from multiple interfaces using the 'extends' keyword.
For example, interface C can extend interfaces A and B: 'interface C extends A, B {}'
Do-While loop executes the code block once before checking the condition, while loop checks the condition first.
Do-While loop is used when the code block needs to be executed at least once.
While loop is used when the code block may not need to be executed at all.
Do-While loop is less efficient than While loop as it always executes the code block at least once.
Example of Do-While loop: do { //code block } while (conditi...
Join the tables on a common column and display the combined data.
Identify the common column in both tables
Use JOIN statement to combine the tables
Select the columns to display
Apply any necessary filters or sorting
Display the data in a table or list format
Primary key uniquely identifies a record in a table, while unique key ensures uniqueness of a column.
Primary key cannot have null values, while unique key can have one null value.
A table can have only one primary key, but multiple unique keys.
Primary key is used as a foreign key in other tables, while unique key is not.
Example: Employee ID can be a primary key, while email address can be a unique key.
I have a strong background in software development, excellent problem-solving skills, and a passion for learning new technologies.
Extensive experience in programming languages such as Java, Python, and C++
Proven track record of delivering high-quality software solutions on time and within budget
Strong analytical and problem-solving skills, with the ability to quickly adapt to new technologies and frameworks
Excellent co...
Some of the top questions asked at the 66degrees interview -
based on 5 interviews
Interview experience
based on 21 reviews
Rating in categories
QA Engineer
5
salaries
| ₹0 L/yr - ₹0 L/yr |
Data Engineer
5
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Cloud Engineer
5
salaries
| ₹0 L/yr - ₹0 L/yr |
Engineering Manager
4
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Software Engineer
4
salaries
| ₹0 L/yr - ₹0 L/yr |
MakeMyTrip
Yatra
Cleartrip
Goibibo