1z0-182 Exam Dumps - Oracle Database Questions and Answers

A database link can be created only between two Oracle databases.

Private database link creation requires the same user to exist in both the local and the remote databases.

A public database link can be created only by SYS.

A database link created in a database allows a connection from that database's instance to the target database's instance for selecting schema data.

A public database link can be used by any user allowing remote database instance connection for selecting schema data.

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

Source Routing requires the use of encrypted connections.

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

Load Balancing requires the use of a name server.

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

All required background processes are started.

The consistency of the database is checked.

The control files are opened.

Memory is allocated for the SGA.

SYS can access the database.

A migrated row results in an update to any index on the table to point the row ID in the index to the row’s new location.

Update statements can result in one or more migrated rows.

Update statements can result in one or more chained rows.

Row pieces of a chained row must always reside in different blocks.

Insert statements can result in a migrated row.

It registers database services with all local and remote listeners known to the database instance.

It records checkpoint information in the control file.

It frees resources held by abnormally terminated processes.

It rolls back transactions when a process fails.

It frees unused temporary segments.

The Large Pool

The Java Pool

The Streams Pool

The Shared Pool

Read consistency is not guaranteed.

V$FIXED_TABLE can be queried to display the names of all dynamic performance views.

Data displayed by querying dynamic performance views is derived from metadata in the data dictionary.

They are owned by the SYSTEM user.

They can be queried only when the database is open.

The DBA configures the maximum number of dedicated server processes that can share the samedispatcher process.

A dedicated server process may be reused by a new session after the session using that process terminates.

A dedicated server process communicates directly with a client or middle-tier process once the session is established.

Each dedicated server process has its own dispatcher process.

A dedicated server process can be spawned by the listener when using local clients.

A dedicated server process can be spawned without a listener when using local clients.

It is unnecessary if the PDB is in the process of being upgraded.

PDB1 is reverted to its default properties, which includes not to automatically open after a CDB restart.

PDB1 is reverted to its default properties, which includes automatic opening after a CDB restart.

It should be used whenever PDB1 open mode needs to be changed.

A diagnostic system that collects database error logs and details about database failures that can be found to diagnose complete file.

Oracle Database Resource Manager, which enables you to manage and configure system resources used by the Automatic Maintenance Tasks.

The maintenance windows managed by Oracle Database Scheduler, which are predefined time intervals permitting scheduled tasks.

A packaging system that allows you to combine all error and failure logs to share with Oracle Support.

A database alert log that stores details about major database operations and errors, which is used to manage cluster performance.

A set of tasks that are started automatically at regular intervals to perform maintenance operations on the database.