Purbanchal University
Master of Information Technology (M.I.T.) — 2nd Semester | Past Exam Questions
Select a subject and year above to view the question paper.
MIT 121: Design and Analysis of Algorithms — 2022
Master of Information Technology (M.I.T.) / Second Semester / Final
Candidates are required to give their answers in their own words as far as practicable.
The figures in the margin indicate full marks.
Group A 2 × 12 = 24
Answer TWO questions.
1.
3+6+3
Describe Divide and Conquer approach of solving problems. Illustrate
recursive approach of binary search algorithm with its recurrence relation and derive its
Big-O complexity using backward substitution method. Trace searching 29 in the array: 5, 7,
9, 14, 21, 29, 33, 46, 64, 71 using binary search algorithm.
2.
2+2+2+6
What is dynamic programming? Illustrate with an example: "Dynamic
Programming uses Concepts of Divide and Conquer, but is not exactly the same". State
travelling salesman problem. Design and analyze the travelling salesman problem using
dynamic programming using your own example graph.
3.
4+2+6
Explain about optimization type problems and clarify the reason behind
use of greedy approach for solving optimization problems. Define Job Sequencing with
deadline problem. Solve the following Knapsack Problem using greedy method (Size of Knapsack
= 6 kg):
| Item | 1 | 2 | 3 | 4 | 5 |
|---|---|---|---|---|---|
| Profit ($) | 25 | 20 | 15 | 40 | 50 |
| Weight (kg) | 3 | 2 | 1 | 4 | 5 |
Group B 6 × 6 = 36
Answer SIX questions.
4.3+3What is RAM Model in analyzing algorithms in computation? Define
Theta-Notation with its geometrical interpretation.
5.Design Quick Sort
algorithm with its best, average and worst case time complexity analysis.
Repeated in 2023
Repeated in 2023
6.
Compute Big-O characterization for the following recurrences using
Masters Theorem.
Repeated in 2023
Repeated in 2023
(i) T(n) = 2T(n/2) + n³
(ii) T(n) = 25T(n/5) + 5n²
(iii) T(n) = T(n−1) + n
7.
Use Chinese Remainder Theorem to find x such that:
x ≡ 2 (mod 5)
x ≡ 3 (mod 7)
x ≡ 10 (mod 11)
8.
2+4
Why is Prim's Algorithm not suitable for disconnected graph? Trace
generation of Minimum Spanning Tree (MST) of the given graph using Prim's
algorithm.
Repeated in 2023
Repeated in 2023
Weighted graph redrawn in HTML/SVG for the missing MST figure
referenced in the question.
9.Discuss complexity of
classes.
10.Write and analyze the
algorithm used for 0/1 Knapsack problem using dynamic programming.
MIT 121: Design and Analysis of Algorithms — 2023
Master of Information Technology (M.I.T.) / Second Semester / Final
Candidates are required to give their answers in their own words as far as practicable.
The figures in the margin indicate full marks.
Group A 2 × 12 = 24
Answer TWO questions.
1.3+6+3What are different parts/steps/phases in a Divide-and-Conquer algorithm?
Illustrate using an example. Explain Merge Sort algorithm and find its Big-O time complexity
using recursion tree method. Trace the sorting of 5, 1, 16, 2, 9, 7 using Merge Sort.
2.3+2+5+2
Explain greedy method with some famous problems solved using greedy
algorithms. What is a Job Sequencing with deadline? Solve the following given Job Sequencing
Problem using greedy method. What is its worst case time complexity?
| Activities (aᵢ) | a1 | a2 | a3 | a4 | a5 | a6 | a7 | a8 |
|---|---|---|---|---|---|---|---|---|
| Start (sᵢ) | 1 | 0 | 1 | 4 | 2 | 5 | 3 | 4 |
| Finish (fᵢ) | 3 | 4 | 2 | 6 | 9 | 8 | 5 | 5 |
3.6+4+2Explain the concept of dynamic programming with its key components. Also
explain the concept of memoization and its importance in dynamic programming. What is the
time complexity of a typical dynamic programming problem?
Group B 6 × 6 = 36
Answer SIX questions.
4.2+2+2Define algorithm and its characteristics. Why do we require a hypothetical
model of computer in algorithm analysis? Describe RAM Model.
5.Design Quick Sort
algorithm with its best, average and worst case time complexity analysis.
Repeated in 2022
Repeated in 2022
6.
Compute Big-O characterization for the following recurrences using
substitution method.
Repeated in 2022
Repeated in 2022
(i) T(n) = 25T(n/5) + 5n²
(ii) T(n) = 2T(n/2) + 1
(iii) T(n) = 9T(n/3) + n
7.
2+4
Why is Prim's Algorithm not suitable for disconnected graph? Trace
generation of Minimum Spanning Tree (MST) of the given graph using Prim's
algorithm.
Repeated in 2022
Repeated in 2022
Weighted graph redrawn in HTML/SVG for the missing MST figure
referenced in the question.
8.3+3
State Chinese Remainder Theorem (CRT) with its applications. Solve CRT
for the following congruences.
x ≡ 2 (mod 3), x ≡ 3 (mod 5), x ≡ 2 (mod 7)
9.2+4Define NP and NP-Complete classes of problems. Briefly describe the Sum of
Subset problem as a concept of Approximation Theorem.
10.Describe the time
complexity analysis of Insertion Sort algorithm along with its algorithm.
MIT 121: Design and Analysis of Algorithms — 2024
Master of Information Technology (M.I.T.) / First Semester / Final
Candidates are required to give their answers in their own words as far as practicable.
The figures in the margin indicate full marks.
Group A 2 × 12 = 24
Answer TWO questions.
1.What are the elementary
properties of algorithm? Explain. Why do we need algorithm? Discuss about analysis of the
RAM model for analysis of algorithm with a suitable example.
2.Explain about the divide
and conquer paradigm for algorithm design with a suitable example. Write the quick sort
algorithm using randomized approach and explain its time complexity.
3.
Compare and contrast Kruskal's algorithm with other MST algorithms like
Prim's. Also provide a detailed discussion on:
– Theoretical and practical differences in their approach to
finding the MST.
– The types of graphs and specific scenarios where one algorithm
might be preferred over the others.
– Performance analysis in terms of time complexity and real-world
applications.
Group B 6 × 6 = 36
Answer SIX questions.
4.Explain how asymptotic
notations are used to describe the best, worst, and average case time complexities of an
algorithm. Provide an example for each scenario.
5.
Explain the recursion tree method for solving the recurrence relation.
Solve the following recurrence relation using this method.
T(n) = 2T(n/2) + 1 for n > 1
T(n) = 1 for n = 1
6.How can BFS and DFS be
used to construct a spanning tree of a connected graph? What are the differences between the
spanning trees produced by each?
7.
Given the system of congruences: x ≡ 4 (mod 6), x ≡ 5 (mod 7), x ≡ 6
(mod 11). Determine the smallest positive integer x that satisfies all the congruences using
the Chinese Remainder Theorem.
8.Discuss Dijkstra's single
source shortest path algorithm and derive the time complexity of this algorithm.
9.How can you differentiate
between tractable and intractable problems? Explain P, NP, NP-Hard and NP-Complete
classes.
10.Provide a real-world
problem where dynamic programming is used to optimize performance. Compare the solution with
a recursive approach that does not use memoization.
MIT 122: Information Security — 2022
Master of Information Technology (M.I.T.) / Second Semester / Final
Candidates are required to give their answers in their own words as far as practicable.
The figures in the margin indicate full marks.
Group A 2 × 12 = 24
Answer TWO questions.
1.2+10What do you mean by Security Blueprint? Who gets benefitted by this
Blueprint and what are the services provided by it? Explain.
2.5+7Write the advantages and drawbacks of secret-key cryptography. Explain RSA
algorithm with suitable demonstration.
3.5+7Explain NSTISSC security model. Also explain the different phases of Sec
SDLC.
Group B 6 × 6 = 36
Answer SIX questions.
4.Define computer crime and
ethics in information security. Briefly write about prevailing legal and ethical
issues.
5.What are intrusion
detection system and intrusion prevention system? Briefly explain how these differ from
firewall.
6.Explain different laws and
ethics in information security. Discuss risk control strategies in brief.
7.Briefly discuss about any
five emerging threats to information security.
8.What is VPN and how does
it work? Explain the benefits of using VPNs.
9.How do you implement
information security? Explain the technical and non-technical aspects of
implementation.
10.Write note on (Any TWO):
- a) Risk assessment
- b) Digital forensics
- c) The SDLC
MIT 122: Information Security — 2023
Master of Information Technology (M.I.T.) / Second Semester / Final
Candidates are required to give their answers in their own words as far as practicable.
The figures in the margin indicate full marks.
Group A 2 × 12 = 24
Answer TWO questions.
1.4+8How do you identify risks in information security? Explain the tasks
carried out during risk assessment.
2(a).6Explain in detail about security management model. Also write the purpose
of this model.
2(b).6 Distinguish between private and public key
cryptography with their merits and demerits.
3.2+10Explain the role of firewall in network security. Also describe the
different types of firewall available.
Group B 6 × 6 = 36
Answer SIX questions.
4.What do you understand by
intrusion detection and prevention system? Explain their types.
5.What is an attack? Explain
about attacks on cryptosystems.
6.What is a security policy
and how does it guide an organization's information security practices?
7.What is meant by digital
forensic? Explain its challenges, advantages and disadvantages.
8.What do you mean by ethics
in information security? Write about relevant US and International laws regarding
information security.
9.What is Sec SDLC? Briefly
explain about NSTISSC security model.
10.Write note on any TWO:
- a) Security blueprint
- b) Security certification and accreditation
- c) Protocol for secure communication
MIT 122: Information Security — 2024
Master of Information Technology (M.I.T.) / Second Semester / Final
Candidates are required to give their answers in their own words as far as practicable.
The figures in the margin indicate full marks.
Group A 2 × 12 = 24
Answer TWO questions.
1.6+6Explain the role of security SDLC in creating secure software
applications. How do businesses make sure that development operations within organizations
are secure?
2.8+4What are the benefits and limitations of using firewalls as defense
mechanism? What features are considered while selecting an appropriate firewall for
protecting an organization's information?
3(a).6What
are employment policies and practices within an organization regarding information
security?
3(b).6 Discuss about technical and non-technical aspects of
security implementation.
Group B 6 × 6 = 36
Answer SIX questions.
4.Write the differences
between intrusion detection system and intrusion prevention system. Briefly discuss about
the recent technologies used to restrict physical security breaches.
5.How important is ethics in
information security? What are the legal and ethical issues in this regard?
6.What are the protocols
used for secure communications and how do they maintain security?
7.Describe about the
contemporary threats and attacks that organizations are facing in terms of their network and
information security.
8.What factors need to be
considered while selecting an appropriate risk control strategy for an organization?
9.Explain the foundation and
objectives of cryptology.
10.Write short notes on Any TWO:
- a) Risk management
- b) Security blueprint
- c) Digital forensics
MIT 122: Information Security — 2025
Master of Information Technology (M.I.T.) / Second Semester / Final
Candidates are required to give their answers in their own words as far as practicable.
The figures in the margin indicate full marks.
Group A 2 × 12 = 24
Answer TWO questions.
1.12Describe the NSTISSC model's guidelines for developing secure information
systems. What are the benefits of following these guidelines for both government and private
sector organizations? Analyze the role of risk management within the NSTISSC model.
2.12Briefly describe different security management models.
3.12What are the components of an information system and how are they
secured?
4.10+2Discuss the process of risk identification and risk assessment in detail.
Suggest some strategies to control risks in information security.
Group B 6 × 6 = 36
Answer SIX questions.
4.6What do you mean by security education and how does it help employees
maintain a healthy and secure working environment within an organization?
5.6What are some US laws regarding information security? Briefly discuss the
international legal bodies that govern such laws.
6.6Discuss the ways of securing remote connections.
7.6Explain the key objectives of information security project
management.
8.6Why do business operations need to be secured? How do businesses address
those needs?
9.6What are the scanning and analysis tools used to control unauthorized
access and how do they contribute?
10.6
Write short notes on any TWO:
- a) Sec SDLC
- b) Ethics in information security
- c) Security certification and accreditation
MIT 123: Big Data — 2022
Master of Information Technology (M.I.T.) / Second Semester / Final
Candidates are required to give their answers in their own words as far as practicable.
The figures in the margin indicate full marks.
Group A 2 × 12 = 24
Answer TWO questions.
1.4+8Define Hadoop and HDFS. Explain the core components of Hadoop.
2.2+10What is CUDA? Explain how parallelism is achieved in CUDA using a suitable
CUDA C program.
3.2+10What is Big Data? What are the five V's of Big Data? Explain.
Group B 6 × 6 = 36
Answer SIX questions.
4.Explain Neo4J? Can it
handle Big Data?
5.What is MapReduce? How
does Hadoop MapReduce work? Explain with a suitable example.
6.Explain the various steps
you follow for analyzing Big Data statistically in R.
7.What is R? Differentiate
between vector, list, matrix and data frame.
8.Distinguish between RDBMS
and Hadoop. What are the additional features in VoltDB?
9.Define Machine Learning
and list down the various machine learning algorithms. Explain supervised learning.
10.3+3Write short notes on any TWO:
- a) Apache Flink
- b) Syntactic and semantic analysis in NLP
- c) Data visualization in D3
MIT 123: Big Data — 2023
Master of Information Technology (M.I.T.) / Second Semester / Final
Candidates are required to give their answers in their own words as far as practicable.
The figures in the margin indicate full marks.
Group A 2 × 12 = 24
Answer TWO questions.
1.Explain in detail the Map
Reduce Framework. Explain how map reduce is applicable in Big Data Analytics.
2.Explain the concept of
CUDA and how it leverages GPUs for general-purpose parallel computing. Discuss its
applications in advanced statistical analysis.
3.Explain the concept of
Data Flow Computing. How does it differ from computing with conventional CPUs or
GPUs.
Group B 6 × 6 = 36
Answer SIX questions.
4.Compare and contrast Spark
with the traditional MapReduce framework. Describe the advantages of using Spark for Big
Data processing.
5.What do you mean by
visualizing large data sets? How can it be done using D3? Explain.
6.What is Apache Flink?
Explain the advantages of using Apache Flink for Big Data processing.
7.Discuss the fundamental
mechanisms and techniques involved in natural language processing (NLP) for analyzing
written text.
8.Explore the principles of
data flow computing and the specific advantages Maxeler technology brings to data flow
computations. Provide a use case illustrating its benefits.
9.What is the fundamental
difference between supervised and unsupervised learning? Explain the concept of overfitting
in machine learning.
10.What is sentiment
analysis, and how is it used in text processing? Explain the concept of Named Entity
Recognition (NER) in text analysis.
11.3+3Write short notes on any TWO:
- a) Spark APIs
- b) Graph Database
- c) In-memory database
MIT 123: Big Data — 2024
Master of Information Technology (M.I.T.) / Second Semester / Final
Candidates are required to give their answers in their own words as far as practicable.
The figures in the margin indicate full marks.
Group A 2 × 12 = 24
Answer TWO questions.
1.Imagine you have a large
dataset containing information about customer transactions in an e-commerce platform. Each
record includes the customer's ID, the product ID, the purchase amount, and the date of the
transaction. Your task is to use MapReduce to calculate the total purchase amount for each
customer. Describe the steps of how you would implement this task using the MapReduce
framework.
2.How can 'R' be used to
perform statistical analysis on a given dataset? Explain three essential libraries or
packages commonly used in R for statistical analysis.
3.What is Computer Unified
Device Architecture? Explain its applications with some real-time use cases.
Group B 6 × 6 = 36
Answer SIX questions.
4.Describe the architecture
and use-cases of Apache Kafka and Apache Flume in achieving near real-time data
processing.
5.Provide an overview of the
types of machine learning algorithms and their applications in data analysis and
prediction.
6.Explain the fundamental
concepts of graph databases, with a focus on Neo4j. How can Neo4j be used to model and query
highly correlated data?
7.Explore advanced tools and
techniques used in the analysis of speech and written text. How can these tools be applied
in commercial applications?
8.What are the potential
advantages of using Maxeler technology in terms of performance, space, and power
consumption? Explain.
9.What is near real-time
processing? How can it be implemented using Spark? Explain with an example.
10.What is natural language
processing? What are some of the most common natural language processing tasks?
11.3+3Write short notes on Any TWO:
- a) VoltDB
- b) NoSQL
- c) HDFS
MIT 124: Data Communication and Networking — 2022
Master of Information Technology (M.I.T.) / Second Semester / Final
Candidates are required to give their answers in their own words as far as practicable.
The figures in the margin indicate full marks.
Group A 2 × 12 = 24
Answer TWO questions.
1.A bit stream 1101011011 is
transmitted using the standard CRC method. The generator polynomial is x⁴+x+1. What is the
actual bit string transmitted?
Repeated in 2023
Repeated in 2023
2.Define firewall and
explain their components. Select suitable values of A, B, N, D and E and demonstrate the
encryption and decryption procedures using RSA algorithm.
3.Define subnetting and
supernetting. Find the maximum bit rate for a channel having bandwidth 3100 Hz and S/N ratio
of 10 dB.
Group B 6 × 6 = 36
Answer SIX questions.
4.What is multiplexing? In
which conditions is multiplexing used? Explain FDM and TDM.
5.What is VSAT? Explain NAT
with its working principle.
6.What is SCTP? Explain QoS
provided by transport layer.
7.What is Network File
System? Explain how FTP works.
8.Explain different
transition techniques for IPv6 transition.
9.What is VLAN? Why do we
need a VLAN? How does a VLAN work?
10.What is IEEE? Explain
IEEE 802.3 and IEEE 802.4.
MIT 124: Data Communication and Networking — 2023
Master of Information Technology (M.I.T.) / Second Semester / Final
Candidates are required to give their answers in their own words as far as practicable.
The figures in the margin indicate full marks.
Group A 2 × 12 = 24
Answer TWO questions.
1.4+8What is CRC and why is it better than parity? A bit stream 1101011011 is
transmitted using the standard CRC method. The generator polynomial is x⁴+x+1. What is the
actual bit string transmitted?
Repeated in 2022
Repeated in 2022
2.
What are subnetting and supernetting? Faculty of Science and Technology
has 4 colleges. They need to be connected in the same network. Allocate the following
numbers of IP addresses: 25, 68, 19 and 50 to those colleges by reducing losses. The IP
address provided to you is: 202.601.77.0/24. List the range of IP addresses, their Network
address, Broadcast addresses and corresponding Subnet mask.
Repeated in 2024
Repeated in 2024
3.
Determine the maximum bit rate for a channel having bandwidth equal to
1600 Hz if:
Repeated in 2024
Repeated in 2024
(a) S/N ratio is 0 dB
(b) S/N ratio is 20 dB
Group B 6 × 6 = 36
Answer SIX questions.
4.What is collision?
Distinguish between CSMA/CA and CSMA/CD.
5.What are routing
protocols? Explain OSPF protocol and its applications.
6.What are the elements of
Transport Layer Protocol? Explain TCP segment header.
7.Make a comparison between
DES and RSA algorithm.
8.What is POP? Explain how
SMTP works.
Repeated in 2024
Repeated in 2024
9.State Nyquist's law and
mention its criteria for guided and unguided media.
10.What is IEEE? Compare
switch with router and gateway.
Repeated in 2024
Repeated in 2024
MIT 124: Data Communication and Networking — 2024
Master of Information Technology (M.I.T.) / First Semester / Final
Candidates are required to give their answers in their own words as far as practicable.
The figures in the margin indicate full marks.
Group A 2 × 12 = 24
Answer TWO questions.
1.
You are tasked with calculating the CRC of a message using a given
generator polynomial. The message to be transmitted is: 1101011011. The generator polynomial
is: 1101.
(a)6 Compute the CRC using the generator polynomial and
append it to the message.
(b)6 Verify the correctness of the transmission by dividing
the received message (message + CRC) by the generator polynomial.
2.What do you mean by
subnetting and supernetting? Institute of Science and Technology has 4 colleges that need to
be connected in the same network. Allocate the following numbers of IP addresses: 25, 68, 19
and 50 to those colleges by reducing losses. The IP address provided to you is:
202.62.70.0/24. List the range of IP addresses, their network address, broadcast addresses
and corresponding subnet mask.
Repeated in 2023
Repeated in 2023
3.
Determine the maximum bit rate for a channel having bandwidth equal to
1800 Hz if:
Repeated in 2023
Repeated in 2023
(a) S/N ratio is 0 dB
(b) S/N ratio is 40 dB
Group B 6 × 6 = 36
Answer SIX questions.
4.What is collision? Explain
how CSMA/CD works in LAN.
5.Describe basic OSPF
features and packet types.
6.Explain the elements and
functions of transport layer.
7.What is cryptography?
Discuss RSA algorithm.
8.What is POP? Explain how
SMTP works.
Repeated in 2023
Repeated in 2023
9.Explain the features and
address mechanism of IPv6.
10.What is IEEE? Compare
switch with router.
Repeated in 2023
Repeated in 2023
11.Write short notes on Any TWO:
- a) ARQ standard
- b) ISDN
- c) Error detection and correction
MIT 125 (SN): System and Network Administration — 2022
Master of Information Technology (M.I.T.) / Second Semester / Final (Elective I)
Candidates are required to give their answers in their own words as far as practicable.
The figures in the margin indicate full marks.
Group A 2 × 12 = 24
Answer TWO questions.
1(a).6
What is physical address? You are given the IP address block
201.40.58.0/24. Design the subnet for 49, 27, and 1145 hosts group so that IP address
wastage is minimum. Find subnet mask, network ID, broadcast ID, assigned IP and unassigned
IP range in each department.
1(b).6 What are the different transition techniques for IPv6
transition?
2(a).3Why
do we need to mount file system?
2(b).4 How can we provide fault monitoring? Explain.
2(c).5 Discuss the types of backup media.
3(a).5Compare SMTP with IMAP.
3(b).7 Discuss job scheduling with cron.
Group B 7 × 6 = 36
Answer SEVEN questions.
4.2+4What is DNS? How does it work?
5.2+4What is firewall? How does it work in LAN? Explain.
6.Explain types of
authentication protocols.
7.1+5What is virtual machine? Explain cloud infrastructure.
8.Explain different types of
file systems in detail.
9.2+4What is DHCP? How does it work? Explain.
10.Explain process
controlling and management.
MIT 125 (SN): System and Network Administration — 2023
Master of Information Technology (M.I.T.) / Second Semester / Final (Elective I)
Candidates are required to give their answers in their own words as far as practicable.
The figures in the margin indicate full marks.
Group A 2 × 12 = 24
Answer TWO questions.
1.What is subnet mask? Why
is subnetting needed? Suppose we have 4 departments A, B, C and D, where department A has 23
hosts, B has 16, C has 28 and D has 13 hosts. You are given a network 202.70.91.0/24.
Perform the subnetting so that IP address wastage in each department is minimum and find out
the Subnet mask, Network address, Broadcast address, and usable host range in each
department.
2(a).6What
are domain, tree and forest? Give examples.
2(b).6 What is LDAP and how is it used to access a network
directory?
3(a).2+6What is virtualization and how does it help an organization? Explain types
of virtualizations.
3(b).4 Why is Inetd known as Internet Super Server?
Group B 6 × 6 = 36
Answer SIX questions.
4.How is file system managed
in UNIX and Windows? Explain.
5.What is SAN? Explain the
types of RAID.
6.What are primary and slave
name servers? Write the principles of DNS.
7.Explain the types of OSPF
network in detail.
8.What is mail server?
Explain SMTP, POP and IMAP.
9.Write the differences
between IPv4 and IPv6.
10.Write short note on any TWO:
- a) Virtualization
- b) DHCP server
- c) Disaster recovery plan
MIT 125 (SN): System and Network Administration — 2024
Master of Information Technology (M.I.T.) / Second Semester / Final (Elective I)
Candidates are required to give their answers in their own words as far as practicable.
The figures in the margin indicate full marks.
Group A 2 × 12 = 24
Answer TWO questions.
1.12Given the IP address 10.10.10.0/26, determine the following for each
subnet within this network: (a) Total number of subnets created, (b) The subnet mask used,
(c) The network address of each subnet, (d) The usable IP range for each subnet, (e) The
broadcast address for each subnet.
2.4+4+4Explain the LDAP directory model, including concepts of entries,
attributes and the Directory Information Tree (DIT). How does this model facilitate
directory operations? Explain how LDAP can be integrated with other systems for
authentication and authorization.
3.5+4+3Describe various RAID levels and their impact on data redundancy,
performance and fault tolerance. How do you choose an appropriate RAID level for a given
application? How is data mirroring different from fault tolerance?
Group B 7 × 6 = 36
Answer SEVEN questions.
4.6Explain the architecture of a Storage Area Network (SAN). How do the
components (switches, storage arrays) work together to provide high-speed storage
access?
5.6Describe the process of troubleshooting a DHCP server that is not
assigning IP addresses. What steps would you take to identify and resolve the issue? Include
checks for DHCP server status, network connectivity and client configuration.
6.6What is a backup plan? Why is it required? Explain the types of
backup.
7.6Explain the role and functionality of xinetd in a Unix‑like system. How
does it enhance the management of network services compared to inetd?
8.6Explain the types and roles of virtualization.
9.6What do you mean by forest and domain? What are the components of Active
Directory? Explain.
10.6Explain the functions of Telnet, SSH and SCP commands in Unix with
suitable syntax for each.
MIT 125 (SN): System and Network Administration — 2025
Master of Information Technology (M.I.T.) / Second Semester / Final (Elective I)
Candidates are required to give their answers in their own words as far as practicable.
The figures in the margin indicate full marks.
Group A 2 × 12 = 24
Answer TWO questions.
1.2+6+4What is a file system? Discuss NFS, CIFS, and Samba, including their
purposes and advantages. In what scenarios is one of these file‑sharing protocols more
suitable than the others?
2.4+8What is the role of administrative models in managing network resources?
Explain with appropriate figures how the hierarchical structure of domains, trees, and
forests provides a structured administrative framework.
3.2+5+5What is the function of DNS? Explain with a diagram how a domain name is
resolved using a recursive query. How do DNS zone transfers and DNS delegation contribute to
the operation of DNS?
Group B 6 × 6 = 36
Answer SIX questions.
4.3+3What are the advantages and limitations of using Fibre Channel and iSCSI
in enterprise storage solutions?
5.6What is xinetd? Explain types of disk technology.
6.6What are the advantages and disadvantages of public and private
clouds?
7.6What is a backup plan? Explain types of backup.
8.6What are the key steps involved in the DHCP address allocation
process?
9.2+4What is a routing protocol? Differentiate between RIP and OSPF routing
protocols.
10.6
Write short notes on any TWO:
- a) Upsizing and downsizing
- b) Schema Master
- c) Virtualization
MIT 125 (DBA): Database Administration and Security — 2024
Master of Information Technology (M.I.T.) / Second Semester / Final (Elective I)
Candidates are required to give their answers in their own words as far as practicable.
The figures in the margin indicate full marks.
Group A 2 × 12 = 24
Answer TWO questions.
1.What are the different
types of recovery models in a DBMS and how do they affect the recovery process? Explain the
concept of transaction logs in DBMS. How are they used during the recovery process?
2.What are the key
components of a database security policy, and how do they contribute to safeguarding data?
Explain the role of security procedures in ensuring compliance with database security
policies.
3.What are the key
differences between traditional on-premises databases and cloud-based databases? How does
the scalability of cloud databases differ from that of traditional databases? Discuss the
security challenges associated with cloud-based databases and their mitigation.
Group B 7 × 6 = 36
Answer SEVEN questions.
4.Describe the purpose of
the GROUP BY and HAVING clauses in SQL. Provide an example query for each.
5.What considerations should
be made when choosing storage formats and access methods for a database?
6.What are the conditions
for a relation to be in Boyce-Codd Normal Form (BCNF)? Explain the concept of Fourth Normal
Form (4NF) and compare it with BCNF.
7.Explain the concept of
authentication and authorization with the help of examples.
8.What is modern database
technology? Explain the concept of Big Data and NoSQL database.
9.Explain Database as a
Service (DBaaS) and provide examples of popular DBaaS offerings.
10.Describe how you would
set up an audit logging mechanism to track changes to critical data in a financial database.
What information would you log, and how would you secure the logs?