Create a row trigger which ensures that whenever salary is updated in the emp table, then some message is displayed to the user and if new salary is lesser than old salary display the difference between both the salaries.

5

Berlin

Asked: November 19, 2021In: DBMS

State the purpose of the checkpoint mechanism. How often should checkpoints be performed? How does the frequency of checkpoints affect. a. System performance when no failure occurs b. The time it takes to recover from a system crash c. The time it takes to recover from a disk crash

5

State the purpose of the checkpoint mechanism. How often should checkpoints be performed? How does the frequency of checkpoints affect. a. System performance when no failure occurs b. The time it takes to recover from a system crash c. The time it takes ...

0

Ayana

Asked: November 18, 2021In: DBMS

Consider a database table T containing two columns X and Y each of type integer. After the creation of the table, one record (X=1, Y=1) is inserted in the table. Let MX and My denote the respective maximum values of X and Y among all records in the table at any point in time. Using MX and MY, new records are inserted in the table 128 times with X and Y values being MX+1, 2*MY+1 respectively. It may be noted that each time after the insertion, values of MX and MY change. What will be the output of the following SQL query after the steps mentioned above are carried out? SELECT Y FROM T WHERE X=7;

0

DBMS assignment

0

AK

Asked: November 17, 2021In: DBMS

List % ROWTYPE and TYPE RECORD along with their applications.

0

List % ROWTYPE and TYPE RECORD along with their applications.

Sign Up

Sign In

Forgot Password

SIKSHAPATH Latest Questions

List % ROWTYPE and TYPE RECORD along with their applications.

Write a trigger to ensure that no employee of age less than 25 can be inserted in the database.

Create a row trigger which ensures that whenever salary is updated in the emp table, then some message is displayed to the user and if new salary is lesser than old salary display the difference between both the salaries.

State the purpose of the checkpoint mechanism. How often should checkpoints be performed? How does the frequency of checkpoints affect. a. System performance when no failure occurs b. The time it takes to recover from a system crash c. The time it takes to recover from a disk crash

List % ROWTYPE and TYPE RECORD along with their applications.