PMPL Surveyor Interview Questions and Answers

Group discussion

Q1. What is vrrp and harp and how it functions?
Ans. 
VRRP (Virtual Router Redundancy Protocol) and HARP (High Availability Redundancy Protocol) are protocols used for providing redundancy in network routing.
• VRRP is used to provide a virtual IP address that multiple routers can share, ensuring high availability in case of router failure.

• HARP is a proprietary protocol developed by Cisco that also provides redundancy by allowing multiple routers to share a virtual IP addres...read more
Answered by AI
Add your answer
Q2. What is router and firewall and state difference?
Ans. 
A router is a networking device that forwards data packets between computer networks, while a firewall is a security system that monitors and controls incoming and outgoing network traffic.
• Router directs traffic between different networks based on IP addresses.

• Firewall filters network traffic based on predetermined security rules.

• Routers operate at layer 3 (network layer) of the OSI model, while firewalls operate at la...read more
Answered by AI
Add your answer
Q3. What is dwdm and it's components?
Ans. 
DWDM stands for Dense Wavelength Division Multiplexing, a technology used in fiber optic communications.
• DWDM is a technology that allows multiple data signals to be transmitted simultaneously over a single fiber optic cable.

• Components of DWDM include lasers, multiplexers, demultiplexers, optical amplifiers, and dispersion compensators.

• DWDM systems use different wavelengths of light to carry multiple data streams, incre...read more
Answered by AI
Add your answer
Q4. Osi reference model explanation?
Ans. 
The OSI reference model is a conceptual framework that standardizes the functions of a telecommunication or computing system into seven distinct layers.
• The OSI model stands for Open Systems Interconnection model.

• It helps in understanding how different networking protocols work together.

• Each layer has specific functions and communicates with adjacent layers.

• Examples of layers include physical layer, data link layer, net
Answered by AI
Add your answer

Q1. Exceptions in plsql
Ans. 
PL/SQL exceptions handle errors and manage control flow in Oracle databases, ensuring robust application behavior.
• PL/SQL has predefined exceptions like NO_DATA_FOUND and ZERO_DIVIDE.

• Custom exceptions can be defined using the EXCEPTION keyword.

• Use the RAISE statement to trigger an exception manually.

• Example: BEGIN SELECT salary INTO v_salary FROM employees WHERE emp_id = 100; EXCEPTION WHEN NO_DATA_FOUND THEN DBMS_OUTPU...read more
Answered by AI
Add your answer
Q2. How many types of triggers in plsql
Ans. 
PL/SQL triggers are special procedures that automatically execute in response to certain events on a database table or view.
• 1. DML Triggers: Execute on Data Manipulation Language events (INSERT, UPDATE, DELETE). Example: AFTER INSERT trigger to log changes.

• 2. INSTEAD OF Triggers: Used on views to perform actions instead of the triggering action. Example: INSTEAD OF DELETE on a view.

• 3. System Triggers: Triggered by syst...read more
Answered by AI
Add your answer

Q1. What is the salary expectation
Add your answer