Prime Healthcare Diploma Trainee Engineer Interview Questions and Answers

Q1. Basic topics of plsql
Add your answer
Q2. One query to fetch max n min of salary from emp table
Ans. 
Use SQL query to fetch maximum and minimum salary from emp table
• Use SELECT MAX(salary) FROM emp to fetch maximum salary

• Use SELECT MIN(salary) FROM emp to fetch minimum salary
Answered by AI
Add your answer

Q1. Performance tuning
Add your answer
Q2. Indexes and exceptions used
Ans. 
Indexes and exceptions are used to optimize database performance and handle errors in code.
• Indexes are used to quickly retrieve data from a database by creating a sorted list of values.

• Exceptions are used to handle errors in code and prevent the program from crashing.

• Examples: Creating indexes on frequently queried columns like 'id' or 'timestamp'. Using try-catch blocks to handle exceptions like divide by zero.
Answered by AI
Add your answer

Q1. Questions related to python
Add your answer

Q1. Questions related to basic security
Add your answer
Q2. Questions related to architecture of the app
Add your answer

Q1. Information of JD and client and process
Add your answer

Q1. Technical question
Add your answer

Q1. Salary discussion
Add your answer

Normal, try answer correctly and don’t cheat

Q1. Ai told you gramartical question
Add your answer
Q2. Ai told you match the word
Add your answer

Q1. Telme about your current company roles and responsibilities
Add your answer
Q2. Which routing protocal are you comfortable
Ans. 
I am comfortable with OSPF and BGP routing protocols.
• I have experience in configuring and troubleshooting OSPF and BGP.

• I am familiar with OSPF areas, LSAs, and BGP attributes.

• I have worked with OSPF and BGP in both enterprise and service provider networks.

• I understand the differences between OSPF and BGP and when to use each protocol.

• I am also familiar with other routing protocols such as EIGRP and RIP.
Answered by AI
Add your answer
Q3. Brief about vlan, stp, rstp, vtp, port channel, Vss, stacking, port security,
Add your answer
Q4. What is vpn and ipsec, ipsec tunnels troubleshooting
Ans. 
VPN is a secure connection between two networks. IPsec is a protocol used to secure the VPN connection.
• VPN allows remote access to a network through a secure connection

• IPsec provides encryption and authentication for the VPN connection

• IPsec tunnels can be troubleshooted by checking the configuration, verifying the network topology, and checking for any firewall or NAT issues

• Examples of VPN technologies include OpenVPN,
Answered by AI
Add your answer

Q1. Brief about your experience
Add your answer
Q2. Roles and responsibility of current organization
Add your answer

Q1. I have applied for click software developer profile. So the most of the questions are from Click software. Question:1 Tell me about yourself in brief. Question:2 Explain all the projects which you have wri...read more
Add your answer

Q1. Question 1 Introduce yourself in short. Question 2 Based on my answer, they will ask. If you like one technology what is the reason behind that? If you not like any particular technology what is the reason...read more
Add your answer

Q1. What are your salary expectations?
Add your answer
Q2. What is your family background?
Add your answer
Q3. Share details of your previous job.
Add your answer
Q4. Why are you looking for a change?
Add your answer
Q5. Tell me about yourself.
Add your answer