i
Mydbops
Filter interviews by
Top trending discussions
I applied via Campus Placement and was interviewed before Jul 2020. There were 3 interview rounds.
I applied via Company Website and was interviewed before Jan 2020. There were 4 interview rounds.
I applied via Campus Placement and was interviewed before Oct 2020. There were 3 interview rounds.
I applied via Recruitment Consultant and was interviewed in May 2020. There were 4 interview rounds.
MVC is a software architecture pattern that separates an application into three interconnected components: Model, View, and Controller.
Model represents the data and business logic of the application
View is responsible for rendering the user interface
Controller handles user input and updates the model and view accordingly
MVC promotes separation of concerns and modularity
Examples of MVC frameworks include Ruby on Rails,
Web API is for building HTTP services while WCF is for building services that support multiple transport protocols.
Web API is lightweight and ideal for building RESTful services over HTTP.
WCF is a more heavy-duty framework that supports multiple transport protocols like HTTP, TCP, Named Pipes, etc.
Web API is more suited for building services that are consumed by web applications while WCF is more suited for building se...
Session management in ASP.NET
ASP.NET provides in-built session management through HttpSessionState class
Session can be used to store user-specific data across multiple requests
Session can be configured to use different storage options like InProc, StateServer, SQLServer
Session can be accessed using HttpContext.Current.Session property
Session can be secured using SSL, cookieless sessions, and timeout settings
Filters in MVC are used to intercept and modify HTTP requests and responses.
Filters are used to implement cross-cutting concerns like logging, caching, authentication, etc.
There are five types of filters in MVC: Authorization filters, Action filters, Result filters, Exception filters, and Resource filters.
Authorization filters are used to authenticate and authorize users before executing an action.
Action filters are us...
Authentication is verifying the identity of a user, while authorization is granting access to specific resources.
Authentication confirms the identity of a user through credentials such as username and password.
Authorization determines what resources a user can access based on their role or permissions.
Examples of authentication include logging into a website or entering a PIN at an ATM.
Examples of authorization include...
Bootstrap is a popular front-end framework that provides a range of benefits for web development.
Bootstrap offers a responsive grid system that makes it easy to create mobile-friendly websites.
It includes pre-built CSS styles and JavaScript plugins that can save time and effort in development.
Bootstrap is well-documented and has a large community, making it easy to find support and resources.
It is constantly updated to...
Ajax can cause security issues and affect SEO.
Ajax can make a website less accessible to users with slow internet connections.
It can also cause issues with browser history and back button functionality.
Ajax can make it difficult for search engines to crawl and index website content.
Cross-site scripting (XSS) attacks can be carried out through Ajax if proper security measures are not taken.
Functions return a single value while stored procedures execute multiple SQL statements.
Functions can be used in SELECT, WHERE, and HAVING clauses.
Stored procedures can have input and output parameters.
Functions cannot modify the database while stored procedures can.
Functions are deterministic while stored procedures are not necessarily so.
Examples of functions: AVG, COUNT, MAX, MIN, SUM.
Examples of stored procedures:
Aggregate functions perform calculations on a set of values and return a single value.
Common aggregate functions include COUNT, SUM, AVG, MIN, and MAX.
COUNT returns the number of rows in a table or the number of non-null values in a column.
SUM returns the sum of all values in a column.
AVG returns the average of all values in a column.
MIN returns the smallest value in a column.
MAX returns the largest value in a column.
CTE benefits and difference between temp table and table variables
CTE (Common Table Expression) allows for recursive queries and simplifies complex queries
Temp tables are physical tables stored in tempdb and can be indexed and have constraints
Table variables are stored in memory and have limited scope and no statistics
Temp tables are better for large data sets and complex queries, while table variables are better for s
Indexes are data structures that improve the speed of data retrieval operations in a database.
Indexes are created on one or more columns of a table.
Types of indexes include clustered, non-clustered, unique, and full-text indexes.
Clustered indexes determine the physical order of data in a table, while non-clustered indexes create a separate structure to store the index data.
Unique indexes ensure that each value in the i...
I was interviewed before Nov 2020.
Round duration - 360 minutes
Round difficulty - Medium
They give you 6 hr. For 6 question but the good part is that you need to complete atleast 1 question and you are good to go.
Round will be cleared only after attempting one question and rest of the questions are for improving your rank.
You are given an integer array 'ARR' of size 'N' and an integer 'S'. Your task is to find and return a list of all pairs of elements where each sum of a pair equals 'S'.
Find pairs of elements in an array that sum up to a given value, sorted in a specific order.
Iterate through the array and for each element, check if the complement (S - current element) exists in a hash set.
If the complement exists, add the pair to the result list.
Sort the result list based on the criteria mentioned in the problem statement.
You are given the arrival and departure times of N trains at a railway station for a particular day. Your task is to determine the minimum number of pl...
The task is to determine the minimum number of platforms needed at a railway station based on arrival and departure times of trains.
Sort the arrival and departure times in ascending order.
Use two pointers to keep track of overlapping schedules.
Increment platform count when a new train arrives before the previous one departs.
You are given a matrix of 'N' rows and 'M' columns and a non-negative integer 'K'. Determine the minimum possible sum of all elements in each submatrix after performing at m...
Given a matrix and a non-negative integer K, find the minimum possible sum of all elements in each submatrix after performing at most K decrements.
Iterate through all submatrices and find the minimum possible sum after performing decrements
Keep track of the number of decrements performed on each element
Use dynamic programming to optimize the solution
Ensure not to decrease any number below 0
Return the minimum possible s
You are given an array/list CHOCOLATES
of size 'N', where each element represents the number of chocolates in a packet. Your task is to distribute these chocolates among 'M'...
Distribute chocolates among students to minimize the difference between the largest and smallest number of chocolates.
Sort the array of chocolates packets.
Use sliding window technique to find the minimum difference between the largest and smallest packets distributed to students.
Consider edge cases like when number of students is equal to number of packets.
You are given two integers DAY_HOURS
and PARTS
. Consider a day with DAY_HOURS
hours, which can be divided into PARTS
equal parts. Your task is to determine the total ins...
Calculate total instances of equivalent prime groups in a day divided into equal parts.
Divide the day into equal parts and find prime numbers in each part.
Identify prime groups where prime numbers occur at the same position in different parts.
Count the total instances of equivalent prime groups.
Ensure each hour in a prime group is in a different part of the day.
Given a matrix named UNIVERSE
with 3 rows and 'N' columns, filled with characters {#, *, .}, where:
The task is to identify constellations shaped like vowels within a matrix filled with characters {#, *, .}.
Iterate through the matrix to find 3x3 constellations shaped like vowels.
Check for vowels 'A', 'E', 'I', 'O', 'U' in each 3x3 constellation.
Print the vowels found in each constellation for each test case.
Round duration - 20 Minutes
Round difficulty - Easy
Tip 1 : learn basics
Tip 2 : learn any oops language and practice.
Tip 3 : code as much as you can.
Tip 1 : short and precise. Upto the point.
Tip 2 : keep few things aside from resume
I applied via Company Website and was interviewed before Feb 2021. There were 3 interview rounds.
TNQT: TCS National Qualifier Test
posted on 17 Mar 2015
I was interviewed before Sep 2020.
Round duration - 60 minutes
Round difficulty - Easy
It was an aptitude test with maths and English questions
Round duration - 60 minutes
Round difficulty - Easy
It was a face to face interview with one of the TCS employees
Given a Singly Linked List of integers accessible via a head pointer, where each node contains a specific integer value. You are required to determine if a node ...
Given a singly linked list of integers, determine if a specified value exists within the list.
Iterate through the linked list to check if the specified value exists.
Return 1 if the value is found, else return 0.
Handle multiple test cases by looping through each one separately.
Round duration - 60 minutes
Round difficulty - Easy
It was more like an HR+Tech round
Given a sorted array 'A' of 'N' integers, determine whether a number 'X' exists within this array for a series of queries. For each query, print 1 if 'X' exists in the ...
Search for a number in a sorted array and determine its existence for multiple queries.
Iterate through each query integer 'X' and perform binary search on the sorted array 'A' to check for its existence.
Output 1 if 'X' is found in 'A', otherwise output 0.
Ensure to handle multiple test cases as per the given constraints.
Tip 1 : Don't stress too much, you can't finish all the problems
Tip 2 : Talk to the current members of that organization on Linkedin or any college alumni
Tip 1 : Keep it one page
Tip 2 : Focus on your projects
based on 1 interview
Interview experience
Database Engineer
12
salaries
| ₹0 L/yr - ₹0 L/yr |
Associate Database Engineer
9
salaries
| ₹0 L/yr - ₹0 L/yr |
Database Admin
4
salaries
| ₹0 L/yr - ₹0 L/yr |
Principal Software Engineer
4
salaries
| ₹0 L/yr - ₹0 L/yr |
Mysql Database Administrator
4
salaries
| ₹0 L/yr - ₹0 L/yr |
Percona Monitoring and Management
Pythian
DBS Bank
TCS