Filter interviews by
Clear (1)
Indexes are data structures that improve the speed of data retrieval operations on a database table.
Indexes are created on one or more columns of a table.
They store a copy of the indexed data in a separate structure.
This allows the database to quickly locate the data when a query is executed.
Indexes can be unique or non-unique, clustered or non-clustered.
Creating too many indexes can slow down data modification operati
List is mutable and tuple is immutable in Python.
Lists use square brackets [] while tuples use parentheses ().
Lists can be modified while tuples cannot be modified once created.
Lists are used for collections of homogeneous items while tuples are used for heterogeneous items.
Lists are slower than tuples in terms of performance.
Lists are used for dynamic data while tuples are used for static data.
Use indexing, partitioning, and sharding to handle large datasets in RDBMS.
Create indexes on frequently queried columns to speed up search operations.
Partition tables based on a specific column to distribute data across multiple disks.
Use sharding to horizontally partition data across multiple servers.
Consider using NoSQL databases for unstructured data or when scalability is a concern.
Top trending discussions
I applied via Approached by Company and was interviewed before Apr 2023. There was 1 interview round.
JS fundamentals and coding question , OOPS
Use sorting algorithm like quicksort or mergesort to sort the array with duplicate values.
Use a sorting algorithm like quicksort or mergesort to sort the array efficiently.
Handle duplicate values by ensuring they are placed in the correct order during sorting.
Consider using a hashmap to count the frequency of each element before sorting.
Types of brick, how to check brick quality, Cement IS code and quality check, Pipe IS code
Types of bricks include clay bricks, concrete bricks, fly ash bricks, etc.
To check brick quality, look for uniform shape, size, color, sound when struck, and absence of cracks.
Cement quality is checked using IS code 12269:1987. Quality can be checked by conducting tests like fineness, setting time, compressive strength, etc.
Pipe q...
I applied via Walk-in and was interviewed before Dec 2023. There were 3 interview rounds.
I applied via Naukri.com and was interviewed in Feb 2021. There were 3 interview rounds.
posted on 3 Nov 2021
Testing for oil leakage in transformers involves visual inspection, oil analysis, and pressure testing.
Visual inspection of the transformer for any signs of oil leakage
Oil analysis to check for any abnormal levels of dissolved gases or contaminants
Pressure testing to check for any leaks in the transformer's oil-filled compartments
Use of ultrasonic testing to detect any leaks in the transformer's tank
Regular maintenance
I will conduct a thorough testing and inspection process to identify any errors in the Feeder.
Perform visual inspection of the Feeder
Conduct electrical testing to ensure proper functioning
Check for any loose connections or damaged components
Compare the Feeder's performance to the expected results
Review any error logs or system alerts
Consult with colleagues or experts for additional input
I applied via Company Website and was interviewed in Apr 2023. There were 3 interview rounds.
General SSC level aptitude
posted on 2 May 2024
I applied via Approached by Company and was interviewed in Apr 2024. There was 1 interview round.
I applied via Recruitment Consultant and was interviewed in Aug 2021. There were 3 interview rounds.
Associate
229
salaries
| ₹0 L/yr - ₹0 L/yr |
Analyst
174
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Associate
135
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Analyst
123
salaries
| ₹0 L/yr - ₹0 L/yr |
Campaign Manager
85
salaries
| ₹0 L/yr - ₹0 L/yr |
Aam Aadmi Party
Bharatiya Janata Party
Indian National Congress
Bahujan Samaj Party