更多"[多选题]Which three are true about Ora"的相关试题:
[多选题]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 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 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 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 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 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 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 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 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 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 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 Rapid Home Provisioning of Oracle software?
A. It can be used only on nodes with Oracle Grid Infrastructure installed
B. It can be used to patch existing Oracle software installations
C. It can be used to deploy new homes without disrupting active databases.
D. It can be used to upgrade only single-instance databases running on Oracle Restart.
E. It can be used to create templates of Oracle homes as gold images of only Oracle databases
F. It can be used to create a single-instance Oracle Database in an already-installed Oracle home.
[多选题]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 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