Definition password expiration term dropping a role

  • No School
  • NONE 0
  • Notes
  • JordanH91
  • 99
  • 100% (4) 4 out of 4 people found this document helpful

This preview shows page 69 - 74 out of 99 pages.

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
Image of page 69
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
Image of page 70
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
Image of page 71
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
Image of page 72
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.
Image of page 73
Image of page 74

You've reached the end of your free preview.

Want to read all 99 pages?

  • Oracle Database

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture