Start the default Oracle database

  

1. Start the default Oracle database (orcl) or the one you created in lab 3. For this assignment you will use either the SQL*Plus Worksheet interface or the console interface for SQL.
 

SQL*Plus Worksheet
 

SQLPlus Command Line Interface
 

2. Once in the SQL interface, write the SQL statements (and record them here) to perform the following:
a. Create a table named movies, with columns of movie_ID, name, genre, and release date (choose the appropriate datatype).
 

[INSERT SQL STATEMENT HERE]  

b. Get a description of the movies table.
 

[INSERT SQL STATEMENT HERE]  

3. Take a snapshot of the results of the statement in 2b and paste it here.
 

4. Write the SQL statements (and record them here) to perform the following:
a. Change the movies table to include runtime in minutes (hint: just use an integer).
 

[INSERT SQL STATEMENT HERE]  

b. Get a description of the table movies.
 

[INSERT SQL STATEMENT HERE]  

5. Take a snapshot of the results of the statement in 4b and paste it here.
 

6. Save and upload this completed lab to the link as instructed in the assignment.

Tags: No tags