Databases | SQL | Oracle | MS Access Answers

Discuss the various PL/ SQL scalar data types available to store specific kinds of data with the use of examples. (10 marks)

Write a program that will ask for a price. If the price is greater than 1000, compute a 10%

discount from the original price. Display the computed discount.

1.     Write a PL/SQL code to print all tables up to a number fetched from a table using implicit cursors.

Find the sum of durations of the videos published by each channel in hours.(sql)

9.

Find the number of videos published between the years 2010 & 2016.

Note:

• Sort the output in the ascending order of the year
• Keep the year in the integer format

Expected Output Format:

yearno_of_videos......

 Consider the transactions:

T₁: R₁(A), W₁(B)

and

T₂: R₂(A), W₂(A), W₂(B)

Suppose we insert a pair of lock and unlock commands for each element of the database that the transactions can access.

• Explain how many concurrent execution schedules, of the two transactions, follow the 2PL protocol.
• Explain whether there are any serializable schedules of concurrent execution of the two transactions that do not follow the 2PL protocol.

Check whether the given schedules are conflict serializable or not

 S1 : R2(B)W2(A)R1(A)R3(A)W1(B)W2(B)W3(B)

S2:R3(Y)W3(Z)R1(X)W1(X)W3(Y)W3(Z)R2(Z)R1(Y)W1(Y)R2(Y)W2(Y)

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

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

Consider the following relation with set of functional dependencies R(ABCDEF) AB->CD, CD->EF, BC->DEF, D->B, CE->F a) Identify the candidate keys in the above relation (with proper steps followed). b) Identify which normal form this relation is in and reason for the answer.