Database Reference
In-Depth Information
Figure 26-12. Except From a College Database
20d. Establish a class-course-lecturer relationship, stored as a
view, so that for each class, it will be known what course is
offered, and who is the lecturer.
{04}
20e.
List all courses offered by the college.
{01}
20f.
Create a view for chemistry majors, which enables them
to have read-only access to the chemistry curriculum only
(assume that chemistry course codes are prefixed by the
string “CHEM”).
{03}
21.
21a. Write SQL statement(s) to create a role called Developer and
give it all the privileges required for application development.
{04}
21b. Write SQL statement(s) to assign the Developer role to users
GrantFord and HarryLim , and deny the user Stalker all
privileges.
{03}
21c.
Assume that your database contains a table called Payroll ,
which has confidential information about the salary of
employees. As the DBA, you want to restrict access to
this table as follows: User JohnHenry must have query
access only; user BruceJones must have query as well as
modification access; no one else must have any access to the
table. Write SQL statement(s) to realize this.
{06}
21d. Write an SQL statement to query the Oracle 10G system
catalog and provide a list of all tables in a given database (your
display must include the name of the table, the owner of the
table and the tablespace it belongs to).
{03}
21e.
Describe two limitations of SQL and briefly explain how they
can be circumvented.
{04}
Search WWH ::




Custom Search