Filter interviews by
Methods to optimize SQL query performance
Use indexes on columns frequently used in WHERE clauses
Avoid using SELECT * and only retrieve necessary columns
Optimize joins by using appropriate join types (e.g. INNER JOIN, LEFT JOIN)
Use EXPLAIN to analyze query execution plan and identify bottlenecks
Avoid using functions in WHERE clauses as they can prevent index usage
Implementing LDAP, SAML, and SSO involves configuring authentication protocols for secure access.
Set up LDAP server for centralized user authentication and authorization
Configure SAML for single sign-on across multiple applications
Integrate SSO solution like OAuth or OpenID Connect for seamless user experience
I applied via LinkedIn and was interviewed in Sep 2023. There were 3 interview rounds.
Top trending discussions
I was interviewed in Dec 2024.
posted on 15 Mar 2024
I applied via Qspiders and was interviewed in Feb 2024. There were 2 interview rounds.
Aptitude like basic English questions like nouns,pronouns and logical questions
I applied via campus placement at RVR and JC College of Engineering, Guntur and was interviewed before Feb 2022. There were 2 interview rounds.
posted on 30 Oct 2023
I applied via Referral and was interviewed before Oct 2022. There were 2 interview rounds.
VPN stands for Virtual Private Network, a secure connection that allows users to access a private network over a public network.
VPN encrypts data to ensure secure communication over the internet
It allows users to access resources on a private network remotely
Commonly used for remote work, accessing geo-restricted content, and enhancing online privacy
Examples include OpenVPN, Cisco AnyConnect, and NordVPN
DNS stands for Domain Name System, which translates domain names to IP addresses.
DNS is like a phone book for the internet, translating human-readable domain names (like google.com) to IP addresses (like 172.217.3.206).
It helps in locating websites and other resources on the internet.
DNS operates through a distributed database system, with multiple servers around the world.
There are different types of DNS records like ...
Network troubleshooting involves identifying and resolving issues with network connectivity, performance, or security.
Identifying the root cause of network issues
Testing network connectivity using tools like ping or traceroute
Checking network configurations for errors
Analyzing network traffic for abnormalities
Resolving issues with routers, switches, firewalls, or other network devices
DHCP stands for Dynamic Host Configuration Protocol, which is a network management protocol used to assign IP addresses automatically to devices on a network.
Automatically assigns IP addresses to devices on a network
Helps in managing and organizing network resources efficiently
Reduces the need for manual configuration of IP addresses
Uses a lease mechanism to allocate IP addresses for a specific period of time
OSI layers refer to the Open Systems Interconnection model which defines a networking framework to implement protocols in seven layers.
OSI stands for Open Systems Interconnection
There are seven layers in the OSI model: Physical, Data Link, Network, Transport, Session, Presentation, and Application
Each layer has specific functions and communicates with the adjacent layers
Example: Physical layer deals with the physical c...
posted on 19 Nov 2024
Basic aptitude questions and one word answers for SQL
Basics of MySQL questions will be asked
I applied via Referral and was interviewed in Nov 2023. There were 3 interview rounds.
General knowledge test and aptitude test
Interview experience
based on 1 review
Rating in categories
Software Engineer
1.5k
salaries
| ₹15.6 L/yr - ₹42.4 L/yr |
Manager
1.5k
salaries
| ₹13 L/yr - ₹49.2 L/yr |
Software Developer
911
salaries
| ₹13.5 L/yr - ₹40 L/yr |
SAP Abap Consultant
575
salaries
| ₹11.5 L/yr - ₹43.4 L/yr |
Team Lead
566
salaries
| ₹10.5 L/yr - ₹40 L/yr |
Manappuram Finance
Hetero
PVR Inox
Abbott