Examine the description of the STUDENTS table: STD_ID NUMBER (4)COURSE_ID VARCHAR2 (10)START_DATE DATEEND_DATE DATETo rename column end_date as EOD which command should be executed?Alter table STUDENTS rename column end_date to EOD;Rename column end_date to EOD;You can not change column name after table is createdAlter table STUDENTS rename end_date to EOD;

You need to modify the STUDENTS table to add a primary key on the STUDENT_ID column. The table is currently empty. Which statement accomplishes this task?

Which of the following options is not correct?Select one:a.alter table emp modify name varchar(30);b.alter table emp drop column column_name;c.alter table emp drop column_name;d.alter table emp add column_name varchar(25);

Which keyword must be used in below query to rename the field name?SELECT name ____ instructor_name, course_idFROM instructor, teacherWHERE instructor.ID= teacher.ID;AsJoinFromRename

Which of the following options is not correct?Select one:a.alter table emp drop column column_name;b.alter table emp modify name varchar(30);c.alter table emp add column_name varchar(25);d.alter table emp drop column_name;

Write a query to rename table 'station' to 'station_details'.Note:This ‘station’ table perform operation on ‘station’ table. So ensure the table ‘station’ already created and exists in the database.If you get an error like ‘station’ does not exist. Then go back to first query and execute that create table query once and come back to this query.Table name to be renamed and the new table name must be specified without any mistake.If you specified wrong table name while creating the table, but if there is no syntax error then obviously the table will get altered but it will not get Accepted.In this case, rename the table again with correct query and get it Accepted.