the lable consultant given below. Table: consultant id name gender dol 1001 Kristen F 20-Jan-19 1002 Army M 22-Feb-18 1003 Evan F 12-Sep-19 1994 Robert M 8-Apr-19 dob 5-Jan-92 19-Mar-92 21-Jul-93 16-Aug-92 mobnumber 8789631235 NULL NULL 9876584912 Query: UPDATE consultant SET name='Jack', dob='21-DEC-93' WHERE id = 1004; UPDATE consultant SET mobnumber = '7856341890', gender='F' WHERE id = 1002; DELETE FROM consultant WHERE gender = 'M'; SELECT * FROM consultant; Which of the following statement will be TRUE after executing the above queries sequentially? O There will be two employees bom in December There will be only one male employee There will be two employees bom in 1992 O All the employees will have mobnumber OBJECTIVE QUESTIONS ective Consider the table structure for the table student given below Column Name id name gender dob Constraint NOT NULL Data type and size NUMBER(5) CHAR(10) CHAR(10) DATE NUMBER(2) 6 age Following ALTER statements are successfully executed on this table sequentially. ALTER TABLE student ADD emailid VARCHAR2(20); ALTER TABLE student MODIFY gender CHAR(1); ALTER TABLE student DROP (age); Which of the below INSERT statement will execute successfully on the modified student table? INSERT INTO student VALUES(10001,'Rony','Male', '12-JAN-95', rony@abc.com'); O INSERT INTO student VALUES(10001,"Rony. M', '12-JAN-95), 'rony@abc.com); INSERT INTO student VALUES(10001, 'Rony', 'M','12-JAN-95,23, rony@abc.com'); ve bonus 400 empid 1 2 3 4 5 empname John Michael John Mike Robert Robert Peter Carl empsalary 27000 20000 40000 50000 25000 300 600 700 NULL 300 NULL NULL projecturit ECSADM IVS ECS ECS IVS IVS ECS ECSADM 20000 7 8 30000 27000 Query: SELECT projectunit, AVGsmpsalary) AVGSAL, SUM(bonus) TOTALBONUS FROM employeedetail GROUP BY projectunit HAVING AVG(empsalary) > 20000 AND SUM(bonus) > 500, How many rows will be fetched when the above query is executed? 2 ESTIONS custid C9012 C9022 C9032 C9042 C9052 C9062 Custname Maria William Robert Jenny Eliza Jane sender F M custtype Regular Privileged Regular Privileged Elite Regular M bilid 7001 7201 7401 7601 7801 7501 F F custid C9052 09042 C9022 C9032 C9012 C9052 billamount 860 962 720 1002 515 430 billdate 17-Oct-18 11-Oct-18 11-Sep-18 17-Oct-18 22-Sep-18 11-Sep-18 F Query: SELECT c.custname FROM customer INNER JOIN purchase p ON c.custid = p.custid WHERE billamount > 700; Which of the following cusinante value will NOT be present in the output when the query given above is executed? Eliza Robert O Jenny Maria