更多"[多选题]Which three are true about Aut"的相关试题:
[多选题]Which three are true about Automatic Workload Repository (AWR)snapshots?
A. They can be retained forever
B. They are generated if statistics LEVEL is set to ALL.
C. They are always created manual
D. They are generated if statistics LEVEL is set to BASIC.
E. They are always created automatically.
F. They are generated if statistics LEVEL is set to TYPICAL
[多选题]Which three are true about patchsets?
A. They are only released quarterly
B. They are installed via Opatch or Opatchauto.
C. A base release is not needed to install patchsets.
D. They can introduce new features
E. They can be applied in a rolling fashion for Clusterware and the databases
F. Installing a patchset is considered an upgrade.
[多选题]Which three are true about recovering tables using RMAN?
A. RMAN can recover tables in the SYSAUX tablespace
B. RMAN always uses an auxiliary instance
C. RMAN can recover a table after a DDL operation has altered the table structure.
D. RMAN can recover tables owned by the sys user.
E. RMAN can recover tables in the SYSTEM tablespace
F. RMAN can recover tables in a standby database
G. RMAN can recover tables owned by the SYSTEM user.
[多选题] Which three are true about Automatic Workload Repository (AWR), Automatic Database
Diagnostic Monitor(ADDM), and the Manageability Monitor(MMON)background process?
A. AWR snapshots must be deleted when no longer required by ADDM
B. By default, MMON creates an AWR snapshot every 30 minutes.
C. ADDM can recommend extending the buffer cache
D. ADDM can recommend shrinking the buffer cache
E. By default, AWR snapshots are automatically purged after eight days
F ADDM performs its analysis only when a DBA requests it.
[多选题] Which three are true about recovery operations done without using Recovery
Manager(RMAN)?
A. A lost SPFILE can be recovered from memory using SQL*PLUS
B. A lost password file can be re-created with SQL*PLUS.
C. A lost password file can be manually re-created with the orapwd utility
D. A lost index tablespace can be re-created without performing any recovery
E. A lost TEMPFILE must always be re-created manually.
F. A lost PFILE can be re-created from alert log using SOL*PLUS
[多选题]Which three are true about interpreting Recovery Manager(RMAN)error stacks returned to
Standard output?
A. If an RMAN command fails, the output will only identify the command that failed
B. If an RMAN command fails, the output will identify the channel ID where the failure occurred.
C. Media Management errors appear as a line with"sbtio
D. Some messages in the error stack are not errors
E. Media Management errors appear as a line with"Additional information and a number.
F. Media Management errors appear as a line with"sbtio and a number.
[多选题]Which three are true about cloning databases into an existing CDB with RMAN?
A. The target and auxiliary instance passwords must be the same.
B. Only one PDB can be cloned at a time
C. Two or more PDBS can be cloned with the same command A NON-CDB can be cloned into a PDB
D. A user with SYSDBA or SYSBKUP must be logged in with RMAN to CDB$ROOT when
Cloning a PDB
E. A user with SYSDBA or SYSBKUP must be logged in with RMAN to the NON-CDB being
Cloned when cloning a NON-CDB
[多选题] Which three are true about Oracle pluggable database(PDBs)?
A. A PDB can be plugged into a CDB only if both are of the same Oracle Database release.
B. A PDB created from PDB$SEED must be set to READ WRITE after loading data.
C. A non-CDB can be converted into a PDB.
D. A PDB created from PDB$SEED must be set to READ ONLY after loading data.
E. An unplugged PDB can be plugged into multiple CDBs simultaneously by sharing data files.
F. A PDB unplugged from a container database(CDBs) can be plugged into a different CDB
Without altering any of schemas.
G. A PDB in a remote CDB can be accessed transparently thereby aggregating results from local
And remote PDBs.
[多选题]Which three are true about transporting databases across platforms using Recovery Manager
(RMAN) image copies?
A. A new DBID is automatically created for the transported database
B. By default, the transported database will use Oracle Managed Files(OMF.
C. Data files can be converted on the source system
D. Databases can be transported between systems with different endian formats
E. Data files can be converted on the destination system
F. The password file is automatically converted by RMAN.
[多选题]Which three are true about upgrading Oracle Grid Infrastructure?
A.The newer version is installed in a separate Oracle Grid Infrastructure home on the same server
As the existing version
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. Only the grid user can perform the upgrade
E. Existing Oracle Database instances must be shut down before starting the upgrade
F.An existing Oracle base can be used.
[多选题]Which three are true about the FLASHBACK DATABASE feature?
A. It always generates REDO and UNDO
B. It requires that the target database be in ARCHIVELOG mode
C. FLASHBACK DATABASE only uses FLASHBACK Logs to get the database to the desired
Flashback time
D. FLASHBACK LOGS are archived after a log switch
E. A database can be flashedback using SQL*PLUS
F. Queries and DML have the same FLASHBACK LOG overhead when flashback is enabled for
A database
[多选题]Which three are true about using Database Upgrade Assistant(DBUA.to upgrade a database?
A. Multiple databases with the same ORACLE HOME can be upgraded simultaneously
B. All pluggable databases are automatically upgraded as part of a container database upgrade.
C. DBUA must be launched from the target Oracle Home
D. The Pre-upgrade Information Tool script is executed by DBUA
E. A whole database backup must exist before upgrade
F. The database must be opened in read-only mode.
[多选题]Which three are true about using Database Resource Manager in an Oracle multitenant
Environment?
A. A Pdb-level resource plan can limit session PGA memory
B. A Cdb-level resource plan is mandatory when using Pdb-level resource plans
C. A Cdb-level resource plan can limit session CPU utilization.
D. A Cdb-level resource plan can limit PDB UNDO use
E. Pdb-level resource plans can limit uncommitted UNDO per consumer group
F. A Cdb-level resource plan can limit PDB CPU utilization.
[多选题]Which three are true about block media recovery?
A. The target database for which one or more blocks are to be recovered must be in the OPEN
State
B. The data file containing the block being recovered remains online
C. It cannot repair logical corruption
D. It can be performed on noncorrupt blocks
E. A block being recovered is not accessible
F. To use it, Flashback Database must be enabled
[多选题]Which three are true about Rapid Home Provisioning (RHP), which has been available since
Oracle 18c?
A. It can be used to deploy Grid Infrastructure homes, including Oracle Restart.
B. It is an Oracle Grid Infrastructure service
C. It is an Oracle Database service
D. It cannot be used to provision middleware.
E. It cannot be used to provision applications
F. It can be used to deploy Oracle Database homes.
[多选题]Which three are true about an application container?
A. It can contain a single application
B. It can contain multiple applications
C. Two application containers can share an application seed PDB
D. An application PDB can belong to multiple application containers
E. It must have an application root PDB
F. It must have an application seed PDB
[多选题]Which three are true about RMAN archival backups with the RESTORE POINT clause?
A. Archive logs are retained if they are necessary to allow the database to be recovered to a
Consistent state when an archival backup is restored
B. The SPFILE is included in the archival backup.
C. The ARCHIVAI attribute for a backup overrides the RMAN retention policy
D. They are never considered obsolete by RMAN
E. They can optionally be written to a fast recovery area(FRA..
F. All archive logs are retained after an archival backup is taken, until the next archival backup is
Taken of the same database
G)Use of a recovery catalog is always required to support the creation and use of archival backups
[多选题]Which three are true about performing an Oracle Database install on Linux?
A. It can be done after installing Grid Infrastructure for a Standalone Server
B. It allows you to select the languages supported by the Oracle database server.
C. The Oracle Preinstallation RPM can be used to configure the Oracle database installation
Owner the Oracle Inventory group, and an Oracle administrative privileges group.
D. It can be done before installing Grid Infrastructure for a Standalone Server
E. The runfixup. sh script can install missing RPMS
F. The Oracle Preinstallation RPM must be used to configure the Oracle database installation
Owner, the Oracle Inventory group, and an Oracle administrative privileges group.
G) The Oracle database administrator must be granted access to the root operating system account
To run root privileged scripts
[多选题]Which three are true about upgrading an application in an application container?
A. The upgrade can be performed when connected either to cdb$root or to PDB$SEED
B. An application name and version number must be specified to upgrade the application
C. After an application upgrade, the application containers pdbs remain synchronized with the
Existing application root
D. The upgrade must be performed when connected to CDB$ROOT
E. An application root clone gets created automatically
F. After an application upgrade, the application containers PDBS are automatically synchronized
With the application root clone