Sql DDL Statement Set 2

What are the correct statement for changing the datatype of empno number(8) to number(10) ?

ALTER TABLE EMP MODIFY EMPNO NUMBER(10);

ALTER TABLE EMP MODIFY (EMPNO NUMBER(10));

ALTER TABLE EMP RENAME EMPNO NUMBER(10);

ALTER TABLE EMP RENAME( EMPNO NUMBER(10));

What is the command to modify number of columns, like to change EmpNo datatype number(10) to number (12) and Emp_Address char(20) to char(24) of Emp table?

ALTER TABLE Emp
UPDATE (EmpNO number(12),
Emp_Address Char(24);
);

ALTER TABLE Emp
RENAME TO (EmpNO number(12),
Emp_Address Char(24);
);

ALTER TABLE Emp
MODIFY TO (EmpNO number(12),
Emp_Address Char(24);
);

ALTER TABLE Emp
MODIFY (EmpNO number(12),
Emp_Address Char(24);
);

What would be statement to rename the Emplyoee table to emp?

ALTER TABLE Employee RENAME Emp;

ALTER TABLE Employee RENAME to Emp;

ALTER TABLE RENAME Employee to Emp

ALTER TABLE RENAME Employee as Emp

Drop command will delete rows from a table which can be recovered latter .

true

false

Drop a table means deleting the table from data structure.

true

false

Which of among is right command for drop a table named Emp ?

Drop table Emp

Drop Emp

Alter table Drop Emp

Non of these

How to drop a column like Emp_Adress from emp table? Pick the right answer

DROP COLUMN Emp_Address from Emp;

ALTER TABLE Emp DROP COLUMN Emp_Address from Emp;

ALTER TABLE Emp DROP COLUMN Emp_Address;

Non of these

Can we drop multipul table at a time ?

yes

Is it possible to drop more than one column at a time?

yes

How to drop emp_address and deptno from Emp table?

ALTER Emp DROP (deptno, emp_address);

DROP (deptno, emp_address) from Emp;

ALTER TABLE Emp DROP (deptno, emp_address);

Non of these