Describe all the tables you have created.
get table_name, status, num_rows, user_stats in user_tables system view
get table_name, constraint_name, constraint_type in user_constraints or user_cons_columns system view. you need to filter out the records unrelated to our database.
get total record numbers from the following tables: movies, distributed_movie_list, movie_rent_list, customers, orders and order_items.
Compare the numbers of row counts with the num_row in user_tables. See whether any inconsistency.
display title, director_name, company names with one query
display title, actor_name with one query
spool the output to a text file (it should be labeled with your name)