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
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
Explain with examples how primary key, foreign key, unique constraints are defined and used in relational databases.
MES Departmental • 2025 • Engineering Paper-II
A condition for deadlock to occur that involves resource holding without release is:
A)
Circular wait
B)
Mutual exclusion
C)
Hold and wait
D)
No preemption
Option C is correct: Hold and wait.
MES Departmental • 2025 • Engineering Paper-II
What are the differences between power transformers and distribution transformers?
MES Departmental • 2025 • Engineering Paper-II
Which of the following best describes the difference between a schema and an instance?
A)
Schema changes frequently, instance rarely changes
B)
Schema is a snapshot of data, instance is the metadata
C)
Schema is the logical structure, instance is the actual content at a given time
D)
Instance is permanent, schema is temporary
Option C is correct: Schema is the logical structure, instance is the actual content at a given time.
MES Departmental • 2025 • Engineering Paper-II
How can we classify overhead transmission lines? Briefly describe how line constants are considered in each case?
MES Departmental • 2025 • Engineering Paper-II
Which type of join returns only the matching rows from two tables?
A)
LEFT JOIN
B)
OUTER JOIN
C)
FULL JOIN
D)
INNER JOIN
Option D is correct: INNER JOIN.
MES Departmental • 2025 • Engineering Paper-II
Which of the following SQL data types is used for variable-length character strings?
A)
INT
B)
VARCHAR
C)
CHAR
D)
TEXT
Option B is correct: VARCHAR.
MES Departmental • 2025 • Engineering Paper-II
Which of the following is a key characteristic of a relational database model?
A)
Pointers to navigate between tuples
B)
Object inheritance
C)
Tables with rows and columns
D)
Trees representing relationships
Option C is correct: Tables with rows and columns.
MES Departmental • 2025 • Engineering Paper-II
Briefly mention different methods of improving Earth Resistance.
MES Departmental • 2025 • Engineering Paper-II
Explain direct and indirect lightning strike? Mention how transformer must be protected from lightning.
MES Departmental • 2025 • Engineering Paper-II
HTTP is a:
A)
Stateless protocol
B)
Stateful protocol
C)
Connection-oriented protocol
D)
Real-time protocol
Option A is correct: Stateless protocol.
MES Departmental • 2025 • Engineering Paper-II
What are firewalls and VPNs? How do they enhance network security, and what are their key functions?
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
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
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
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
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 • Paper-II
Write a short note on influence of developmental activities in increased incidence of landslides.
MES Departmental • 2025 • Paper-II
What are the symptoms and causes of Alligator crack and Slippage in pavement surface?
MES Departmental • 2023 • Paper-II
Inductive reactance is measured in ohms because it
A)
reduces the amplitude of alternating current
B)
increases the amplitude of alternating current
C)
increases the amplitude of direct current
D)
has a back e.m.f. opposing a steady direct current
Option D is correct: has a back e.m.f. opposing a steady direct current.
MES Departmental • 2023 • Paper-II
The time period of a direct current is
A)
infinite
B)
zero
C)
finite
D)
random
Option A is correct: infinite.
MES Departmental • 2023 • Paper-II
If e1 = Asinwt and e2 = B sin (wt-f), then
A)
e1 lags e2 by f
B)
e2 lags e1 by f
C)
e1 is in phase with e2
D)
e2 is in phase with e1
Option B is correct: e2 lags e1 by f.
MES Departmental • 2023 • Paper-II
The speed at which a 6-pole alternator should be driven to generate 50 cycles per second is
A)
1500 r.p.m
B)
1000 r.p.m
C)
800 r.p.m
D)
500 r.p.m
Option A is correct: 1500 r.p.m.
