更多"[不定项选择题]Which three tasks can be au"的相关试题:
[不定项选择题]Which three RMAN persistent settings can be set for a database?
A. backup retention policy
B. default backup device type
C. default section size for backups
D. default destinations for backups
E. multiple backup device types for a single backup
[不定项选择题]Which three can be done using Oracle Database Configuration Assistant
(DBCA) starting from Oracle Database 19c? (Choose three.)
A. cloning a remote container database in interactive mode
B. cloning a remote pluggable database in silent mode
C. relocating a remote pluggable database in interactive mode
D. relocating a remote container database in silent mode
E. cloning a remote container database in silent mode
F. relocating a remote pluggable database in silent mode
G. relocating a remote container database in interactive mode
[不定项选择题]Which three methods can be used for heap table data migration after
Upgrading a database? (Choose three.)
A. using Database Replay
B. using SQL Developer
C. using Oracle Data Pump
D. using operating system file copy utilities
E. using Database Upgrade Assistant
F. using the CREATE TABLE AS SELECT SQL statement
[不定项选择题]choose three Which three RMAN persistent settings can be set
Explicitly?
A. SPFILE backup duplexing
B. control file auto backup formats
C. archive log deletion policy
D. image copy duplexing
E. redo log backup duplexing
F. archive log backup duplexing
[不定项选择题]Choose three. Which three capabilities require the use of the RMAN
Recovery catalog?
A. using RMAN stored scripts
B. creating encrypted backups
C. creating customized reports about a single database's backups
D. using the REPORT SCHEMA command to list a database's data files and
Tablespaces at times in the past
E. using the KEEP FOREVER clause with the BACKUP command
F. using the REPORT SCHEMA command to list a database's current data files and
Tablespaces
[不定项选择题]choose three Which three are true about RMAN duplexed backup sets or image copies?
A.
A backup set may be duplexed with both copies written to disk.
B.
An image copy on disk can be copied to disk.
C.
A backup set may be duplexed with both copies written to sbt.
D.
A backup set may be duplexed so that one copy is written to sbt and the other
To disk.
E. An image copy on disk can be copied to sbt.
F. An image copy on sbt can be copied to disk.
[不定项选择题]choose three Which three are true about Transparent Data Encryption
(TDE)?
A. It uses a single master key for a database.
B. It replaces secure application roles.
C. It encrypts only data on the client.
D. It stores the current and all past master keys in the keystore.
E. Master encryption keys are managed by Oracle Database Vault.
F. It can encrypt data at the column level.
[不定项选择题]Choose three. Which three activities are possible for PDBs?
A. converting an application seed to an application PDB
B. converting a regular PDB to an application PDB
C. converting an application PDB to an application root
D. copying an application container into another application container in the
Same CDB
E. copying an application container into another application container in a
Different CDB
F. converting an application PDB to an application seed
G. converting an application PDB to a regular PDB
[不定项选择题]Choose three. Which three are performed by Oracle Automatic
Storage Management (ASM) instances?
A. mounting disk groups
B. acting as an I/O server to read data file blocks from ASM disks on behalf of
Database server processes
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 write data file blocks to ASM disks on behalf of
Database Writer processes (DBWn)
[不定项选择题]Choose three. Which three actions will add a resource to an Oracle
Restart configuration?
A. creating a disk group using the CREATE DISKGROUP SQL statement
B. creating a database service using DBMS_SERVICE.CREATE_SERVICE
C. creating a database service using Oracle Database Configuration Assistant
(DBCA)
D. creating a database using the CREATE DATABASE SQL statement
E. creating an Oracle Database service by modifying the SERVICE_NAMES
Parameter
F. creating an Oracle Automatic Storage Management (ASM) instance with ASM
Configuration Assistant (ASMCA)
[不定项选择题]Choose three. Which three resources are always shared among
CDB$ROOT and pluggable databases (PDBs)?
A.
the data dictionary in CDB$ROOT
B.
the log writer process (LGWR)
C.
SYSAUX tablespaces
D.
temporary tablespaces
E. the Process Monitor Process (PMON)
F. undo tablespaces
[不定项选择题]Choose three. Which three actions are mandatory post database
Upgrade?
A. Updating client scripts with the new Oracle home.
B. Resetting passwords to enforce case-sensitivity.
C. Run OPatch commands from the new Oracle home.
D. Setting threshold values for tablespace alerts.
E. Migration to unified auditing.
F. Upgrading user tables that depend on Oracle-maintained abstract data types.
[不定项选择题]choose three. Identify three reasons for using a recovery catalog with
Recovery Manager (RMAN).
A.
to allow database duplication without a connection to the target instance.
B.
to store backup metadata that would cause the controlfile to become too large.
C.
to store backups that would cause the controlfile to become too large.
D.
to report on the database schema at an earlier point in time.
E.
to allow database duplication without a connection to the auxiliary instance.
[不定项选择题]Choose three. Which three are true about configuring CONTROLFILE
AUTOBACKUP by using RMAN?
A. The control file is backed up whenever a new tablespace is created.
B. The server parameter file (SPFILE) is automatically backed up each time the
Control file is backed up.
C. The control file is backed up automatically each time the SPFILE is backed up
Manually.
D. The control file is backed up whenever a new table is created.
E. It requires the use of fast recovery area (FRA).
F. The control file is backed up whenever an RMAN backup is successfully
Recorded in the catalog.
[不定项选择题]Choose three. Which three are true in Oracle 19c and later releases?
A.
Tablespaces always remain in read/write mode during transportable
Tablespace operations.
B.
Tablespaces never remain in read/write mode during transportable tablespace
Operations.
C.
A transportable data pump import can leave a plugged-in tablespace in
Read-only mode.
D.
Simultaneous data pump jobs can be limited at the pluggable database (PDB)
Level.
E. A transportable data pump import can leave a plugged-in tablespace in
Read/write mode.
F. An ordinary data pump export of a table with encrypted columns will always
Encrypt the same columns when imported.
[不定项选择题]Choose three.
Which three are true about creating container databases (CDBs) and
Pluggable databases (PDBs) in Oracle 19c and later releases?
A.
A snapshot copy PDB can be a full copy of a source PDB.
B.
A snapshot copy PDB does not depend on an existing storage snapshot of the
Source PDB.
C.
A PDB snapshot depends on an existing storage snapshot of the source PDB.
D.
A PDB snapshot can be a full copy of a source PDB.
E. A CDB can be duplicated using the Database Configuration Assistant (DBCA) in
Silent mode with no configuration required before starting the duplication.
F. A CDB can be duplicated using Recovery Manager (RMAN) with no
Configuration required before starting the duplication.
G. A PDB snapshot can be a sparse copy of a source PDB.
[不定项选择题]Choose three. Which three are true about OPatch ?
A. It requires installation of Oracle Universal Installer.
B. It supports Rolling Patching.
C. It must be invoked as the user that owns the software being patched.
D. It is a Java-based utility for applying patchsets.
E. It is platform independent.
F. It can be used to apply interim patches to the Grid Infrastructure and Database
Home combination.
[不定项选择题]Choose three. Which three are true about RMAN archival backups with
The RESTORE POINT clause?
A. They are never considered obsolete by RMAN.
B. They can optionally be written to a fast recovery area (FRA).
C. All archive logs are retained after an archival backup is taken, until the next
Archival backup is taken of the same database.
D. 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.
E. The SPFILE is included in the archival backup.
F. Use of a recovery catalog is always required to support the creation and use of
Archival backups.
G. The ARCHIVAL attribute for a backup overrides the RMAN retention policy.