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

A. It is enabled by performing a software-only Oracle Database installation and then running the roohctl-enable script.

B. It is enabled by performing an Oracle Database installation with database creation and then running the roohctl-enable script.

C. It requires the Rapid Home Provisioning service.

D. Its configuration data and log files reside in subdirectories under the Oracle home.

E. It contains an image that can be distributed across multiple servers.

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. the installation of Oracle ASMLIB

B. a group called dba

C. an operating system user to own this installation

D. an operating system account called grid

E. the Oracle Inventory group to install

A. The ORA_ARCHIVE_STATE column is updated in an overnight maintenance job based on activity tracking.

B. The ORA_ARCHIVE_STATE column may only be queried by users with the DBA role set.

C. The ORA_ARCHIVE_STATE column may only be updated by users with the DBA role set.

D. The ORA_ARCHIVE_STATE column is only displayed if it is referenced in the column select list of a query

E. The ROW ARCHIVAL VISIBILITY session parameter defaults to active rows.

A. Only the grid user can perform the upgrade.

B. A direct upgrade can be performed only from the immediately preceding Oracle Grid Infrastructure version.

C. The upgrade process will automatically install all mandatory patches for the current version of Oracle Grid Infrastructure.

D. Existing Oracle Database instances must be shut down before starting the upgrade.

E. The newer version is installed in a separate Oracle Grid Infrastructure home on the same server as the existing version.

F. An existing Oracle base can be used.

A. The ORA_ARCHIVE_STATE column is updated manually or by a program that could reference activity tracking columns, to indicate that a row is no longer considered active.

B. The ORA_ARCHIVE_STATE column visibility is controlled by the ROW ARCHIVAL VISIBILITY session parameter.

C. The ROW ARCHIVAL VISIBILITY session parameter defaults to active rows only.

D. The ORA_ARCHIVE_STATE column is updated automatically by the Oracle Server based on activity tracking columns, to Indicate that a row is no longer considered active. Correct

E. The ORA_ARCHIVE_STATE column is visible if referenced in the select list of a query.

A. acting as an I/O server to write data file blocks to ASM disks on behalf of Database Writer processes (DBWn)

B. mounting disk groups

C. managing extent allocation for Oracle database segments

D. managing Allocation Units (AUs) for disk group content

E. managing space allocation for Oracle ASM files

F. acting as an I/O server to read data file blocks from ASM disks on behalf of database server processes

A. to switch to a patched Oracle Database home

B. to switch back to the previous Oracle home as part of a rollback operation

C. to switch to a read-only Oracle home

D. to switch the Oracle Database home when using a centralized Rapid Home Provisioning server

E. to switch an existing Oracle Database home to a newer release of Oracle software on the same server

A. The Pre-Upgrade Information Tool script is executed by DBUA.

B. Multiple databases with the same ORACLE_HOME can be upgraded simultaneously.

C. A whole database backup must exist before upgrade

D. All pluggable databases are automatically upgraded as part of a container database upgrade.

E. The database must be opened in read-only mode.

F. DBUA must be launched from the target Oracle Home.

A. It provides before and after execution statistics for each SQL statement in the analysis task

B. It is integrated with the SQL Access Advisor.

C. SQL statements that were originally run concurrently are run concurrently by SPA.

D. It predicts the impact of system changes on SQL workload response time.

E. It offers fine-grained analysis of all the SQL statements in the analysis task as a group.

A. They can drop any tablespace.

B. They can create any table.

C. They cannot drop tablespaces.

D. They can view data from any data dictionary view or dynamic performance view.

E. They can view data from any user-defined tables.

F. They cannot create restore points.

A. Only the ORCL database instance, the Oracle ASM instance, and the +DATA and +FRA disk groups are started.

B. Only the ORCL database instance is started.

C. The ORCL database, the Oracle ASM instances, the +DATA and +FRA disk groups, and the LISTENER are started.

D. Only the ORCL database instance and the +DATA and +FRA disk groups are started.

E. Only the ORCL database and the ASM instances are started.

A. Run Automatic Database Diagnostic Monitor (ADDM) to fetch information from the latest Automatic Workload Repository (AWR) snapshots.

B. Use Active Session History (ASH) data and hang analysis in regular performance monitoring,

C. Run ADDM in diagnostic mode.

D. Enable Memory Access Mode, which reads performance data from SGA.

E. Use emergency monitoring to fetch data directly from SGA for analysis.

A. It can recommend changes to improve the statistics gathering process.

B. It can be run only manually.

C. It is part of the DBMS_ADVISOR package.

D. It always analyzes all schemas in the database.

E. It is part of the DBMS_STATS package.

F. It runs automatically every night by default.

A. A common unified audit policy can be created at the CDB level.

B. Application-common unified audit policies defined In an application root must be manually synchronized by each application PDB contained in the application root.

C. Fine-grained auditing policies defined in an application root must be manually synchronized by each application PDB contained in the application root.

D. A common unified audit policy can be created at the application root level.

E. All audit records are written to the audit trail in CDB$ROOT

F. An application PDB cannot have a local audit policy.

A. The insert on USER2.DEPT is a recursive autonomous transaction by the child session and is committed.

B. The insert on USER2.DEPT is uncommitted.

C. The inserts on USER1.EMP were rolled back when the session connected to PDB2.

D. The inserts on USER1.EMP were committed when the session connected to PDB2.

E. The inserts on USER1.EMP remain uncommitted when the session connected to PDB2.

F. The inserts on USER1.EMP were committed when the session inserted a row into USER2.DEPT.

G. The insert on USER2.DEPT fails because of the active transaction in the parent container.