Question: Assume that employee is the table name. Identify the SQL query to delete all the rows from the table employee a. Truncate from employee b.
Assume that employee is the table name. Identify the SQL query to delete all the rows from the table employee a. Truncate from employee b. Truncate table employee c. Delete* from employee d. Delete from table employee Identify the SQL query which will change the column size from 5 to 7 for the column accbalance in the table HSBC a. alter table HSBC alter (accbalance number(7)) b. alter table HSBC modifycolumn (accbalance number(7)) c. alter table HSBC change (accbalance number(7)) d. alter table HSBC modify (accbalance number(7))
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
