1z0-062 Exam Questions Tutorials

It records checkpoint information in the control file.

It frees unused temporary segments.

It kills sessions that exceed idle time.

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

It frees resources held by abnormally terminated processes.

The MEMORY_MAX_TARGET parameter is automatically set to 500 MB.

The PGA_AGGREGATE_TARGET and SGA_TARGET parameters are automatically set to zero.

The value of the MEMORY_MAX_TARGET parameter remains zero for the database instance.

The lower limits of the PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to 90 MB and 270 MB respectively.

The instance does not start up because Automatic Memory Management (AMM) is enabled but PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to nonzero values.

It succeeds because the PDB_ADMIN user has the required privileges.

It fails because common users are unable to use the SET CONTAINER statement.

It fails because local users are unable to use the SET CONTAINER statement.

If fails because the SET CONTAINER statement cannot be used with PDB$SEED as the target pluggable database (PDB).

You can detach from a data pump export job and reattach later.

Data pump uses parallel execution server processes to implement parallel import.

Data pump import requires the import file to be in a directory owned by the oracle owner.

The master table is the last object to be exported by the data pump.

You can detach from a data pump import job and reattach later.