CIS 240 week 2 homework

1. To see what databases you have, you can type _____________.
display database:
describe tables,
show databases;
show me the money!

2. I want to create a table called Musicin Oracle or MySQL. What would the first line look like?
do create Music ()
Create TABLE music (
Insert into Music,
describe Music;

3. Is it possible to resize a field after data has been entered into the table?
No
Yes

4. The unique identifier in a table is called the _________
Primary Key
Combined Key
Francis Scott Key
Unique Key

5. What is the proper command line in SQL to bring back all records from a table called student?
show all student, describe student; Insert into Student Values select * from student; Update student, Ug. Student Ug.

6. What is the syntax to retrieve back the field names of the table called student?
show all student, describe student; Insert into Student Values select * from student; Update student, Ug. Student Ug.

7. Which of the following is true about the statement delete from student where lname='perry' ?
The name perry will be erased from the database if the fields allow null values.
All records containing 'perry' as a lname value will be replaced.
Every record except for those who have lname of 'perry' will be erased.
Nothing yet, because you forgot the semi colon.