Definition password expiration term dropping a role

Definition:
password expiration
Term:
Dropping a role revokes it from all
users and roles, except those who are
currently logged on and have the role
enabled.
Definition:
TRUE
Term:
Oracle recommends that you create
your own roles instead of using the
CONNECT, RESOURCE, an DBA
roles, because these three roles will be
dropped in a future release.
Definition:
TRUE
Term:
Computers on a network use ____
connections to communicate with each
other.
Definition:
network
Term:
The Oracle Net Services configuration
is stored in the ____ configuration file
on the client computer.
Definition:
tnsnames.ora

Term:
Setting a user connection as being
dedicated or shared can be controlled
in the client-side configuration of
Oracle Net Services, in the ____ file.
Definition:
tnsnames.ora
Term:
____ redo log files means that
multiple redo log members, in each
redo log group, are written to in
parallel.
Definition:
Duplexing
Term:
The only required initialization
parameter to achieve successful
ARCHIVELOG mode is the ____
parameter.
Definition:
LOG_ARCHIVE_DEST_n
Term:
A single redo log entry is stamped
with a(n) ____.
Definition:
SCN
Term:
The ____ control file view contains
online redo log group information.
Definition:
V$LOG

Term:
____ queries create groupings or
summaries of larger row sets,
producing, for example, a sum of
values or a number of subtotals from
all values.
Definition:
Aggregated
Term:
The redo log files are typically
covered for backups by simply
duplexing redo log groups to have
multiple members in each group.
Definition:
TRUE
Term:
____ failure is much more likely than
any other failure situation, such as
dropping a table that should not be
dropped.
Definition:
User and Application
Term:
The ____ statement lets you remove
existing rows from tables.
Definition:
DELETE
Term:
To discover the name on a Unix or
Linux machine use the ____ command
in a shell.
Definition:
ENV

Term:
The ____ is only present when a
database is in ARCHIVELOG mode.
Definition:
ARCn
Term:
An index can have from one to ____
columns (only 30 columns if it is a
bitmap index)
Definition:
32
Term:
An index created to support a ____
constraint does not allow any null
values in any of the indexed columns,
because there is an automatic NOT
NULL constraint added to a primary
key column.
Definition:
PRIMARY KEY
Term:
A bitmap index stores ROWID values
and key values.
Definition:
FALSE

Term:
____ is the default status for a new
tablespace
Definition:
ONLINE
Term:
The ____ privilege allows a user to
log on to the database.
Definition:
CREATE SESSION
Term:
The ____ data dictionary view
contains all object privileges granted.
Definition:
DBA_TAB_PRIVS
Term:
The ____ predefined role provides
extensive abilities to create objects,
such as procedures, triggers, and
object types, for users who need to
create their own objects.
Definition:
RESOURCE
Term:
Statistics are a computation or
estimation of the exact size and
placement of data in tables and
indexes.