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 data type).

[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.

    • Posted: 5 years ago
    A+ Answers

    Purchase the answer to view it

    blurred-text
    Save time and money!
    Our teachers already did such homework, use it as a reference!