Which of the following is not legal? a) SELECT SYSDATE – SYSDATE FROM DUAL; b) SELECT SYSDATE – (SYSDATE – 2) FROM DUAL; c) SELECT SYSDATE – (SYSDATE + 2) FROM DUAL; d) None of the Mentioned

Which one of the following is a true statement? a. Cell reference $A1 is an absolute cell reference b. Cell reference $A1 is a mixed cell reference with row fixing c. Cell reference A$1 is a mixed cell reference with row fixing d. Cell reference A$1 is a mixed cell reference with column fixing

The client wants pseudocode for calculating students GPA that he believes has bugs in it. Find all logicalerrors in the provided pseudocode and provide the following information in your report:i) The number of logic errors in the provided code.ii) Your client is not a software developer, to help them understand the problem, describe what alogic error is.iii) Which line of code does the logic error occur in.iv) Fix the logic error and provide the fixed code.v) Describe why the code was changed to resolve the logic error

. Write a stored procedure named printOrderFreights(). The printOrderFreights()procedure should use cursor processing to find those orders whose freight is less than or equal to 0.2 and then print the “Freight is less than or equal to $0.2” message for each and every row that satisfies the condition. Hint: You need to use cursor processing for this stored procedure. Hint: Follow the 5 steps of cursor processing and declare any variables needed.