MES Departmental — Past Questions

MES Departmental • 2025 • Engineering Paper-II

Explain with examples how primary key, foreign key, unique constraints are defined and used in relational databases.

MES Departmental • 2025 • Engineering Paper-II

What is normalization? Convert the bellowed unnormalized table into 3NF form. StudentID StudentName Course Instructor 101 Alice DBMS Prof Rao 101 Alice Networks Prof Sharma

MES Departmental • 2025 • Engineering Paper-II

Which layer of the OSI model is responsible for reliable message delivery?

A) Network Layer

B) Transport Layer

C) Session Layer

D) Application Layer

Option B is correct: Transport Layer.

MES Departmental • 2025 • Engineering Paper-II

In TCP, which field ensures reliable delivery by confirming receipt of data?

A) Sequence Number

B) Acknowledgment Number

C) Window Size

D) Checksum

Option B is correct: Acknowledgment Number.

MES Departmental • 2025 • Engineering Paper-II

The external PT ratio is 33000/110V and external CT ratio is 50/1A. If the energy meter is calibrated for PT ratio 33000/110V, CT ratio -/1A then what will be the multiplying factor for the meter?

MES Departmental • 2025 • Engineering Paper-II

Define a semaphore. Distinguish between counting and binary semaphores

MES Departmental • 2025 • Engineering Paper-II

Explain the major components of an operating system and discuss how each contributes to system functionality.

MES Departmental • 2025 • Engineering Paper-II

In a multithreaded environment, each thread has its own:

A) Register set and stack

B) Code section

C) Data section

D) Open file table

Option A is correct: Register set and stack.

MES Departmental • 2025 • Engineering Paper-II

Which wireless technology operates in the 2.4 GHz and 5 GHz bands and supports speeds up to several Gbps?

A) Bluetooth

B) Zigbee

C) Infrared

D) Wi-Fi

Option D is correct: Wi-Fi.

MES Departmental • 2025 • Engineering Paper-II

Apply Shortest Remaining Time First (SRTF) algorithm to schedule the following process, what will be the average waiting time? Process Arrival time (AT) Burst Time (BT) P1 0 8 P2 1 4 P3 2 9 P4 3 5 P5 4 2

MES Departmental • 2025 • Engineering Paper-II

Discuss the concept and working of VoIP. How is voice transmitted over IP networks, and what are its challenges?

MES Departmental • 2025 • Engineering Paper-II

Which scheduling algorithm gives the minimum average waiting time for a given set of processes?

A) FCFS

B) SJF

C) Round Robin

D) Priority Scheduling

Option B is correct: SJF.

MES Departmental • 2025 • Engineering Paper-II

Which of the following commands would permanently delete all data and structure of a table?

A) DELETE FROM table_name

B) TRUNCATE TABLE table_name

C) REMOVE TABLE table_name

D) DROP TABLE table_name

Option D is correct: DROP TABLE table_name.

MES Departmental • 2025 • Engineering Paper-II

What are the key differences between guided and unguided transmission media? Give examples of each and discuss their advantages.

MES Departmental • 2025 • Engineering Paper-II

What are the main functions of Capacitive Voltage Transformer (CVT)? At what system voltage CVT is used? How is the HV terminals of CVT connected?

MES Departmental • 2025 • Engineering Paper-II

Which cryptographic algorithm is commonly used in digital signatures?

A) Blowfish

B) AES

C) DES

D) RSA

Option D is correct: RSA.

MES Departmental • 2025 • Engineering Paper-II

What are the difference between Control & Relay (C&R) panels and switchgears? At what voltage level switchgear is commonly used in Mizoram? Mention in which sub-station 33kV Switchgear is used owned by Mizoram?

MES Departmental • 2025 • Paper-II

What are the symptoms and causes of Alligator crack and Slippage in pavement surface?

MES Departmental • 2025 • Paper-II

Write a short note on influence of developmental activities in increased incidence of landslides.

Past Questions — 2025