Write a query to find employees whose salary is equal to the salary of at least one employee in department of id 10. Select one: A.SELECT employee_id, salary FROM employeeWHERE salary - (SELECT salary FROM employee WHERE dept_id = 10); B.SELECT empjd, salary FROM employeeWHERE salary ANY (SELECT salary FROM employee WHERE dept_id = 10); C.SELECT emp_id, salary FROM employeeWHERE salary - ALL (SELECT salary FROM employee WHERE dept d = 10): D.SELECT emp_id, salary FROM employeeWHERE salary IN (SELECT salary FROM employee WHERE dept_id = 10) Which SQL statement would you use to remove the row for Book_ID=15 from Book Information table? Select one: A.DELETE FROM Book Information WHERE Book_ID = 15; B.DROP Book_Information WHERE Book_ID = 15 C.TRUNCATE TABLE Book_Information WHERE Book.ID = 15; D.DELETE Book Information WHERE Book.ID = 15 00 Which of the following SQL commands will create a new record with empNo = "001"? Relation schema: Employee (empNo, empName, empAddr, DOB) INSERT INTO Employee VALUES (001 Ali Lokman', 'KL, '30-OCT-1997) IL INSERT INTO Employee (empNo, empName, empAddr, DOB) VALUES (001', 'Ali Lokman', KL, 130-OCT-1997) IL UPDATE Employee SET empName='Ali Lokman', empAddr = 'KL), DOB="30 OCT-1997 WHERE empNo = '001) Select one: AI B.1 & 11 C.1, II & II DINI ed 2.00 7 Assuming a Student table is created with the following CREATE TABLE command. CREATE TABLE Student (StudentNo number, Name varchar2(10). Kulliyyah char(5), Specialization char(5)); To delete the Specialization column in the table above, which command in CORRECT? Select one: A TRUNCATE TABLE Student (COLUMN Specialization) B.DELETE FROM Student (Specialization) C. ALTER TABLE Student DROP COLUMN Specialization D.UPDATE Student SET Specialization = NULL; CREATE TABLE Student (StudentNo number. Name varchar2(10). Kulliyyah char(5) Specialization char(5)); Based on Student table in above, modify the table to add a primary key to the StudentNo column, The table is currently empty Which statement accomplishes this task? Select one: A ALTER Student ADD CONSTRAINT studentno.pk PRIMARY KEY StudentNo, BALTER TABLE Student ADD StudentNo AS PRIMARY KEY, CALTER TABLE Student MODIFY CONSTRAINT studentno pk PRIMARY KEY (StudentNo); DALTER TABLE Student ADD CONSTRAINT studentno.pk PRIMARY KEY (Studento)