5. Match the SQL views on the left with their common usage on the right 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. DBA_TABLESPACES DBA_USERS DBA_PROFILE DBA_TS_QUOTAS DBA_SEGMENTS DBA_DATA_FILES DBA_TABLES V$SESSION DBA_FREE_SPACE DBA_OBJECTS DBA_EXTENTS A. The maximum number of CPU minutes a person can use in a session. B. C. D. E. F. G. I. J. The owners and names of all tables and indexes in the database. K. A list of all users who have accounts on the database. The name of each data file along with its assigned tablespace. A list of the total number of bytes used in each tablespace. H. A list of the total number of bytes available in each tablespace. The values generated by the ANALYZE TABLE statement. A list of all users currently logged into the database. The date on which a table was created The default storage parameters for all tables created in a tablespace. The file id indicating on which file each extent in a segment resides.
5. Match the SQL views on the left with their common usage on the right 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. DBA_TABLESPACES DBA_USERS DBA_PROFILE DBA_TS_QUOTAS DBA_SEGMENTS DBA_DATA_FILES DBA_TABLES V$SESSION DBA_FREE_SPACE DBA_OBJECTS DBA_EXTENTS A. The maximum number of CPU minutes a person can use in a session. B. C. D. E. F. G. I. J. The owners and names of all tables and indexes in the database. K. A list of all users who have accounts on the database. The name of each data file along with its assigned tablespace. A list of the total number of bytes used in each tablespace. H. A list of the total number of bytes available in each tablespace. The values generated by the ANALYZE TABLE statement. A list of all users currently logged into the database. The date on which a table was created The default storage parameters for all tables created in a tablespace. The file id indicating on which file each extent in a segment resides.
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
Related questions
Question

Transcribed Image Text:5.
Match the SQL views on the left with their common usage on the right
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
DBA_TABLESPACES
DBA USERS
DBA_PROFILE
DBA_TS_QUOTAS
DBA_SEGMENTS
DBA_DATA_FILES
DBA_TABLES
V$SESSION
DBA_FREE_SPACE
DBA_OBJECTS
DBA EXTENTS
A. The maximum number of
CPU minutes a person can
use in a session.
B.
C.
D.
E.
F.
G.
H.
I.
J.
K.
The owners and names of all
tables and indexes in the
database.
A list of all users who have
accounts on the database.
The name of each data file
along with its assigned
tablespace.
A list of the total number of
bytes used in each
tablespace.
The values generated by the
ANALYZE TABLE statement.
A list of all users currently
logged into the database.
A list of the total number of
bytes available in each
tablespace.
The date on which a table
was created
The default storage
parameters for all tables
created in a tablespace.
The file id indicating on which
file each extent in a segment
resides.
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images

Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you

Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education

Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON

Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON

Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education

Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON

Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON

C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON

Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning

Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education