Oracle Database Administration I - 1Z1-082 Free Exam Questions

A. after successfully executing a commit or rollback followed by a select statement

B. after successfully executing a DML statement following a failed DML statement

C. after successfully executing a commit or rollback followed by a DML statement

D. after successfully executing a create table statement followed by a create index statement

E. after successfully executing a create table as select statement followed by a select for update statement

F. after successfully executing a truncate statement followed by a DML statement

A. Source Routing requires the use of a name server

B. Connect Time Failover requires the use of Transparent Application Failover (TAF)

C. Load Balancing requires the use of a name server

D. Connect Time Failover requires the connect string to have two or more listener addresses configured

E. Load Balancing can balance the number of connections to dispatchers when using a Shared Server configuration

F. Source Routing enables the use of Connection Manager (CMAN) which enables network traffic to be routed through a firewall

A. It prevents "Snapshot too old" errors.

B. It prevents out-of-space errors.

C. It is a static parameter.

D. It is a tablespace attribute.

E. It prevents FLASHBACK DATABASE operation failure.

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

B. Data block free space is always contiguous in the middle of the block

C. Multiple row pieces from the same row may be stored in the same block

D. A table row piece can be chained across several database blocks

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

F. Index block free space is always contiguous in the middle of the block

A. FLASHBACK TRANSACTION

B. FLASHBACK QUERY

C. FLASHBACK TABLE TO SCN

D. FLASHBACK DROP

E. FLASHBACK DATABASE

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

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

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

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

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

A. It is a file-based repository held outside any database.

B. It is only used for Oracle Database diagnostic information.

C. It Is held Inside an Oracle database schema.

D. The ADR base is specified In the diagnostic_dest database parameter.

E. It can be used for problem diagnosis of a database when that database's instance is down.

A. It represents database metadata information as DDL statements in the dump file.

B. It can export data into sequential media, such as tapes.

C. It can restart failed export jobs.

D. It makes use of client system resources.

E. It can execute in parallel.

A. Ensure that DB_CREATE_FILE_DEST specifies a location with at least 100 Mb of available space.

B. Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify with at least 50 Mb of available space.

C. Add the AUTOEXTEND ON clause with NEXT set to 100M.

D. Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify locations with at least 50 Mb of available space.

E. Specify a path in the DATAFILE clause of the command specifying a location with at least 100M of available space.