최신 1Z0-082 무료덤프 - Oracle Database Administration I

A. Undo segments can extend when a transaction fills the last extent of the undo segment

B. Undo segments can wrap around to the first extent when a transaction fills the last extend of the undo segment

C. An undo segment may be used by multiple transactions simultaneously

D. Undo segments have a minimum of three extents

E. A single transaction may use multiple undo segments simultaneously

F. Undo segments must be stored in a BIGFILE tablespace

G. Undo segments must be stored in a SMALLFILE tablespace

A. It can run scripts entered at the SQL prompt.

B. It must be downloaded from the Oracle Technology Network (OTN).

C. It can run scripts passed to it by a shell script.

D. It has its own commands that are separate from any SQL statements.

E. It has both command-line and graphical user interfaces (GUI).

F. It can run Recovery Manager (RMAN) commands.

A. RON STORE COMPRESS BASIC

B. ROW STORE COMPRESS ADVANCED

C. COLUMN STORE COMPRESS BASIC

D. COLUMN STORE COMPRESS ADVANCED

A. You can use a single instance of EM Express to manage multiple database running on the same server.

B. EM Express uses a separate repository database to store target database metadata.

C. By default, EM express is available for a database after database creation using DBCA.

D. You cannot start up a database instance using EM Express.

E. You can shut down a database instance using EM Express.

A. COLUMN STORE COMPRESS FOR QUERY LOW

B. ROW STORE COMPRESS ADVANCED

C. ROW STORE COMPRESS BASIC

D. COLUMN STORE COMPRESS FOR ARCHIVE HIGH

E. COLUMN STORE COMPRESS FOR ARCHIVE LOW

A. Table aliases can improve performance

B. The join syntax used makes no difference to performance

C. The BETWEEN condition always performs better than using the >= and <= conditions

D. The BETWEEN condition always performs less well than using the >= and <= conditions

E. The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax

A. DML modifies Oracle database objects and only generates UNDO

B. DML modifies Oracle database objects and only generates REDO

C. The generation of UNDO generates REDO

D. The generation of REDO generates UNDO

E. DML modifies Oracle database objects and generates UNDO and REDO

A. the ability to prevent a password from ever being reused

B. the number of hours for which an account is locked after the configured number of login attempts has been reached

C. the number of password changes required within a period of time before a password can be reused

D. the number of days for which an account may be inactive before it is locked

E. the maximum amount of CPU time allowed for a user's sessions before their account is locked

F. the maximum number of sessions permitted for a user before the account is locked

G. the number of days for which an account is locked after the configured number of login attempts has been reached

A. as SCOTT in BOSTON_DB

B. as SCOTT in DALLAS_DB

C. as SYS in both the databases

D. as SCOTT in both the databases

E. as SCOTT in BOSTON_DB and SYS in DALLAS_DB

A. Dynamic service registration cannot be used for this database instance

B. The LREG process registers services dynamically with the LISTENER_1 listener

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

D. The definition for LISTENER_1 requires a CONNECT_DATA section to enable dynamic service registration

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