AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Filter interviews by
Media.net Software Services (India) Database Developer Interview Questions and Answers
Media.net Software Services (India) Database Developer Interview Experiences
2 interviews found
Anonymous
Selected
I applied via Referral and was interviewed in Aug 2024. There were 2 interview rounds.
(2 Questions)
- Q1. Second highest Salary
- Ans.
To find the second highest salary in a database table, you can use a SQL query with the ORDER BY and LIMIT clauses.
Use a SQL query with ORDER BY clause to sort the salaries in descending order.
Use LIMIT 1,1 to retrieve the second highest salary.
Example: SELECT salary FROM employees ORDER BY salary DESC LIMIT 1,1;
- Q2. Left and right join explanation
- Ans.
Left join includes all records from the left table and matching records from the right table. Right join includes all records from the right table and matching records from the left table.
Left join: Returns all records from the left table and the matched records from the right table.
Right join: Returns all records from the right table and the matched records from the left table.
Example: Left join - SELECT * FROM table1...
(2 Questions)
- Q1. Question on Binary Search tree
- Q2. One easy array question
Interview Preparation Tips
Skills evaluated in this interview
Selected
I applied via Approached by Company and was interviewed before May 2023. There was 1 interview round.
(3 Questions)
- Q1. Whar are the different forms of normalization?
- Ans.
Normalization is a process used to organize a database into tables and columns to reduce redundancy and improve data integrity.
First Normal Form (1NF) - Eliminates duplicate data by ensuring each column contains atomic values.
Second Normal Form (2NF) - Requires that each non-key attribute is fully functionally dependent on the primary key.
Third Normal Form (3NF) - Ensures that non-key attributes are not transitively de...
- Q2. What are indexes and how indexing is useful?
- Ans.
Indexes in databases are data structures that improve the speed of data retrieval operations.
Indexes are data structures that store a small portion of the table data in an optimized format for quick retrieval.
They help in speeding up data retrieval operations such as SELECT queries by reducing the number of rows that need to be scanned.
Indexes can be created on one or more columns of a table to improve the performance ...
- Q3. Some logical mathematical questions!
Interview Preparation Tips
- SQL
- RDBMS
- Normalization
- Indexing
- Logical reasoning
Top trending discussions
Interview questions from similar companies
I applied via Naukri.com and was interviewed before Apr 2020. There were 5 interview rounds.
Interview Questionnaire
2 Questions
- Q1. Joins,bulk collect, procedure, function
- Q2. Write a procedure with bulk collect
- Ans.
Procedure with bulk collect for array of strings
Use FORALL statement for efficient processing
Declare a collection type
Use LIMIT clause to control memory usage
Interview Preparation Tips
Interview Questionnaire
2 Questions
- Q1. Core python
- Q2. OOPS concept
(4 Questions)
- Q1. Basic JavaScript and React.js questions
- Q2. Questions on functions, hooks and DOM
- Q3. Questions on SSR
- Q4. Questions on strings and arrays
Api related questions
I applied via Naukri.com and was interviewed before Oct 2021. There were 2 interview rounds.
(1 Question)
- Q1. They are asking technical questions what is their in the resume
(1 Question)
- Q1. They will technical questions as per your resume what you mentioned
Interview Preparation Tips
Selected
I applied via Naukri.com and was interviewed in Apr 2024. There were 3 interview rounds.
(1 Question)
- Q1. It was all about java oops and basic questions
(1 Question)
- Q1. It will related to the our project and some scenario based questions
(1 Question)
- Q1. Salary discussion
I applied via Campus Placement and was interviewed in Aug 2023. There was 1 interview round.
(5 Questions)
- Q1. Easy-Medium level Leetcode questions on linkedlists
- Q2. Simple recursion question
- Q3. An SQL query Basic question in OOPS and resume description..
- Q4. Basic questions regarding SQL
- Q5. Difference between thread and process
- Ans.
A process is an instance of a program while a thread is a subset of a process that can run concurrently with other threads.
Processes have their own memory space while threads share the same memory space within a process.
Processes are independent of each other while threads within the same process can communicate with each other.
Processes are heavier in terms of resource consumption compared to threads.
Example: A web br...
Interview Preparation Tips
Skills evaluated in this interview
Selected
I applied via LinkedIn and was interviewed before Apr 2023. There was 1 interview round.
(1 Question)
- Q1. Prepare js array and string functions, and React js core concepts
Selected
I appeared for an interview before Oct 2023.
It was based on frontend technologies
(1 Question)
- Q1. Basic frontend question
(1 Question)
- Q1. Managerial round
Media.net Software Services (India) Interview FAQs
Tell us how to improve this page.
Media.net Software Services (India) Interviews By Designations
- Media.net Software Services (India) Web Application Developer Interview Questions
- Media.net Software Services (India) Product Manager Interview Questions
- Media.net Software Services (India) Software Engineer Interview Questions
- Media.net Software Services (India) Software Developer Interview Questions
- Media.net Software Services (India) Web Developer Interview Questions
- Media.net Software Services (India) Research Analyst Interview Questions
- Media.net Software Services (India) UI Developer Interview Questions
- Media.net Software Services (India) Site Reliability Engineer Interview Questions
- Show more
Interview Questions for Popular Designations
- Oracle Database Administrator Interview Questions
- SQL Database Administrator Interview Questions
- Database Architect Interview Questions
- Senior Database Administrator Interview Questions
- Database Engineer Interview Questions
- SQL Server Database Administrator Interview Questions
- Mysql Database Administrator Interview Questions
- DB2 Database Administrator Interview Questions
- Show more
Media.net Software Services (India) Database Developer Interview Process
based on 2 interviews
Interview experience
Interview Questions from Similar Companies
Fast track your campus placements
Media.net Software Services (India) Database Developer Reviews and Ratings
based on 2 reviews
Rating in categories
|
Web Application Developer
61
salaries
|  ₹6 L/yr - ₹20 L/yr |
|
Research Analyst
60
salaries
| ₹2.5 L/yr - ₹8.2 L/yr |
|
Softwaretest Engineer
47
salaries
| ₹4.5 L/yr - ₹12.2 L/yr |
|
Digital Marketing Associate
42
salaries
| ₹4 L/yr - ₹6 L/yr |
|
Product Operations Analyst
40
salaries
| ₹3.8 L/yr - ₹8 L/yr |
R.R. Donnelley
Epsilon
ChannelPlay
Affinity Express
- Home >
- Interviews >
- Media.net Software Services (India) Interview Questions >
- Media.net Software Services (India) Database Developer Interview Questions
