$1.$Create a PL$/$SQL block to declare a cursor to select last name, first name, salary, and hire date from the EMPLOYEE table.$$Retrieve each row from the cursor and print the employees information if the employees salary is greater than $$50,000$ and the hire date is before $31-$DEC$-2012($explicit cursor problem$)\mathrm{.}2.$Create a PL$/$SQL block that declares a cursor.$$Pass a parameter to the cursor of the type that is the same as the Salary column in Employee table to the cursor.$$Open the cursor with a value for the parameter.$$Retrieve information into the cursor for a salary higher than the parameter value.$$Use a loop to print each employees information from the cursor $($cursor with parameter problem$)\mathrm{.}3.$Create a PL$/$SQL block that declares a cursor to update salaries of employees.$$Retrieve each row from the cursor by using for loop$$Alter rows for department id $10$ and during this time, lock related rows.$$Control if salary of the employee is less than $100000,$ give $15\%$ raise. If salary of employee is greater than $100000,$ give $10\%$ raise.$$Display old salaries and new salaries $($explicit cursor problem$)\mathrm{.}4.$Create a PL$/$SQL block that satisfies given properties below.$$Retrieve qualification id as a substitution variable.$$By using given qualification id$,$ display name, surname, salary, and qualification id of employees.$$Handle NO$\_$DATA$\_$FOUND and TOO$\_$MANY$\_$ROWS exceptions.