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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!