SQL REVIEW QUESTIONS VERSION 2 CH 12 MANAGING
OBJECTS WITH DATA DICTIONARY VIEWS CH 11 USING
THE SET OPERATORS | FROM QUESTION TO PERFECTION|
STUDY WITH CONFIDENCE!
Course Code:
Course Title:
Programme:
Academic Year: 2026/2027
Duration: 2 Hours
Total Marks: 70%
Candidate Instructions:
1) Write your Registration Number on every answer booklet used.
2) Answer ALL questions in Section A and ANY TWO (2) questions in Section B.
3) Read each question carefully before answering.
4) Begin each question on a new page.
5) The marks for each question are indicated in brackets.
6) This paper consists of several printed pages, including this page.
7) Ensure your copy is complete before the examination begins.
8) Unauthorized materials and communication with other candidates are not permitted.
Turn Over.
APPHIA – Crafted with Care and Precision for Academic Excellence.
1
, what is the data dictionary?
1
(ch 11 starts on card 64) Answer: a collection of database tables and views.
every object created by every user
the result of what is stored in the dictionary?
2 Answer: each Data Definition Language (DDL) statement studied thus far.
how is this information managed?
3 Answer: automatically by the Oracle system and in real time
is a view an object?
4 Answer: yes and there fore its stored in the dictionary. so are indexes and sequences
Structure.
what is the structure of the data dictionary?
5 Answer: tables and views owned by the user SYS.
Speaking of SYS, no one should ever alter data owned by SYS or integrity will be
compromised.
All data dictionary info is stored in what and mostly presented to users in what?
6 Answer: Stored in tables.
Presented in views for integrity
Users dont explicitly update any info in the database, how is it done?
7 Answer: Automatically triggered by every DDL statement and handled by the oracle system.
Common data dictionary prefixes.
USER_
8 Answer: Objects owned by the current user accessing the view
ALL_
9 Answer: Objects owned by any user in the database to which the current user has privileges
DBA_
10 Answer: All objects in the database
V_$
V$
APPHIA – Crafted with Care and Precision for Academic Excellence.
2
OBJECTS WITH DATA DICTIONARY VIEWS CH 11 USING
THE SET OPERATORS | FROM QUESTION TO PERFECTION|
STUDY WITH CONFIDENCE!
Course Code:
Course Title:
Programme:
Academic Year: 2026/2027
Duration: 2 Hours
Total Marks: 70%
Candidate Instructions:
1) Write your Registration Number on every answer booklet used.
2) Answer ALL questions in Section A and ANY TWO (2) questions in Section B.
3) Read each question carefully before answering.
4) Begin each question on a new page.
5) The marks for each question are indicated in brackets.
6) This paper consists of several printed pages, including this page.
7) Ensure your copy is complete before the examination begins.
8) Unauthorized materials and communication with other candidates are not permitted.
Turn Over.
APPHIA – Crafted with Care and Precision for Academic Excellence.
1
, what is the data dictionary?
1
(ch 11 starts on card 64) Answer: a collection of database tables and views.
every object created by every user
the result of what is stored in the dictionary?
2 Answer: each Data Definition Language (DDL) statement studied thus far.
how is this information managed?
3 Answer: automatically by the Oracle system and in real time
is a view an object?
4 Answer: yes and there fore its stored in the dictionary. so are indexes and sequences
Structure.
what is the structure of the data dictionary?
5 Answer: tables and views owned by the user SYS.
Speaking of SYS, no one should ever alter data owned by SYS or integrity will be
compromised.
All data dictionary info is stored in what and mostly presented to users in what?
6 Answer: Stored in tables.
Presented in views for integrity
Users dont explicitly update any info in the database, how is it done?
7 Answer: Automatically triggered by every DDL statement and handled by the oracle system.
Common data dictionary prefixes.
USER_
8 Answer: Objects owned by the current user accessing the view
ALL_
9 Answer: Objects owned by any user in the database to which the current user has privileges
DBA_
10 Answer: All objects in the database
V_$
V$
APPHIA – Crafted with Care and Precision for Academic Excellence.
2
