Section 17
Regular
expressions are a method of describing both simple and complex patterns for
searching and manipulating. True or False?
True
(*)
False
Parentheses are not used to
identify the sub expressions within the expression. True or False?
True
False
(*)
REGULAR EXPRESSIONS can be used
on CHAR, CLOB, and VARCHAR2 datatypes? (True or False)
True
(*)
False
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?
True
False
(*)
When a user is logged into one
database, he is restricted to working with objects found in that database. True
or False?
True
False
(*)
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 GRANT OPTION; (*)
GRANT
SELECT ON employees TO bob;
GRANT
SELECT ON employees TO bob WITH ADMIN OPTION;
GRANT
SELECT ON employees TO PUBLIC WITH GRANT OPTION;
To take away a privilege from a
user, you use which command?
ALTER
REMOVE
REVOKE
(*)
DELETE
Which statement would you use
to remove an object privilege granted to a user?
REMOVE
REVOKE
(*)
DROP
ALTER
USER
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
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.
He is
not required to take any action because, by default, all database users can
automatically access views.
Which of the following are object
privileges? (Choose two)
CREATE
TABLE
SELECT
(*)
DROP
TABLE
INSERT
(*)
System privileges are:
A
collection of objects, such as tables, views, and sequences.
Required
to gain access to the database. (*)
Required
to manipulate the content of objects in the database.
Named
groups of related privileges given to a user.
User ADAM has successfully logged
on to the database in the past, but today he receives an error message stating
that (although he has entered his password correctly) he cannot log on. What is
the most likely cause of the problem?
ADAM's
user account has been removed from the database.
ADAM's
CREATE USER privilege has been revoked.
ADAM's
CREATE SESSION privilege has been revoked. (*)
One or
more object privileges have been REVOKEd from Adam.
Which of these is NOT a System
Privilege granted by the DBA?
Create
Index (*)
Create
Session
Create
Procedure
Create
Sequence
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.
Which of the following is NOT a
database object?
Subquery
(*)
Sequence
View
Table
No comments:
Post a Comment