??Mcqs were from Topics ERD, rollback , save point, SQL full form, which variable is used with %and _ sign (LIKE), entity, PL/SQL mandatory part etc. ??Short Question ??Write a query that select employee name that start with letter G and end with at least two letters K and deptno should be 30 and salary must be at least 1500 ??A block of pl/sql code was given and had to write the output.. ??Long Question ??Suppose in the middle of large transaction, one update statement fails due to some violation.. and it give the roll back or rollback to save point.. explain the difference between these.. ??Had to write a query of age in ascending order and if the grades were all same right it in descending order also explain the order by clause effect in it..