1. The SQL statement ALTER TABLE EMPLOYEES DROP COLUMN SALARY will delete all of the rows in the employees table. True or False?
2. What will the following statement do to the employee table?
ALTER TABLE employees ADD (gender VARCHAR2(1))
Add a new row to the EMPLOYEES table
Rename a column in the EMPLOYEES table
Change the datatype of the GENDER column
Add a new column called GENDER to the EMPLOYEES table (*)
3. The f_customers table contains the following data:
ID Name Address City State Zip
1 Cole Bee 123 Main Street Orlando FL 32838
2 Zoe Twee 1009 Oliver Avenue Boston MA 02116
3 Sandra Lee 22 Main Street Tampa FL 32444
If you run the following statement,
DELETE FROM F_CUSTOMERS
how many rows will be left in the table?