最新的Oracle Database Administration II - 1Z0-083免費考試真題

A. A connection represents the state of a user's login to an instance.

B. An Oracle Database server process is always associated with a session.

C. An Oracle Database server process represents the state of a user's login to an instance.

D. The entire data dictionary is always cached in the large pool.

E. Each server process has its own User Global Area (UGA).

A. The valid time columns are not populated by the Oracle Server automatically.

B. The valid time columns are visible by default when the table is described.

C. Setting the session valid time using DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME sets the visibility for data manipulation language (DML), data definition language (DDL), and queries performed by the session.

D. The valid time columns employee_time_start and employee_time_end are automatically created.

E. Thesamestatementmayfilteronbothtransactiontimeandvalidtemporaltimebyusingthe AS OF TIMESTAMP and PERIOD FOR clauses.

A. 1, 3, 5, 6, 9

B. 1, 2, 5, 7, 4, 10

C. 1, 3, 5, 8, 6, 10

D. 1, 3, 5, 6, 10

E. 1, 3, 5, 7, 10

A. Backup older than the recovery window retention policy are always deleted automatically if the backup location has insufficient space.

B. A DBA must specify either a redundancy retention policy or a recovery window retention policy.

C. The V$RMAN_CONFIGURATION view displays only settings with values that have been modified.

D. Backups written to the fast recovery area (FRA) that are oboslete based on the redundancy retention policy can be deleted automatically to free space.

E. A target database's persistent RMAN configuration settings are always synchronized automatically with the RMAN catalog.

F. The RMAN SHOW ALL command displays only settings with nondefault values.

G. A target database's persistent RMAN configuration settings are always stored in the target's control file

A. to specify a default tablespace in a PDB cloned from another PDB in the same CDB.

B. to specify the list of tablespaces to include when creating a PDB from the CDB seed

C. to include specific user tablespaces only when relocating a PDB

D. to exclude all tablespaces except SYSTEM, SYSAUX, and TEMP when plugging in a PDB

E. to specify the list of user tablespaces to include when moving a non-CDB to a PDB

F. to exclude a temp tablespace when plugging in a PDB

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

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

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

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

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

A. Use the SQL Access Advisor for each of the regressed statements.

B. Use The SQL Tuning Advisor for each of the regressed statements.

C. Create SQL plan directives for each of the regressed statements.

D. Create an adaptive execution plan for each of the regressed statements

A. 1, 3, 5, 7

B. 1, 3, 5, 6, 7

C. 2, 5, 6

D. 3, 4, 1, 6, 8

E. 1, 5, 6

A. Identify poorly tuned SQL statements using Automatic Database Diagnostic Monitor.

B. Identify poorly tuned SQL statements using the SQL Tuning Advisor.

C. Tune individual SQL statements using the SQL Tuning Advisor.

D. Tune SQL statements as a group using the SQL Tuning and SQL Access Advisors.

E. Test tuned SQL statements one at a time for all statements in the application.

F. Test the application as a whole using tuned SQL statements.

A. The response file can specify the path of the sudo program.

B. The response file can specify the root or sudo password.

C. Silent install always runs operating scripts automatically.

D. The response file must contain the root or sudo password.

E. The installer will prompt for the root or sudo password.

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

B. managing extent allocation for Oracle database segments

C. mounting disk groups

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

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

F. managing space allocation for Oracle ASM files

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. In a PDB plan, subplans may be used with up to eight consumer groups.

D. 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.

E. 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.

A. All files in the current fast recovery area (FRA) that have not yet been backed up, are backed up.

B. All Oracle recovery files normally written to the FRA and which have not yet been backed up, are backed up.

C. All files in any previous FRA that have been backed up already, are backed up.

D. All files in the current FRA that have been backed up already, are backed up.

E. All Oracle recovery files normally written to the FRA and which have been backed up already to in any previous FRA, are backed up.

F. All Oracle recovery files normally written to the FRA and which have been backed up already to the current FRA, are backed up.

G. All files in any previous FRA that have not yet been backed up, are backed up.

A. It is used to inform the database about the repair after the repair script executes.

B. It is used to execute the advised repair script.

C. It is used to change failure priority only for the CRITICAL priority.

D. It is used to change failure priority only for HIGH or LOW priorities.

E. It is used to explicitly close the open failures.