National Institute for Smart Government Database Developer Interview Questions and Answers for Freshers

Q1. Basic SQL questions, also some Java related questions and some no SQL relate questions like mangodb and big data etc
Add your answer

Q1. Static and dynamic polymorphism
Add your answer
Q2. Code snipts related to prefix and postfix
Add your answer

Q1. Surprisingly, the person started asking knowledge about Linux commands.
Add your answer
Q2. Grep, Kill, Call, chmode etc. etc. .
Add your answer
Q3. Syntaxes, rwx combo etc. .
Add your answer

In it they trying to get the information about basic knowledge about related to database and also they are give to write some queries

Related queries which you did in your past projects and also some queries to write

Q1. DDL DML DCL TCL
Add your answer

Q1. How to run parallel queries for multiple databases ??
Ans. 
To run parallel queries for multiple databases, use parallel processing techniques and tools.
• Use parallel processing techniques such as multi-threading or distributed computing to run queries simultaneously on multiple databases.

• Consider using tools like Apache Hadoop or Apache Spark for parallel processing of queries across multiple databases.

• Ensure proper resource allocation and optimization to prevent performance is...read more
Answered by AI
Add your answer
Q2. What is normalisation technique used for database??
Ans. 
Normalization technique is used to organize data in a database to reduce redundancy and improve data integrity.
• Normalization involves breaking down a table into smaller tables and defining relationships between them.

• It helps in reducing data redundancy by storing data in a structured and organized manner.

• Normalization ensures data integrity by minimizing data anomalies such as update, insert, and delete anomalies.

• There...read more
Answered by AI
Add your answer

I have agreep on python basic