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

A. Poorly performing SQL statements can be tuned automatically by the Oracle server.

B. SQL statements doing only logical reads never require tuning because they do no physical I/O.

C. The solution that best optimizes one SQL statement can degrade the performance of others.

D. SQL statements performing many physical I/Os can always have their performance improved by creating indexes.

E. SQL statements doing joins always do more physical I/O than single table queries.

A. A CDB can be duplicated using the Database Configuration Assistant (DBCA) in silent mode.

B. A CDB can be duplicated only by using the Database Configuration Assistant (DBCA).

C. A PDB snapshot must be a full copy of a source PDB.

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

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

A. creating a database link from CDB$ROOT in the remote database to the PDB in the local database

B. creating a database link from CDB$ROOT in the remote database to be cloned to CDB$ROOT in the local database

C. opening the cloned PDB

D. creating a database link from CDB$ROOT in the local database to CDB$ROOT in the remote system that is to be cloned

E. automatically dropping the database link to the remote database if it already exists

F. creating a database link from CDB$ROOT in the local database to the PDB in the remote system that is to be cloned

G. creating a new empty PDB in the local database from PDB$SEED

A. APP1 can never be unplugged.

B. Application PDBs that are subsequently created in the APP1 application container will be cloned from PDB$SEED.

C. Application PDBs that are subsequently created in the APP1application container will be cloned from APP1$SEED.

D. An application seed PDB is created for APP1.

E. A default service is created for the application root APP1.

F. An application root PDB is created for APP1.

A. when the duplicate ... from active database command contains the section size clause

B. when you perform active database duplication on a database that has readonly tablespaces

C. when the number of auxiliary channels allocated is equal to or greater than the number of target channels

D. when you perform active database duplication on a database with flashback disabled

E. when you specify set encryption before the duplicate ... from active database command

A. They contain all the data files only in uncompressed form for a PDB.

B. DBMS_PDB.CHECK_PLUG_COMPATIBILITY can be run against a PDB archive.

C. They contain all the data files only in compressed form for a PDB.

D. They contain a PDB manifest file and all the data files in uncompressed form for a PDB.

E. They must be created using the DBMS_PDB package.

F. They contain a PDB manifest file and all the data files in compressed form for a PDB.

A. the maximum number of database files that can be opened by a database instance

B. the list of a disk group names to be mounted by an Oracle Automatic Storage Management (ASM) instance at startup

C. the location of Oracle Net Services configuration files

D. default directories for temporary files used by temporary tablespaces

E. the temporary disk space used by Oracle Installer during installation

F. the Optimal Flexible Architecture (OFA) compliant path to store Oracle software and configuration files.

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. 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. These backups can be written to disk or SBT.

B. All Oracle recovery files in the current fast recovery area (FRA) are backed up.

C. All Oracle recovery files not in the current FRA that have not been backed up already, are backed up.

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

E. All Oracle recovery files in the current FRA that have not been backed up already, are backed up.

A. Space is only reclaimed when there is space pressure in the Fast Recovery Area. (FRA)

B. Space is always reclaimed automatically when the retention period for Flashback logs is lowered.

C. Space is always reclaimed proactively before space pressure occurs.

D. Space might be reclaimed automatically when the retention period for Flashback logs is lowered.

E. Space might be reclaimed proactively before space pressure occurs.

A. creating an Oracle Automatic Storage Management (ASM) instance with ASM Configuration Assistant (ASMCA)

B. creating a database service using DBMS_SERVICE.CREATE_SERVICE

C. creating a database using the CREATE DATABASE SQL statement

D. creating an Oracle Database service by modifying the SERVICE_NAMES parameter

E. creating a database service using Oracle Database Configuration Assistant (DBCA)

F. creating a disk group using the CREATE DISKGROUP SQL statement

A. Executing DBMS_STATS.GATHER_DATABASE_STATSwhile connected to CDB$ROOTgathers object statistics in all open pluggable databases (PDBs)

B. Executing DBMS_STATS.GATHER_DATABASE_STATSwhile connected to a PDB opened in read/write mode gathers object statistics for that PDB.

C. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics only in CDB$ROOT.

D. Executing DBMS_STATS.GATHER_DATABASE_STATSwhile connected to CDB$ROOTgathers object statistics in all open PDBs except PDB$SEED.

E. Executing DBMS_STATS.GATHER_DATABASE_STATSwhile connected to CDB$ROOTgathers object statistics only in CDB$ROOT.

A. FLASHBACK DATABASE

B. FLASHBACK TABLE

C. FLASHBACK DATA ARCHIVE

D. FLASHBACK VERSION QUERY

E. FLASHBACK TRANSACTION

A. ADDM performs its analysis only when a DBA requests it.

B. By default, AWR snapshots are automatically purged after eight days.

C. By default, MMON creates an AWR snapshot every 30 minutes.

D. ADDM can recommend shrinking the buffer cache.

E. ADDM can recommend extending the buffer cache.

F. AWR snapshots must be deleted when no longer required by ADDM.

A. Materialized views that use the CUSTOMERS table are flashed back.

B. All the triggers associated with the table are flashed back but are disabled.

C. All the constraints defined on the table, except the referential integrity constraints, are flashed back.

D. Only the primary key constraint created for the table is flashed back, whereas all other indexes must be retrieved separately.

E. LOB segments associated with the CUSTOMERS table are flashed back.

A. All AWR tables belong to the SYSTEM schema.

B. The AWR data is stored in memory and in t he database.

C. AWR computes time model statistics based on time usage for activities, which are displayed in the v$SYS time model and V$SESS_TIME_MODEL views.

D. AWR contains system wide tracing and logging information.

E. The snapshots collected by AWR are used by the self-tuning components in the database

A. Media Management messages for SBT devices are always written to sbtio.log.

B. Media Management messages for SBT devices are written to an Oracle trace file.

C. The RMAN LOG command line clause causes output issued during RMAN command compilation to be written to a log file only.

D. RMAN error stacks should be read from the top down as that is the order in which errors are generated.

E. The RMAN LOG command line clause causes output issued during RMAN command compilation to be written to a log file and to standard output.

F. RMAN error stacks should be read from the bottom up as that is the order in which errors are generated.