Lab Instructions Write an SQL query to extract the following information from da

Question

Lab Instructions
Write an SQL query to extract the following information from data dictionary:
For each question you need to submit query and screenshot with results.
Start Oracle SQL Developer
1.   Use SELECT * FROM dictionary; to find all available dictionary views.

2.   Find all dictionary views that contain information about indexes.

3.   How many indexes are defined on OE.CUSTOMERS table? (Hint: all views have meaningful name, just search the page)

4.   For each index you found in #3 how many distinct keys?

5.   Use V$...stat views to find information about "free memory" and "DB time"
Hint: DB time is system parameter
free memory is SGA (System Global Area) parameter

6.   From your standpoint what is the most useful Oracle data dictionary view/table/procedure. Describe it and provide examples.
Include your code and results of the execution

What kind of information do you need?

Explanation / Answer

1.select * from all_mviews

2.SELECT object_name FROM user_objects WHERE object_type = 'Table_name' ORDER BY object_name

3.based on size of the cluster are define the views

4.SELECT DISTINCT column_name FROM table_name WHERE column_name IS NOT NULL

5.select HOST_NAME from v$instance

6.views are very useful to view the table data like window format.its support to packages,trigger,etc.

Related Questions

Navigate

• Browse (All)
• Browse L
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.