更多"[不定项选择题]Which are three of the step"的相关试题:
[不定项选择题]Which are three of the steps taken by Database configuration
Assistant (DBCA) to clone a remote pluggable database (PBD) starting from
Oracle 19c? (Choose three.)
A. creating a database link from CDB$ROOT in the local database to the PDB in
The remote system that is to be cloned
B. creating a database link from CDB$ROOT in the local database to CDB$ROOT
In the remote system that is to be cloned
C. creating a new empty PDB in the local database from PDB$SEED
D. creating a database link from CDB$ROOT in the remote database to be cloned
To CDB$ROOT in the local database
E. automatically dropping the database link to the remote database if it already
Exists
F. creating a database link from CDB$ROOT in the remote database to the PDB in
The local database
G. opening the cloned PDB
[不定项选择题]Choose three. Which are the three steps in the SQL tuning process for
Oracle Database environments?
A.
Tune individual SQL statements using the SQL Tuning Advisor.
B.
Identify poorly tuned SQL statements using Automatic Database Diagnostic
Monitor.
C.
Test the application as a whole using tuned SQL statements.
D.
Test tuned SQL statements one at a time for all statements in the application.
E. Identify poorly tuned SQL statements using the SQL Tuning Advisor.
F. Tune SQL statements as a group using the SQL Tuning and SQL Access
Advisors.
[不定项选择题]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 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 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 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. 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 are true about patchsets?
A.
They are installed via OPatch or OPatchAuto.
B.
A base release is not needed to install patchsets.
C.
They can be applied in a rolling fashion for Clusterware and the databases.
D.
Installing a patchset is considered an "upgrade."
E.
They can introduce new features.
F.
They are only released quarterly.
[不定项选择题]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 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 can be used to deploy Oracle Database homes.
C. It is an Oracle Database service.
D. It cannot be used to provision applications.
E. It cannot be used to provision middleware.
F. It is an Oracle Grid Infrastructure service.
[不定项选择题]Choose three. Which three are true about an application container?
A. It must have an application root PDB.
B. Two application containers can share an application seed PDB.
C. It can contain multiple applications.
D. It can contain a single application.
E. It must have an application seed PDB.
F. An application PDB can belong to multiple application containers.
[不定项选择题]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 actions that can or cannot be performed by users
With the SYSBACKUP privilege?
A.
They can view data from any data dictionary view or dynamic performance
View.
B.
They can drop any tablespace.
C.
They can view data from any user-defined tables.
D.
They can create any table.
E.
They cannot create restore points.
F.
They cannot drop tablespaces.
[不定项选择题]Choose three.
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.
Some messages in the error stack are not errors.
C.
If an RMAN command fails, the output will identify the channel ID where the
Failure occurred.
D.
Media Management errors appear as a line with "Additional information" and
A number.
E. Media Management errors appear as a line with "sbtio" and a number.
F. Media Management errors appear as a line with "sbtio".
[不定项选择题]Choose three. Which three are true about block media recovery?
A. To use it, Flashback Database must be enabled.
B. A block being recovered is not accessible.
C. It cannot repair logical corruption.
D. It can be performed on noncorrupt blocks.
E. The target database for which one or more blocks are to be recovered must be
In the OPEN state.
F. The data file containing the block being recovered remains online.
