Write a query to modify the datatype of the column departmentId from VARCHAR(30) to INT in the table 'department'.Refer to the existing table DLL given below:

How can you change "EmployeeName" column datatype to VARCHAR(50) in an "Employees" table?ALTER TABLE Employees MODIFY EmployeeName VARCHAR(50); CHANGE TABLE Employees MODIFY EmployeeName VARCHAR(50); ALTER TABLE Employees CHANGE EmployeeName VARCHAR(50);None of the above

What is the correct SQL command to change the data type of a column named age in a table named users from INT to VARCHAR(3)?  *1 pointMODIFY TABLE users ALTER COLUMN age VARCHAR(3)ALTER TABLE users MODIFY age VARCHAR(3)ALTER TABLE users CHANGE COLUMN age VARCHAR(3)ALTER TABLE users ALTER COLUMN age TO VARCHAR(3)

Write a query to update the departmentId as "A10" for the details "InformationTechnology" and "E10" for the details "ElectricalElectronicsEngineering" print only the departmentId and details from the department table.

From the given table "dept_det" which has columns as "dept_id", "name1", "manger_id", and "location_id". Write a query to retrieve the manager ID of the department where the department ID is 30.Table name:dept_det Input format :The input records are already prepopulated as per the given requirement.

Create a package named "dept_package".Declare and define the following 4 Procedures in this package.1) Procedure to insert a new record in the department table.    Name : addDepartment    Parameters and their types :        dept_id   department.department_id%type        dept_name  department.department_name%type        dept_block_number  department.department_block_number%type 2) Procedure to delete a department when department id is passed as the input parameter.    Name : deleteDepartment    Parameters and their types :        dept_id   department.department_id%type        3) Procedure to list the details of all departments (id, name and block number) in ascending order based on id.     Name : listDepartment     Parameters and their types :        It uses cursors        dept_details OUT SYS_REFCURSOR        4) Procedure to update a department name (Given the old dept name and new dept name)      Name : updateDepartment      Parameters and their types :        dept_name  department.department_name%type        new_dept_name  department.department_name%type  Note:Do not change the package or procedure nameDo not change the argument count and orderDo not change the output text.Instructions:1. Create the package successfully2. Once the package is created, check the functionality of the procedure using different anonymous block call.3. DO NOT submit the anonymous block. Submit only the CREATE PACKAGE query. SubmitSaveExecutePrevious Submission