What do you mean by concurrency control techniques? Write the comparison between single user and multi-user system. What do you mean by Transaction? Write the ACID property of Transaction. What is the need of concurrency control. Explain the lost update problem and dirty read problem. Describe the problem faced when concurrent transaction are executing in … Read more
Write a short note on decomposition. Write a note on Normalization. What do you mean by lossless join? Explain. What do you mean by dependency preservation? Define Functional Dependency ? What do you mean by Lossless Decomposition? Explain with a suitable example how functional dependencies can be used to show that decomposition are lossless. What … Read more
What is Application Layer? Explain. Write a note on FTP. Also write its advantage and disadvantage. How does FTP work? Differentiate between passive and active FTP. Write a note on HTTP. Also write its advantage and disadvantage. Write a note on email. Explain about e-mail architecture and service. Classify the e-mail program. Explain different basic … Read more
What is transport layer? Explain in brief. Draw the diagram of TCP header and explain the use of following: Source and destination port address. Sequence and acknowledgement numbers. Code bits 4. Window bits 5. Urgent pointer. Write a note on UDP. What is the different between TCP and UDP. What is UDP? What is maximum … Read more
In this tutorial we have covered most important questions asked in semester exam from unit and topic Medium Access sub-layer (Data Link Layer).