Database Reference
In-Depth Information
4.
Given the above database, and assuming an Oracle 10g
environment, show what the contents of the system catalog
tables
User_Tables
(attributes
Table_Name
and
Tablespace_
Name
) and
User_Columns
(attributes
Column_Name
and
Table_Name
) would be.
{10}
5.
The above database may be refined by introducing a
Countries
table, and adjusting three other tables to each have
a foreign key that references this table. Show the required
SQL statements to make this adjustment.
{12}
26.8 Sample Assignment 7A
For each question, show the SQL statement(s) that you have used in order to address
the question.
1.
Create a test table called
JonesB_TestTable
(where “JonesB”
represents your user name) and populate it with some
sample data.
{10}
2a.
Create a role and for its name, use the concatenation of
your user account and the word “Role.” For instance, the
role may be called
JobesB_Role
(where “JonesB”
represents your user name).
{02}
2b.
Grant to your role the system privileges that facilitate
application development (see section 13.2.2 for
guidelines on this).
{11}
2c.
Grant to your role, SUDI privileges on
JonesB_TestTable
(review section 13.2.3 for the SUDI privileges).
{04}
2d.
There is a catalog table that you can access to see all the
system privileges granted to all roles in the system. Its name
is
Role_Sys_Privs
. Study its structure, and then issue an
appropriate SQL statement to display the system
privileges associated with your role. Show the SQL
statement used.
{06}
