更多"[多选题]Which three are true about Rap"的相关试题:
[多选题]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 the Oracle Optimizer?
A. It can re-optimize execution plans after previous executions detect suboptimal plans
B. It considers the filters in WHERE clauses when generating execution plans for SQL statements
C. It can only use SQL Plan Directives tied to the SQL statement for which a plan is being
Generated
D. It considers object statistics when generating execution plans for SQL statements
E. It updates stale object statistics in the Data Dictionary
F. It obeys all hints.
[多选题]Which three are true about a whole database backup?
A. It can be created only by using RMAN
B. It is the only possible backup type for a database in NOARCHIVELOG mode
C. It can be consistent.
D. It can consist of either backup sets or image copies.
E. It can be inconsistent
F. It always includes all data files, the current control file, the server parameter file, and archived
Redo logs.
[多选题]Which three are true about actions that can or cannot be performed by users with the
SYSBACKUP privilege?
A. They can view data from any user-defined tables.
B. They can drop any tablespace
C. They can create any table.
D. They cannot drop tablespaces
E. They can view data from any data dictionary view or dynamic performance view.
F. They cannot create restore points
[多选题]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 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 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 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 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 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 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 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