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
SIKSHAPATH Latest Questions
Create a procedure or function to calculate electricity bill as per the following criteria: For first 100 units: Rs. 5 per unit For 101-150 units: Rs. 7 per unit For 151-300 units: Rs. 7.50 per unit For 301 onward units: Rs. 8 per unit
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
The following table has two attributes A and C where A is the primary key and C is the foreign key referencing A with on-delete cascade. A C —– 2 4 3 4 4 3 5 2 7 2 9 5 6 4 The set of all tuples that must be additionally deleted to preserve referential integrity when ...
Two transactions T1 and T2 are given as: T1: r1(X) w1(X)r1(Y)w1(Y) T2 : r2(Y)w2(Y)r2(Z)w2(Z) where ri(V) denotes a read operation by transaction Ti on a variable V and wi(V) denotes a write operation by transaction Ti on a variable V. Calculate The total number ...