Dish Network Software Developer Interview Questions and Answers

Q1. What is different between Mysql Vs sql ?
Ans. 
MySQL is a specific implementation of SQL, which is a standardized language for managing databases.
• MySQL is a specific relational database management system (RDBMS) that uses SQL as its query language.

• SQL (Structured Query Language) is a standardized language for managing databases, used by various RDBMS like MySQL, Oracle, and SQL Server.

• MySQL is open-source and free to use, while some other RDBMS like Oracle may requ...read more
Answered by AI
Add your answer
Q2. What abstraction and interface in java?
Ans. 
Abstraction and interface are key concepts in Java for achieving abstraction and defining contracts for classes.
• Abstraction in Java is achieved using abstract classes and interfaces.

• Abstract classes can have both abstract and concrete methods, while interfaces can only have abstract methods.

• Interfaces define contracts that classes must implement, allowing for polymorphism and loose coupling.

• Example: interface Shape { v...read more
Answered by AI
Add your answer
Q3. What is mean by JSP?
Ans. 
JSP stands for JavaServer Pages, a technology used for creating dynamic web pages.
• JSP allows embedding Java code in HTML pages

• It simplifies the process of creating dynamic web content

• JSP files are compiled into servlets by the server for execution
Answered by AI
Add your answer

1st round some apt qns,some prgramming qns are they asked

Q1. C depth concepts and some prgram
Add your answer

Q1. Some DSA questions they asked
Add your answer

Q1. How to optimise fetching 1 lakh entries from db
Ans. 
Use pagination, indexing, caching, and query optimization to fetch 1 lakh entries efficiently from the database.
• Implement pagination to fetch data in smaller chunks

• Create indexes on columns frequently used in queries

• Use caching to store frequently accessed data

• Optimize queries by avoiding unnecessary joins and using appropriate indexes

• Consider using database-specific optimizations like query hints or stored procedures
Answered by AI
Add your answer

Q1. Reverse a linked list.
Add your answer
Q2. Merge sort on a array/
Add your answer

Test had 2 sections..first section had 3 subsections with quants,verbal and logicals.2nd section is an English writing skill round where they give u a topic and u have to write ur views on it more than 200 words

Gd has the basic rules..they give a topic and u have to discuss on that

Q1. Hr asks you questions on your project,the programming language ur strong in and may be few code solving questions
Add your answer

Q1. HR round tests your flexibility and adaptability skills.
Add your answer

2 coding question 1 hr

Topic on environment issue

Q1. Normal discussion
Add your answer
Q2. Where are u from
Add your answer