i
Northcorp Software
Filter interviews by
A primary key in a database is a unique identifier for each record in a table.
Primary key ensures each record in a table is unique
It can consist of one or multiple columns
Primary key values cannot be NULL
Example: 'ID' column in a 'Users' table
Top trending discussions
posted on 7 Dec 2024
I applied via Walk-in and was interviewed in Nov 2024. There were 2 interview rounds.
Questions on string and arrays both are moderate level questions on hacherrank type for 20 marks
2 questions solve on paper
I applied via LinkedIn and was interviewed in Apr 2024. There were 2 interview rounds.
Q.1 Pattern
1
*2*
**3**
Q. 2
write code to get sub array with max sum from given array.
posted on 8 Aug 2024
I applied via Naukri.com and was interviewed in Jul 2024. There was 1 interview round.
I applied via Naukri.com and was interviewed before Apr 2023. There were 3 interview rounds.
Developed various products including web applications, APIs, and data analysis tools.
Created a web application for tracking sales data using Django framework
Built RESTful APIs for mobile applications using Flask
Developed data analysis tools using pandas and numpy libraries
I applied via LinkedIn and was interviewed before Apr 2023. There were 2 interview rounds.
posted on 14 Apr 2024
Basic aptitude round
I appeared for an interview before Mar 2024.
Faced a challenge with database performance, optimized queries, and implemented caching to enhance response times significantly.
Identified slow queries using profiling tools like EXPLAIN in SQL.
Refactored complex joins into simpler queries to reduce execution time.
Implemented Redis caching for frequently accessed data, reducing database load.
Monitored performance metrics post-implementation to ensure improvements.
Ensuring backend security and scalability involves implementing best practices in architecture, coding, and infrastructure management.
Implement authentication and authorization mechanisms (e.g., OAuth, JWT) to secure APIs.
Use HTTPS to encrypt data in transit and protect against man-in-the-middle attacks.
Regularly update dependencies and libraries to patch known vulnerabilities.
Employ rate limiting and throttling to pre...
I optimize databases by analyzing queries, indexing, and using caching strategies to enhance performance in large-scale applications.
Analyze slow queries using tools like EXPLAIN to identify bottlenecks.
Implement indexing on frequently queried columns to speed up data retrieval.
Use caching mechanisms (e.g., Redis, Memcached) to reduce database load.
Partition large tables to improve query performance and manageability.
O...
based on 1 interview
Interview experience
based on 1 review
Rating in categories
Software Developer
10
salaries
| ₹2 L/yr - ₹7.2 L/yr |
Devops Engineer
9
salaries
| ₹1.5 L/yr - ₹3.6 L/yr |
Data Scientist
8
salaries
| ₹1.8 L/yr - ₹7.2 L/yr |
Senior Java Developer
6
salaries
| ₹14 L/yr - ₹22 L/yr |
Software Engineer
5
salaries
| ₹1 L/yr - ₹11.2 L/yr |
Accel Frontline
Elentec Power India (EPI) Pvt. Ltd.
HyScaler
Pitney Bowes