(d) Use the correct Data Dictionary View to display the following information regarding your
database (submit a printout of the report â€“ refer back to the lesson dealing with Spooling of
information to the printer).
Display information regarding the following objects created by the user STUDENT:
(select view_name from user_views
(select sequence_name, min_value, increment_by from user_sequences
(select constraint_name, constraint_type from user_constraints where owner =
Basically, you need to run three queries and submit the printouts (paste into assignment):
select view_name from user_views;
select sequence_name, min_value, increment_by from user_sequences;
select constraint_name, constraint_type from user_constraints where owner =
If I recall correctly, the previous questions where about schema changes, printing the results is a way to verify that you did it correctly.
Angela, I'm expect it will be fine if you copy and paste. But here is a few links that explain how to spool. Basically, the command is "SPOOL filename.log;" followed by your queries. To end the spooling, "SPOOL OFF;"