Database programming section 17

1. REGULAR EXPRESSIONS can be used as part of a contraint definition. (True or False?)
True (*)

2. Which of these SQL functions used to manipulate strings is NOT a valid regular expression function ?

REGEXP (*)

3. REGULAR EXPRESSIONS can be used on CHAR, CLOB, and VARCHAR2 datatypes? (True or False)
True (*)

4. Which of the following privileges must be assigned to a user account in order for that user to connect to an Oracle database?
CREATE SESSION (*)

5. By Controlling User Access with Oracle Database Security, you can give access to specific Objects in the Database. True or False?
True (*)

6. You want to grant privileges to user CHAN that will allow CHAN to update the data in the EMPLOYEES table. Which type of privileges will you grant to CHAN?
Object privileges (*)

7. Which of the following are object privileges? (Choose two)
(Choose all correct answers)
INSERT (*)
SELECT (*)

8. System privileges are:
Required to gain access to the database. (*)

9. The database administrator wants to allow user Marco to create new tables in his own schema. Which privilege should be granted to Marco?

CREATE TABLE (*)

10. Which statement would you use to add privileges to a role?
GRANT (*)

11. Which keyword would you use to grant an object privilege to all database users?
PUBLIC (*)

12. To join a table in your database to a table on a second (remote) Oracle database, you need to use:

A database link (*)

13. A role can be granted to another role. True or False?
True (*)

14. 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 (*)

15. What Oracle feature simplifies the process of granting and revoking privileges?
Role (*)