Write notes on OSI Model ?
Answer : --- ### **1. Introduction** * **Definition:** A conceptual framework used to describe the functions of a networking system. * **Developer:** International Organization for Standardization (* ... from IPv4 to IPv6) doesn't require changing the other layers (like your cables or applications)....

Write SQL command for following i)Create user ii) Grant privileges to user. Iii) Remove privileges from user.
Answer : Of course. Here are the SQL commands for creating a user, granting privileges, and removing privileges, along with explanations and examples. These commands fall under **DCL (Data Control Language)** and are ... ), but any attempt to `INSERT` a new row will result in a "permission denied" error....

Write a PL/SQL program to calculate factorial of a given number.
Answer : Of course. Here is a complete PL/SQL program to calculate the factorial of a number, including detailed explanations and examples of how to run it. A factorial of a non-negative integer `n`, denoted by `n!`, is the ... ----------------- PL/SQL procedure successfully completed. ```...

i) Write a command to create table student(RNO,name marks, dept) with proper datatypes and RNo as primary key ii) Write a command to create and drop sequence.
Answer : Of course. Here are the commands and explanations for creating a table and managing a sequence. --- ### i) Command to Create a `student` Table This command will create a table named `student` ... Once dropped, the sequence cannot be recovered, and any code that refers to it will produce an error....

Explain recovery techniques with example.
Answer : Of course. Here is a detailed explanation of database recovery techniques, starting with the foundational concept of the transaction log and then moving to specific techniques with a complete example. --- ... from `T2` are present, and the uncommitted changes from `T3` have been completely removed....