Religare Network Administrator Interview Questions and Answers

Some basic aptitube and reasoning problems were asked. Easily solvable.

They asked multiple choice questions on oracle sql and pl/sql emphasizing more on reading a code block ask output questions. These were of medium hardness.

Q1. They asked what you do on daily basis in your work. What is most complex thing you have implemented and some complex questions on multilevel plsql collection module. It lasted for 1.5 hrs
Add your answer

Q1. Questions regarding Oracle architecture and its component
Add your answer
Q2. Question on live implementation of multilevel collection, bulk collect and record limiting and bulk exception handleing.
Add your answer
Q3. Dml error logging functionality
Ans. 
DML error logging functionality allows for capturing errors during data manipulation language operations.
• DML error logging can be enabled at the table level using the LOG ERRORS clause in DML statements.

• It helps in identifying and resolving data issues without causing the entire transaction to fail.

• Errors are logged in a separate error table, allowing the main operation to continue processing.

• Example: INSERT INTO table...read more
Answered by AI
Add your answer
Q4. Query and join optimization
Add your answer

Q1. Related to salary and what benefits they provide.
Add your answer

Q1. Hadoop basics on computing
Add your answer
Q2. Distribution basics for processing the data
Add your answer

Q1. Architecture of bigdata systems
Ans. 
Bigdata systems architecture involves distributed storage, processing, and analysis of large volumes of data.
• Utilize distributed file systems like HDFS for storage

• Use parallel processing frameworks like Apache Spark or Hadoop for data processing

• Implement data pipelines for ETL processes

• Leverage NoSQL databases like Cassandra or MongoDB for real-time data querying

• Consider data partitioning and replication for fault tole
Answered by AI
Add your answer
Q2. How will the bigdata system distribution for storage andcompute happen
Ans. 
Big data system distribution for storage and compute involves partitioning data across multiple nodes for efficient processing.
• Data is partitioned across multiple nodes to distribute storage and processing load.

• Hadoop Distributed File System (HDFS) is commonly used for storage distribution.

• Apache Spark utilizes a cluster computing framework for distributed computing.

• Data locality is important to minimize data transfer ...read more
Answered by AI
Add your answer

Q1. What is your strength
Add your answer

Q1. What do inherent risk and residual risk
Ans. 
Inherent risk is the risk level before any actions are taken to mitigate it, while residual risk is the risk level after mitigation efforts.
• Inherent risk is the risk level that exists before any actions are taken to mitigate it

• Residual risk is the risk level that remains after mitigation efforts have been implemented

• Inherent risk is inherent to the activity or situation, while residual risk is what is left over after c...read more
Answered by AI
Add your answer
Q2. What is the RCA
Ans. 
RCA stands for Root Cause Analysis, a method used to identify the underlying cause of a problem or issue.
• RCA involves investigating and analyzing the factors that contributed to a specific outcome or event.

• It helps in determining what went wrong, why it happened, and how to prevent it from happening again.

• Common techniques used in RCA include 5 Whys, Fishbone Diagram, and Fault Tree Analysis.

• Example: If a product fails...read more
Answered by AI
Add your answer

Java concurrency base test

Q1. Pure technical round. Coding, data structure, algo
Add your answer

Q1. Same as 2nd round with advance topic
Add your answer

Had a online test with questions related to kyc and screening.

Q1. Ono on one round with operations manager
Add your answer
Q2. Basic question related to current organisation structure and job role
Add your answer

Q1. Ono on one round with VP of the project
Add your answer
Q2. In depth discussion about current process and detailed discussion of present job role and responsibilities
Add your answer

Q1. Work experience
Add your answer