Question: 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

USING SQL DEVELOPER

USING SQL DEVELOPER Write an SQL query to extract the following information

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 OE.CUSTOMERS table? (Hint: all views have meaningful name, just search the page)

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

4.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

5.From your standpoint what is the most useful Oracle data dictionary view/table/procedure. Describe it and provide examples.

Worksheet Query Builder select. from ctionary x Explain Plan X Query Result x Script Output t SQL All Rows Fetched: 3124 in 0,999 seconds E TABLE NAME COMMENTS i DBA CONS: COLUMNS Information about accessible columns in constraint definition 2 DBA LOG GROUP COLUMNS Information about columns in log group definitions 3 DBA LOBS Description of LOBs contained in all tables 4 DBA CATALOG All database Tables, Views, Synonyms, Sequences 5 DBA CLUSTERS Description of all clusters in the database

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. Start Oracle SQL Developer 1....

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...

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...

DO USING SQL DEVELOPER. SELECT PLAN_TABLE_OUTPUT FROM TABLE (DBMS_XPLAN.DISPLAY()); Or in SQL developer click Explain Plan (F10) icon on the toolbar. Example using EXPLAIN PLAN EXPLAIN PLAN FOR...

First visit HYPERLINK "http://www.tdan.com/view-articles/5174/" http://www.tdan.com/view-articles/5174/ and learn what data related business rules are. Business rules are precisely written and...

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...

1. A database stores A) data B) relationships C) applications D) Both A and B are correct 2. It allows changing data storage structures and operations without change the DBMS access programs because...

True-False Questions 1. Normalizing accounting data refers primarily to eliminating errors and outliers, thus creating ?normal data.? 2. An important reason for normalizing data is to eliminate data...

CIS 620/B Project Plan For the Global Collaboration Enterprise Information System 1200 12th Avenue, Suite 1200 Seattle, Washington 98114 U.S.A. November 11, 2015 Draft Version 19.0 November 11, 2015...

Get a annual report of a company in Ghana ,i.e either listed or unlisted on the ghana stock exchange and write a page report on the following assumptions used in used to prepare the finacial report...

Alice White has arranged to buy some home recording equipment. She estimates that it will have a 5-year useful life and no salvage value . The dealer, who is a friend, has offered Alice two...

List four factors a professional accountant must take into account to exercise ethical professional judgement. 2 ) When might the continuity assumption not be valid? 3 ) How does relevance relate to...

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

1. What factors lead to variations in demand for rooms at a hotel such as the Accra Beach?

3. What are the key considerations facing the hotel as it reviews the booking requests from the West Indies Cricket Board1?

2. Identify the various market segments currently served by the hotel. What are the pros and cons of seeking to serve customers from several segments?