更多"[多选题]Which two are true about an Or"的相关试题:
[多选题] 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 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 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 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 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 Oracle Grid Infrastructure for a Standalone Server?
A. It includes both Oracle Restart and Oracle Automatic Storage Management(ASM) software.
B. It creates one disk group during installation.
C. It requires the operating system ORACLE_BASE environment variable to be predefined before
Installation.
D. It requires Oracle ASMLib to manage Automatic Storge Management(ASM) disks.
E. It requires Oracle ASM Filter Driver(ASMFD. to manage Automatic Storge
Management(ASM) disks.
F. Automatic Storge Management(ASM) requires that O/S groups OSASM and OSDBA be
Assigned as secondary groups for its installation owner.
[多选题]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 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 Optimizer Statistics?
A. They are ignored by Optimizer if they are stale.
B. They provide real-time data about schema objects
C. By default, they are automatically gathered by a maintenance job
D. They are gathered by the SQL Tuning Advisor
E. They can be gathered by the DBMS_STATS package
[多选题]Which two are true about duplicating pluggable databases(PDBS) with RMAN?
A. CDB$ROOT and PDBSSEED are automatically duplicated if a PDB is duplicated
B. A user with SYSDBA or SYSBKUP must use RMAN logged in to a PDB in order to duplicate
It.
C. Two or more PDBS can be duplicated with the same RMAN DUPLICATE command
D.The auxiliary instance is automatically created with ENABLE PLUGGABLE DATABASE
TRUE
E. All tablespaces belonging to a PDB must be duplicated when duplicating the PDB
[多选题]Which two are true about the automatic execution of operating system scripts when performing
Silent mode installation starting from Oracle Database 19c?
A. The installer will prompt for the root or sudo password
B.Silent install always runs operating scripts automatically.
C. The response file can specify the root or sudo password
D.The response file must contain the root or sudo password
E. The response file can specify the path of the sudo program
[多选题]Which two are true about reclaiming space used by Flashback logs in Oracle Database 19c and
Later releases?
A.Space is only reclaimed when there is space pressure in the Fast Recovery Area(FRA、
B.Space is always reclaimed automatically when the retention period for Flashback logs is
Lowered
C.Space might be reclaimed proactively before space pressure occurs
D.Space is always reclaimed proactively before space pressure occurs
E. Space might be reclaimed automatically when the retention period for Flashback logs is
Lowered
[多选题]Which two are true about creating pluggable databases(PDBS)in Oracle 19c and later releases?
A. A PDB snapshot depends on an existing storage snapshot of the source PDB
B. A PDB snapshot can be a full copy of a source PDB
C. A PDB snapshot can be a sparse copy of a source PDB
D. A snapshot copy PDB does not depend on an existing storage snapshot of the source PDB
E. A snapshot copy PDB can be a full copy of a source PDB
[多选题]Which two are true about creating RMAN backups for an Oracle container database?
A. Control file backups can be created while connected to cdb$root
B. The BACKUP TABLESPACE command can back up a PDB tablespace even if RMAN is
Connected to CDB$ROOT
C. Online Redo Log backups can be created while connected to CDB$ROOT.
D. Control file backups can not be created while connected to a PPB.
E. Archived Redo Log backups can be created while connected to PDB
[多选题] Which two are true about RMAN duplexed backup sets?
A. They can be written to media
B. They can be created only by using the copies option of a BACKUP command
C. They can be created by using the RMAN CONFIGURE command to specify duplexing before
Taking a backup
D. They can be written only to disk.
E. They must be written to media
[多选题]Which two are true about memory advisors?
A. If Automatic Memory Management is enabled, the Shared Pool Advisor and Buffer Cache
Advisor are available to set the maximum size for these individual System Global Area
Components
B. If Manual Shared Memory Management is enabled, only the Shared Pool Advisor and Buffer
Cache Advisor are available
C.If Automatic Shared Memory Management is enabled, both the SGA Advisor and PGA Advisor
Are always available.
D. If Automatic Memory Management is enabled, no memory advisors are available.
E. All memory advisors use data from Automatic Workload Repository
