Explain the following with the help of an example.
(a) Stored Procedures and Triggers
(b) Embedded SQL
See Answer →
Design a generalization /specialization hierarchy for a University Admission System. The University has many programmes, each programme has a specific duration. Registration into a programme requires students to register for many subjects of that Programme. The eligible students can take fresh admission or can re-register in the courses by paying the requisite fee.
Justify your placement of attributes at each level of the hierarchy. Convert the diagram into tables with integrity constraints for each table.
See Answer →Explain how digital signatures are used in the context of network security. What are the uses of digital signatures?
See Answer →Explain the Diffie-Hellman algorithm. Also, explain an example of its use. (6 Marks)
See Answer →What are the security considerations of WWW? Discuss the use of SSL and S-HTTP for web security.
See Answer →Explain the TCP segment header with the help of a diagram. Explain the process of TCP connection establishment using a three-way handshake mechanism. Also, explain the TCP flow control with the help of an example.
See Answer →Apply Dijkstra’s Shortest path algorithm to find the shortest path from a source node A to all the other nodes in a graph given below:
Explain the IEEE 802.11 protocol stack with the help of diagrams.
See Answer →What is the purpose of Routing algorithms? Explain the link state routing algorithm with the help of an example.
See Answer →Explain different versions of the CSMA protocol. Also, explain the CSMA/CD with the help of diagrams.
See Answer →Explain the ALOHA and Slotted ALOHA. Also, derive the expression for computing the throughput for ALOHA and Slotted ALOHA. How does throughout change with load in ALOHA? Explain with the help of a diagram.
See Answer →Explain the concept of Digital-to-Digital encoding. Sketch the Differential Manchester coding and RƵ encoding of the following bit stream:
See Answer →Find CRC for the data polynomial with the generator polynomial
What are the Basic types of errors during data transmission, explain with the help of an example.
See Answer →Explain one technique each for Analog to Digital modulation and Digital to Analog modulation with the help of diagrams.
See Answer →Discuss in detail the Process management, Memory management, I/O & File management and Security and Protection in Windows-11 Operating System.
See Answer →Explain the difference between scheduling and allocation of processor resources in a multiprocessor operating system. Identify the counterpart of each, if any, in a uniprocessor operating system. (1
See Answer →Describe why authentication is important for file protection.
See Answer →List the security attacks that cannot be prevented by encryption.
See Answer →Write and explain the Banker’s algorithm. Consider the following snapshot of a system
| Allocation | Max | Available | ||||||||||
| A | B | C | D | A | B | C | D | A | B | C | D | |
| PO | 0 | 0 | 1 | 2 | 0 | 0 | 1 | 2 | 1 | 5 | 2 | 0 |
| P1 | 1 | 0 | 0 | 0 | 1 | 7 | 5 | 0 | ||||
| P2 | 1 | 3 | 5 | 4 | 2 | 3 | 5 | 6 | ||||
| P3 | 0 | 6 | 3 | 2 | 0 | 6 | 5 | 2 | ||||
| P4 | 0 | 0 | 1 | 4 | 0 | 6 | 5 | 6 | ||||
Answer the following questions using Banker's algorithm:
i. What is the content of the matrix need?
ii. Is the system in a safe state?
iii.If a request from P1 arrives for (0, 4, 2, 0), can the request be granted immediately?