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

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?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

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. Oracle 1. How many indexes are...

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 Use SELECT * FROM...

USING SQL DEVELOPER Write an SQL query to extract the following information from data dictionary: 1.Find all dictionary views that contain information about indexes. 2.How many indexes are defined on...

I need help writing the code in Codio with the instructions attached. I also attached a screenshot of the error code that I was given. Terminal X mysql> USE QuantigrationRMA; Reading table...

Database Design Report and Implementation - Please ignore requirement for screenshot, just need assistance with the actual SQL queries so I can insert them into the data myself for the output....

PLEASE HELP :) You must have completed all of the steps found in the Oracle 11g Launch document. The queries for this assignment use the 'EliteVideo' Database tables you created in the last module....

Lab 5 Assignment - Basic SQL Query Task 1 ( Customer Information ) : Retrieve all customers' ID , name, and phone ( s ) and display the results as the following output. Note that the results are...

Start Oracle SQL Developer 1. Use SELECT * FROM dictionary; to find all available dictionary views SELECTFROM dictionary; Script Output x Query... x SQL I All Rows Fetched: 3228 in 1.736 seconds...

Objectives: 1. Explore more advanced SQL queries. 2. Answer the questions, copy the SQL code, create screenshots, and submit the results. Submission requirements: For all text and image submissions,...

1. A person deposits 20,000 TL into a time deposit account. The maturity is 92 days. Interest rate is 10%. What is the amount of interest received in 92 days? 2. A person deposits 25,000 TL into a...

Company S is a 70%-owned subsidiary of Company P. Company S is building a ship to be used by Company P. The ship was 40% completed in 2011 and 100% completed in 2012. The actual and budgeted profit...

why the following risk factors are important Risk Factors in International Bond Portfolios vs. Domestic U.S. Bond Portfolios When investing in international bonds , investors face risks not typically...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

6. Are any of the strategic training and development initiatives more important for small business? Explain.

10. How could SWOT analysis be used to align training activities with business strategies and goals?

9. What is human capital? How is human capital influencing the changing role of training from skill and knowledge acquisition to creating and sharing knowledge?