marți, 24 noiembrie 2009

Quiz: Basic Table Modifications


1. The SQL statement ALTER TABLE EMPLOYEES DROP COLUMN SALARY will delete all of the rows in the employees table. True or False?
True
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
WHERE STATE=’FL’;
how many rows will be left in the table?
0
1 (*)
2
3

Niciun comentariu:

Trimiteţi un comentariu