Recent questions and answers in DATABASE MANAGEMENT SYSTEM

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....

State the use of database trigger and also list types of trigger.
Answer : Of course. Here is a clear explanation of the use of database triggers and a list of their different types. --- ### The Use of a Database Trigger A **database trigger** is a ... instead of* the original DML statement, allowing you to define custom logic for updating complex, non-updatable views....