Diksha IT Training Centre

SQL QUIZ with Answer Part 1. Hello Everyone, Today I will start SQL quiz part 1 , this is important for those guys who is preparing for OCA(Oracle certified Associate) certification. I suggest you to go through my previous Oracle SQL blogs from archive folder May and June for your reference. Dheeraj60.blogspot.com Let’s start with Quiz: 1. The employee table contains these columns: Last_name Varchar (25) First_name Varchar (25) Salary INT You need to display the names of employees on more than an average salary of all employees. Evaluate the SQL statement. SELECT, LAST_NAME, FIRST_NAME from employee where salary< avg(salary);   Which change should you make to achieve the desired results? A. Change the function in the Where clause. B. Move the function to the select clause and add a group clause. C. Use a sub query in the where clause to compare the average salary value. D. Move the function to the select clause and add a group by clause and a having clause.   Ans