1Z0-082 無料問題集「Oracle Database Administration I」

（A）Operating System authentication may be used for system-privileged administrative users.

（B）Password File authentication must be used for system-privileged administrative users.

（C）REKOTE_LOGIN_PASSMOREFiLE must be set to exclusive to permit password changes for system-privileged administrative users.

（D）Password File authentication is supported for any type of database user.

（E）Password authentication must be used for system-privileged administrative users.

（A）The definition for LISTENER_1 requires a CONNECT_DATA section to enable dynamic service registration

（B）The LREG process registers services dynamically with the LISTENER_1 listener

（C）There are two listeners named LISTENER and LISTENER_1 running simultaneously using port 1521 on the same host as the database instances

（D）Dynamic service registration cannot be used for this database instance

（E）LISTENER_1 must also be defined in the LISTENER.ORA file to enable dynamic service registration

（A）The generation of UNDO generates REDO

（B）The generation of REDO generates UNDO

（C）DML modifies Oracle database objects and only generates REDO

（D）DML modifies Oracle database objects and only generates UNDO

（E）DML modifies Oracle database objects and generates UNDO and REDO

（A）Undo segments must be stored in a BIGFILE tablespace

（B）Undo segments can extend when a transaction fills the last extent of the undo segment

（C）Undo segments have a minimum of three extents

（D）An undo segment may be used by multiple transactions simultaneously

（E）Undo segments can wrap around to the first extent when a transaction fills the last extend of the undo segment

（F）Undo segments must be stored in a SMALLFILE tablespace

（G）A single transaction may use multiple undo segments simultaneously

（A）DML may be performed on tables with one or more extents in this data file during the execution of this command.

（B）The file is renamed and stored in the same location

（C）The tablespace containing SALES1.DBF must be altered READ ONLY before executing the command.

（D）If Oracle Managed Files (OMF) is used, then the file is renamed but moved to DB_CREATE_FILE_DEST.

（E）The tablespace containing SALES1.DBF must be altered OFFLINE before executing the command.

（A）A full outer join returns matched and unmatched rows

（B）Outer joins can be used when there are multiple join conditions on two tables

（C）A left or right outer join returns only unmatched rows

（D）A full outer join must use Oracle syntax

（E）An inner join returns matched rows

（F）Outer joins can only be used between two tables per query

（A）Enterprise Manager Cloud Control can be used to centrally configure net service names for any database server target

（B）The Oracle Net Configuration Assistant is only used when running the Oracle installer

（C）Oracle Net Manager can be used to locally configure naming methods on a database server

（D）Enterprise Manager Cloud Control can be used to centrally configure listeners on any managed database server

（E）Oracle Net Manager can be used to centrally configure listeners on any database server target

（F）The lsnrctl utility requires a listener.ora file to exist before it is started

（A）The names of columns selected in each SELECT statement must be identical

（B）The number of columns selected in each SELECT statement must be identical

（C）Duplicates are eliminated automatically by the UNION ALL operator

（D）The output is sorted by the UNION ALL operator

（E）NULLS are not ignored during duplicate checking

（A）Data block headers contain their own Data Block Address (DBA)

（B）Index block free space is always contiguous in the middle of the block

（C）Data block free space is always contiguous in the middle of the block

（D）Multiple row pieces from the same row may be stored in the same block

（E）Multiple row pieces from the same row may be stored in different database blocks

（F）A table row piece can be chained across several database blocks

（A）It overwrites data in EMP with data in EMP.DAT

（B）It uses the database buffer cache to load data

（C）It generates a sql script that it uses to load data from EMP.DAT to EMP

（D）It appends data from EMP.DAT to EMP

（E）It generates a log that contains control file entries, which can be used with normal SQL*Loader operations