최신 1Z0-083 무료덤프 - Oracle Database Administration II

A. Tablespaces never remain in read/write mode during transportable tablespace operations.

B. A transportable data pump import can leave a plugged-in tablespace in read/write mode.

C. Tablespaces always remain in read/write mode during transportable tablespace operations.

D. An ordinary data pump export of a table with encrypted columns will always encrypt the same columns when imported.

E. A transportable data pump import can leave a plugged-in tablespace in read-only mode.

F. Simultaneous data pump jobs can be limited at the pluggable database (PDB) level.

A. Improved Serial Execution performance

B. Reduced logical I/O

C. Reduced physical I/O

D. Reduced virtual memory utilization

E. Reduced CPU utilization

A. If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups across all PDBs in the CDB.

B. If no PDB plan is enabled for a pluggable database, then the PDB share in the CDB plan is dynamically calculated.

C. If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan.

D. In a PDB plan, subplans may be used with up to eight consumer groups.

E. If no PDB plan is enabled for a pluggable database, then all sessions for that PDB are treated to an equal degree of the resource share of that PDB.

A. It can be used to apply interim patches to the Grid Infrastructure and Database Home combination.

B. It supports Rolling Patching.

C. It requires installation of Oracle Universal Installer.

D. It is a Java-based utility for applying patchsets.

E. It must be invoked as the user that owns the software being patched.

F. It is platform independent.

A. Flashback logs are maintained in the Flash Recovery Area.

B. Flashback logs need to be cleared manually after you disable Flashback Database.

C. Flashback logs are used to maintain Flashback Database related errors.

D. Flashback logs are maintained in redo log files.

E. Flashback logs are not archived.

A. It facilitates and helps to enforce keystore backup requirements.

B. It enables a keystore to be stored only in a file on a file system.

C. It helps to track encryption keys and implement requirements such as keystore password rotation and master encryption key reset or re-key operations.

D. It handles encrypted data without modifying applications.

E. It transparently decrypts data for the database users and applications that access this data.

F. It enables separation of duties between the database administrator and the security administrator.

A. user-defined PL/SQL packages

B. control files

C. undo tablespaces

D. redo logs

E. mandatory Oracle-supplied PL/SQL packages

F. temporary tablespaces

G. all data dictionary metadata

A. They can be extended data-linked in CDB$ROOT.

B. They can be only metadata-linked in an application container.

C. They can be created only in CDB$ROOT.

D. They can exist in user-defined schemas only in application containers.

E. They can exist in CDB$ROOT and an application root.

F. They can be created only in an application root.

A. A backup set must be written to disk.

B. A data file can be split into multiple sections stored in different backup pieces in the same backup set.

C. A backup set must be written to media.

D. A data file can be split into multiple sections stored in different backup sets.

E. Blocks from multiple data files can be contained in one backup set,

F. A backup set can contain only one backup piece.

G. A backup piece can belong to only one backup set.

H. Blocks from multiple data files can be contained in one backup piece,

A. It has the same number of roles as CDB1.

B. Service PDB1 is created for remote logins to PDB1.

C. It has no local users.

D. It is in mount state after creation.

E. It has only local roles.

F. It has the same common users defined as does CDB1.

A. It guarantees zero-loss auditing.

B. The audit trail cannot be easily modified because it is read-only.

C. It automatically audits Recovery Manager (RMAN) events.

D. Decreased use ofstorage to store audit trail rowsin the database.

E. It improves overall auditing performance.

A. A PDB created from PDB$SEED must be set to READ WRITE after loading data.

B. A PDB can be plugged into a CDB only if both are of the same Oracle Database release.

C. A non-CDB can be converted into a PDB.

D. A PDB unplugged from a container database (CDB) can be plugged into a different CDB without altering any of its schemas.

E. A PDB created from PDB$SEED must be set to READ ONLY after loading data.

F. A PDB in a remote CDB can be accessed transparently there by aggregating results from local and remote PDBs.

G. An unplugged PDB can be plugged into multiple CDBs simultaneously by sharing data files.

A. when the target and source database are on the same platform

B. when the operating system (OS) needs to be changed as part of the upgrade

C. when multiple pluggable databases in a container database have to be upgraded in a specific sequence

D. when a character set conversion is required during the upgrade

E. when the hardware platform needs to be changed as part of the upgrade

A. Its collection level is determined by the value of the STATISTICS_LEVEL database parameter.

B. By default, AWR snapshots are taken every 60 minutes.

C. The taking of AWR snapshots can be disabled.

D. AWR data is stored in the SYSTEM tablespace.

E. By default, AWR snapshots are retained for 7 days.

A. general operating system health

B. SQL statements

C. database instance memory management and sizes

D. log writer performance

E. database writer performance

A. Data is redacted for the EMP.SAL column only if the SCOTT session does not have the MGR role set.

B. Data is redacted for EMP.SAL column only if the SCOTT session has the MGR role set.

C. Data is redacted for the EMP_V.SAL column only if the SCOTT session has the MGR role set.

D. Data is never redacted for the EMP_V.SAL column.

E. Data is redacted for the EMP_V.SAL column only if the SCOTT session does not have the MGR role set.

A. It will create `$ORACLE_HOME/dbs/cdb1/CDB1/controlfile02.ctl'

B. It will create `/u01/app/oralce/oradata/CDB1/controlfile/controlfile02.ctl'.

C. It will re-create `/u02/app/oracle/fast_recover_area/cdb1/CDB1/controlfile02.ctl'

D. It will create `/u01/app/oracle/product/12.2.0.1/db_1/dbs/ snapcf_cdb1control02.ctl'.

E. It will fail because there is no autobackup of the controlfiles.

A. A snapshot copy PDB can be a full copy of a source PDB.

B. A CDB can be duplicated using the Database Configuration Assistant (DBCA) in silent mode with no configuration required before starting the duplication.

C. A snapshot copy PDB does not depend on an existing storage snapshot of the source PDB.

D. A PDB snapshot depends on an existing storage snapshot of the source PDB.

E. A PDB snapshot can be a full copy of a source PDB.

F. A CDB can be duplicated using Recovery Manager (RMAN) with no configuration required before starting the duplication.

G. A PDB snapshot can be a sparse copy of a source PDB.

A. FLASHBACK version query requires undo to retrieve all versions of a row that existed between two points in time.

B. FLASHBACK drop requires that the RECYCLEBIN parameter be set to ON.

C. FLASHBACK version query requires that the RECYCLEBIN parameter be set to ON.

D. FLASHBACK transaction query requires undo to retrieve all versions of a row that existed between two points in time.

E. FLASHBACK drop requires undo to retrieve all versions of a row that existed between two points in time.

F. FLASHBACK DATA ARCHIVE requires undo to store all versions of all rows of a table being tracked.