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.
You've reached the end of your free preview.
Want to read all 99 pages?
- Oracle Database