0

Asked: November 16, 2021In: DBMS

Create a package which contains function to ask the user to enter the student’s marks and determine the GRADE according to the following criteria. >90 A >80AND 70AND 60 AND<70 D <60 F

0

Create a package which contains function to ask the user to enter the student’s marks and determine the GRADE according to the following criteria. >90 A >80AND <90 B >70AND <80 C >60 AND<70 D <60 F

1

AK

Asked: November 15, 2021In: DBMS

Create table named emp have two column id and salary with number datatype. Insert the value into the table created using procedures.

1

Create table named emp have two column id and salary with number datatype. Insert the value into the table created using procedures.

1

practice503

Asked: November 15, 2021In: DBMS

Create a trigger that checks if “value” is greater than 1000 for any new row inserted to “Test” table, then insert a row to Audit table?

1

Create a trigger that checks if “value” is greater than 1000 for any new row inserted to “Test” table, then insert a row to Audit table?

3

A.S

Asked: November 15, 2021In: DBMS

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

3

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

0

A.S

Asked: November 15, 2021In: DBMS

triggers

0

Apply a trigger on relation client (sno, fname, lname, eid, and password) on attributes fname and password after/before delete or update these columns. The trigger should insert the old or deleted values from both these columns into a new table ...

1

ANAN

Asked: November 14, 2021In: DBMS

Create a package with procedure that shows the usage of the WHILE loop to calculate the average of input numbers.

1

Create a package with procedure that shows the usage of the WHILE loop to calculate the average of input numbers.

Sign Up

Sign In

Forgot Password

SIKSHAPATH Latest Questions

Create a package which contains function to ask the user to enter the student’s marks and determine the GRADE according to the following criteria. >90 A >80AND 70AND 60 AND<70 D <60 F

Create table named emp have two column id and salary with number datatype. Insert the value into the table created using procedures.

Create a trigger that checks if “value” is greater than 1000 for any new row inserted to “Test” table, then insert a row to Audit table?

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

triggers

Create a package with procedure that shows the usage of the WHILE loop to calculate the average of input numbers.