Scribd
Upload
262 views2 pages

This Study Resource Was: Database Programming With PL/SQL 9-3: Practice Activities

The document discusses the Oracle database data dictionary and practice activities related to it. It defines key terms like data dictionary, DBA_ tables, ALL_ tables, and USER_ tables. It then provides questions and solutions for querying the data dictionary to retrieve information about database objects.

Uploaded by

imhereforanswers2
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
262 views2 pages

This Study Resource Was: Database Programming With PL/SQL 9-3: Practice Activities

The document discusses the Oracle database data dictionary and practice activities related to it. It defines key terms like data dictionary, DBA_ tables, ALL_ tables, and USER_ tables. It then provides questions and solutions for querying the data dictionary to retrieve information about database objects.

Uploaded by

imhereforanswers2
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

www.oracle.

com/academy

Database Programming with PL/SQL


9-3: Review of the Data Dictionary Practice Activities
YASHUB ARMANDO GUZMAN ESPINOZA 1630123
Vocabulary
Identify the vocabulary word for each definition below:

Contain information about everything in the database, no matter


DBA_* TABLES who owns them.

m
er as
Contain information about objects which you have privileges to
ALL_* TABLES use.

co
eH w
A catalog of all database objects contained in an Oracle

o.
DATA DICTIONARY database.
rs e
ou urc
USER_* TABLES Contain information about objects you own.
o

Try It / Solve It
aC s
vi y re

1. Which of the following statements are true:


A) The Data Dictionary is a list of hard coded table names in all Oracle databases.
B) The Data Dictionary can be updated by all users with Select statements.
C) All users of an Oracle Database can see details of all tables in that database.
ed d

D) The Data Dictionary is owned by the user called SYS.


ar stu

2. List the three different classes of Data Dictionary views, and state what kind of
information is shown by each class.
is

- User_procedures
Th

Procedimientos hechos

- User_source
sh

Código fuente de funciones y procedimientos

- User_tables
Descripción de tablas

This study source was downloaded by 100000822525108 from CourseHero.com on 04-29-2021 09:43:08 GMT -05:00

https://www.coursehero.com/file/42753233/PLSQL-9-3-Practice-1630123pdf/
3. Write and execute a SELECT statement that lists all the stored objects you have created
in your account so far. The query should return the object name, its type, and its status.
Order the output by type of object.

SELECT object_name, object_type, status


FROM user_objects
ORDER BY object_type;

4. Modify the query from question 3 to show only functions and procedures to which you
have access. Add the owner of the object to display in the results.

SELECT owner, object_type, procedure_name


FROM all_procedures
WHERE object_type LIKE 'FUNC%';

SELECT sequence_name,sequence_owner

m
FROM all_sequences;

er as
co
eH w
5. What is DICT and why is it useful?

o.
rs e
Super vista que muesra todas las tablas del diccionario
ou urc
6. Write and execute a suitable SELECT…FROM DICT… statement to list dictionary views
o

which contain information about all views which you own.


aC s
vi y re

SELECT *
FROM DICT
WHERE table_name LIKE 'USER%VIEW%';
ed d
ar stu
is
Th
sh

This study source was downloaded by 100000822525108 from CourseHero.com on 04-29-2021 09:43:08 GMT -05:00

https://www.coursehero.com/file/42753233/PLSQL-9-3-Practice-1630123pdf/
Powered by TCPDF (www.tcpdf.org)

You might also like