更多"[多选题] Which three are true about Or"的相关试题:
[多选题] 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 Oracle Restart?
A. You can add and remove components from an Oracle Restart configuration with Server Control
(SRVCTL) commands
B. It can manage Oracle Database instances, Oracle Net Listeners, and Oracle Automatic Storage
Management instances
C. It runs from the Oracle Grid Infrastructure home
D. It is used in both clustered and non-clustered environments
E. If you shut down a database instance with sol*plus, Oracle Restart interprets this as a
Database failure and attempts to restart the instance
F. The Server Control (SRVCTL)utility can be used to start and stop Oracle Restart
[多选题]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 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 two are true about Oracle Grid Infrastructure for a Standalone Server?
A. It requires Oracle Automatic Storage Management(ASM)components to be installed separately
B. The CSS daemon runs from the Grid Infrastructure home
C. It can manage database resources on the server where it is installed or on a different server.
D. It supports volume management, file system, and automatic restart capabilitiesE. It must be installed before the Oracle database software is installed
[多选题]Which three are true in Oracle 19c and later releases?
A. Simultaneous data pump jobs can be limited at the pluggable database(PDB. level
B. An ordinary data pump export of a table with encrypted columns will always encrypt the same
Columns when imported
C. Tablespaces always remain in read/write mode during transportable tablespace operations
D. A transportable data pump import can leave a plugged-in tablespace in read/write mode.
E. Tablespaces never remain in read/write mode during transportable tablespace operations
F. A transportable data pump import can leave a plugged-in tablespace in read-only mode
[多选题] Which two are true about Oracle instance recovery?
A. Recovery begins from the beginning of the CURRENT redo log group.
B. Recovery begins from the start of any ACTIVE redo log group or the start of the CURRENT
Log group if no other group is ACTIVE
C. Recovery begins from the last checkpoint position that was recorded in the control file by the
Checkpoint process (ckpt)
D. Recovery begins from the last checkpoint position that was calculated by the Database Writer
Before instance failure
E. Recovery reads redo until the end of the redo thread, and then opens the database. SMON then
Rolls back any dead transactions
F. Recovery reads redo until the end of the redo thread. SMON rolls back any dead transactions,
And then the database is opened
[多选题]Which two are true about various Oracle security and auditing capabilities
A. Application-common Transparent Security Data Protection(TSDP)policies can be created only
If all the PDBS in the application container are closed
B. Unified auditing can be automatically synchronized to all application PDBS in an application
Container
C. Application-common OLS policies can be created only if all the PDBS in the application
Container are closed
D. Fine-grained auditing (FGA )policies in an application root are automatically synchronized to
All application PDBS contained in the application container when they are updated
E. Application-common TSDP policies are always container specific.
[多选题]Which two are true about an Oracle gold image-based installation in Oracle 18c and later
Releases?
A. It does not require the setup wizard
B. It can be used to install and upgrade Oracle Database for single-instance and clusterconfigurations
C. It can be used for both Oracle Database and Oracle Grid Infrastructure installation
D. It uses a single RPM that automatically extracts and installs the Oracle Database software
E. It can only install and configure Oracle Database software. The database has to be create
Separately.
[多选题]Which two are true about an Rpm-based Oracle Database installation?
A. It requires an Unbreakable Linux Network(ULN)subscription
B. It uses a service configuration script to create a single-instance database as part of the
Installation
C. It performs a software-only Oracle Database installation
D. It includes the Oracle Preinstallation RPM
E. From Oracle Database 18c, a single RPM can be used to install only Oracle Database Server
For a single instance
[多选题]Which two are true about a read-only Oracle home?
A. It contains an image that can be distributed across multiple servers
B. It is enabled by performing a software-only Oracle Database installation and then running the
Roohctl-enable script
C. It is enabled by performing an Oracle Database installation with database creation and then
Running the roohctl -enable script.
D. It requires the Rapid Home Provisioning service.
E. It’s configuration data and log files reside in subdirectories under the Oracle home
[多选题] Which three are performed by Oracle Automatic Storage Management(ASM)instances?
A. mounting disk groups
B. managing Allocation Units (AUS)for disk group content
C. managing extent allocation for Oracle database segments
D. acting as an I/O server to read data file blocks from ASM disks on behalf of database server
Processes
E. acting as an I/O server to write data file blocks to ASM disks on behalf of Database Writer
Processes(DBWR)
F. managing space allocation for Oracle ASM files
[多选题]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 Automatic Workload Repository (AR)and Automatic Database
Diagnostic Monitor(ADDM)in an Oracle multitenant environment?
A. AWR snapshots can be created in CDB$ROOT
B. No AWR data is stored in the CDBSROOT SYSAUX tablespace
C. ADDM can run in a nonroot container
D. All AWR data is stored in the CDBSROOR SYSAUX tablespace
E. AWR snapshots can be created in a PDB
F. AWR reports can be generated while connected to any container
[多选题]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 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.
