SOLOSOLOKU: Section 17 Quiz

Test: Section 17 Quiz
Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.

Section 17 Quiz
(Answer all questions in this section)

1. Which of the following is NOT a database object?

Table
Sequence
Subquery (*)
View

2. What system privilege must be held in order to login to an Oracle database?

CREATE LOGIN
CREATE SESSION (*)
CREATE LOGON
No special privilege is needed; if your username exists in the database, you can login.

3. You create a view named EMPLOYEES_VIEW on a subset of the EMPLOYEES table. User AUDREY needs to use this view to create reports. Only you and Audrey should have access to this view. Which of the following actions should you perform?

Do nothing. As a database user, Audrey's user account has automatically been granted the SELECT privilege for all database objects.

GRANT SELECT ON employees AND employees_view TO audrey;

GRANT SELECT ON employees_view TO public;

GRANT SELECT ON employees_view TO audrey; (*)

4. Which of these is NOT a System Privilege granted by the DBA?

Create Procedure
Create Sequence
Create Index (*)
Create Session

5. A schema is:

A named group of related privileges given to a user.
Required to gain access to the database.
Required to manipulate the content of objects in the database.
A collection of objects, such as tables, views, and sequences. (*)

Test: Section 17 Quiz
Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.

Section 17 Quiz
(Answer all questions in this section)

6. 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

role_tab_privs (lists table privileges granted to roles)
role_sys_privs (lists system privileges granted to roles)
user_sys_privs (lists system privileges granted to the user) (*)
user_tab_privs_recd (lists object privileges granted to the user)

7. Which of the following best describes the purpose of the REFERENCES object privilege on a table?
It allows the user to create new tables which contain the same data as the referenced table.
It allows a user to refer to the table in a SELECT statement.
It allows a user to create foreign key constraints on the table. (*)
It allows a user's session to read from the table but only so that foreign key constraints can be checked.

8. You need to grant user BOB SELECT privileges on the EMPLOYEES table. You want to allow BOB to grant this privileges to other users. Which statement should you use?  

GRANT SELECT ON employees TO bob WITH ADMIN OPTION;
GRANT SELECT ON employees TO PUBLIC WITH GRANT OPTION;
GRANT SELECT ON employees TO bob;
GRANT SELECT ON employees TO bob WITH GRANT OPTION; (*)

9. When granting an object privilege, which option would you include to allow the grantee to grant the privilege to another user?  
WITH GRANT OPTION (*)
PUBLIC
FORCE
WITH ADMIN OPTION

10. Which statement would you use to grant a role to users?  
ASSIGN
CREATE USER
GRANT (*)
ALTER USER

Test: Section 17 Quiz
Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.

Section 17 Quiz
(Answer all questions in this section)

11. Which of the following statements about granting object privileges is false?
An object owner can grant any object privilege on the object to any other user or role of the
database.
To grant privileges on an object, the object must be in your own schema, or you must have been granted the object privileges WITH GRANT OPTION.
Object privileges can only be granted through roles. (*)
The owner of an object automatically acquires all object privileges on that object.

12. User CRAIG creates a view named INVENTORY_V, which is based on the INVENTORY table. CRAIG wants to make this view available for querying to all database users. Which of the following actions should CRAIG perform?

He should assign the SELECT privilege to all database users for INVENTORY_V view. (*)
He is not required to take any action because, by default, all database users can automatically access views.
He should assign the SELECT privilege to all database users for the INVENTORY table.
He must grant each user the SELECT privilege on both the INVENTORY table and INVENTORY_V view.


13. _________________ are special characters that have a special meaning, such as a wildcard character, a repeating character, a non-matching character, or a range of characters. You can use several of these symbols in pattern matching.  

Alphanumeric values
Meta characters (*)
Clip Art
Reference checks

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

True (*)
False

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

REGEXP_SUBSTR
REGEXP_REPLACE
REGEXP_LIKE
REGEXP (*)