If in Table “employee”, a column “emp_id” consists of {1,2,2,2,3,3,5,6,7,8,8} then what will be the output on executing the following query?SELECT DISTINICT emp_idFROM employee;[1,2,2,3,3,5,6,7,8,8][1,2,3,5,6,7,8][1,2,2,3,5,6,7,8]None of the mentionedReview AnswerNext

employee_id Name Salary1001 Annie 60001009 Ross 45001018 Zeith 7000above are the Employee table details.select employee_id from employee order by employee_id desc;Which of the following output will be true?

Consider the table Employee given below: EmpId EmpName Salary DeptId200 Alex 30000 100201 Tom 20000 101202 Dick 40000 100202 Harry 15000 102205 Mary 50000 101206 Karl 40000 101SELECT EmpName FROM Employee WHERE Salary > ALL (SELECT Salary FROM Employee WHERE DeptId = 100);What will be the outcome of the query given above?

What is the output of the following SQL query? This question is required.*SELECT LOWER('Hello, World!') AS Result;A"hello, world!" Data with column name ‘LOWER(‘Hello, World!’)’.B"HELLO, WORLD!"C"hello, world!" With column name ‘Result’D"H,e,l,l,o, ,W,o,r,l,d,!"

Given below two tables:EmpRoom (EmpID, EmpName, Department, RoomID)(101, Tanaka, A1, 110), (102, Suzuki, A1, 111), (103, Saito, A2, 203), (104, Fukuda, A2, 201), (105, Oohira, A2, 202)RoomMgnt (RoomID, Department)(110, A1), (111, A1), (201, A2), (202, A2), (203, A2)Which are the outputs of the below SQL statement on the two tables:SELECT EmpName FROM EmpRoomWHERE RoomID NOT IN ( SELECT RoomID FROM RoomMgnt WHERE Department='A1');Saito, Fukuda, OohiraTanaka, SuzukiFukuda, OohiraTanaka, Suzuki, Saito

Suppose that the Employee table has n rows (n> 1). SELECT e1.name, e2.name FROM employee e1, employee e2 What is the result of the query?n x n [records]n [records]0 [record]n+1 [records]