PROGRAMMING: Section 13

CONTROLLING USER ACCESS
The following table shows some of the output from one of the data dictionary views. Which view is being queried?
USERNAME                                PRIVILEGE    ADMIN_OPTION
USCA_ORACLE_SQL01_S08       CREATE        VIEW NO
USCA_ORACLE_SQL01_S08       CREATE        TABLE NO
USCA_ORACLE_SQL01_S08       CREATE        SYNONYM NO
USCA_ORACLE_SQL01_S08       CREATE        TRIGGER NO
USCA_ORACLE_SQL01_S08       CREATE        SEQUENCE NO
USCA_ORACLE_SQL01_S08       CREATE        DATABASE NO
user_sys_privs (lists system privileges granted to the user)
          
Which Object Privilege apart from Alter can be granted to a Sequence?
SELECT
          
Object privileges are:
Required to manipulate the content of objects in the database.
          
By Controlling User Access with Oracle Database Security you can give access to specific Objects in the Database. True or False?
True
          
Which of the following Object Privileges can be granted on an individual column on a table?
Update
References
          
A Schema is a collection of Objects such as Tables, Views and Sequences. True or False?         
True
          
Which of these is not a System Privilege granted by the DBA?
Create Index
          
Which of the following is not a database object?
Subquery
          
What system privilege must be held in order to login to an Oracle database?
CREATE SESSION
          
A schema is:
A collection of objects, such as tables, views, and sequences.
          
System privileges are:
Required to gain access to the database.
          

CREATING AND REVOKING OBJECT PRIVILEGES
Which of the following statements about granting object privileges is false?
Object privileges can only be granted through roles.
          
If you are granted privileges to your friend's object, by default you may also grant access to this same object to other users. True or False?
False
          
What Oracle feature simplifies the process of granting and revoking privileges?
Role
          
User1 owns a table and grants select on it WITH GRANT OPTION to User2. User2 then grants select on the same table to User3. If User1 revokes select privileges from User2, will User3 be able to access the table?
No
          
Roles are:
Named groups of related privileges given to a user or another role.
          
When a user is logged into one database, they are restricted to working with objects found in that database. True or False?
False
          
To take away a privilege from a user you use which command?
REVOKE
          
Scott King owns a table called employees. He issues the following statement:
GRANT select ON employees TO PUBLIC;
Allison Plumb has been granted CREATE SESSION by the DBA. She logs into the database and issues the following statement:
GRANT ﾠselect ON ﾠscott_king.employees TO jennifer_cho;
True or False: Allison's statement will fail.
True
          
A role can be granted to another role. True or False?
True
          
Which of the following statements is true?
Database Links allow users to work on remote database objects without having to log into the other database.
          

REGULAR EXPRESSIONS
Select the correct REGULAR EXPRESSION functions:
REGEXP_LIKE, REGEXP_REPLACE
REGEXP_INSTR, REGEXP_SUBSTR
          
REGULAR EXPRESSIONS can be used as a part of contraint definitions?
True
          
REGULAR EXPRESSIONS does exactly the same as LIKE. No more and no less?
False
          
REGULAR EXPRESSIONS can be used on CHAR, CLOB and VARCHAR2 datatypes?
True