Start the default Oracle database (orcl)
Need help with this assignment?Get an original answer from a qualified tutor — from $10/page.
Get it written →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.
Get a plagiarism-free answer to this question
Send us your instructions and we’ll match you with the best writer in your subject.
- 100% human-written, zero AI
- Turnitin report included
- Confidential — we never share your data
- Free revisions & refunds