题目详情
当前位置:首页 > 职业培训考试
题目详情:
发布时间:2024-07-04 02:40:54

[不定项选择题]Which three are true about opatch auto? (Choose three.)
A. It performs a shutdown and then a restart of all processes in both Oracle Grid
Infrastructure and Oracle Database home during the patching process.
B. It must be invoked by a user with root user privileges.
C. Patches are applied via opatchauto.
D. Users must always input patch plans to opatchauto.
E. It requires the Oracle Grid Infrastructure and Oracle Database instances to be
Shut down before being invoked.
F. It applies patches in nonrolling mode by default.
G. It is used to apply interim patches to Oracle Grid Infrastructure and Oracle
Database home combinations.

更多"[不定项选择题]Which three are true about "的相关试题:

[不定项选择题]Which three statements are true about Automatic Workload

Repository (AWR)?


A.

All AWR tables belong to the SYSTEM schema.


B.

The AWR data is stored in memory and in the database.


C.

The snapshots collected by AWR are used by the self-tuning components in the database


D.

AWR computes time model statistics based on time usage for activities, which

Are displayed in t he v$SYS time model and V$SESS_TIME_MODEL views.


E. AWR contains system wide tracing and logging information.
[不定项选择题]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 SGA memory management in a multitenant

Database?


A. SGA_MIN_SIZE cannot be set for a PDB.
B. Setting SHARED_POOL_SIZE for a PDB guarantees a minimum amount of
Shared Pool memory for that PDB.
C. Setting SGA_TARGET for a PDB guarantees a minimum amount of SGA
Memory for that PDB.
D. The SHARED_POOL_SIZE setting for a PDB can be up to 80% of the
SHARED_POOL_SIZE setting of the root container.
E. Setting DB_CACHE_SIZE for a PDB guarantees a minimum amount of Database
Buffer Cache memory for that PDB.
F. The SGA_TARGET setting for a PDB cannot exceed 50% of the SGA_TARGET
Value of the root container.
[不定项选择题]Choose three. Which three are true about upgrading an application in

An application container?


A.

An application root clone gets created automatically.


B.

The upgrade can be performed when connected either to CDB$ROOT or to

PDB$SEED.


C.

After an application upgrade, the application container's PDBs remain

Synchronized with the existing application root.


D.

The upgrade must be performed when connected to CDB$ROOT.


E. An application name and version number must be specified to upgrade the
Application.
F. After an application upgrade, the application container's PDBs are
Automatically synchronized with the application root clone.
[不定项选择题]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.
[不定项选择题]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.
[不定项选择题]Choose three. Which three are true about post-upgrade activities

When upgrading an Oracle database using Database Upgrade Assistant?


A.

Any Recovery Manager (RMAN) recovery catalog must be upgraded manually.


B.

After a manual upgrade, TNSNAMES.ORA entries must be updated to reflect

The new ORACLE_HOME.


C.

Time zone files must be upgraded manually using the DBMS_DST PL/SQL

Package.


D.

The new extended data type capability must be enabled by running the

Utlrp.sql script


E. The Oracle Application Express configuration should be updated after
Upgrading Oracle Database.
[不定项选择题]Choose three. Which three are true about Audit policies in container
Databases (CDBs)?
A. All audit records are written to the audit trail in CDB$ROOT .
B. Application-common unified audit policies defined in an application root must
Be manually synchronized by each application PDB contained in the application
Root.
C. Fine-grained auditing policies defined in an application root must be manually
Synchronized by each application PDB contained in the application root.
D. A common unified audit policy can be created at the CDB level.
E. A common unified audit policy can be created at the application root level.
F. An application PDB cannot have a local audit policy.
[不定项选择题]Choose three. Which three are true about corrupted data blocks and

Their recovery in an Oracle Database?


A.

If a row lock is held by a nonexistent transaction, the block containing the row

Is media corrupt.


B.

DB_BLOCK_CHECKING=TRUE causes a check sum to be added to each data

Block to help detect physical or media corruption.


C.

A media corrupt block is one where the block is not formatted correctly.


D.

The ANALYZE TABLE VALIDATE STRUCTURE CASCADE command verifies that

Each table row has an index entry pointing to it.


E. If a row lock is held by a nonexistent transaction, the block containing the row
Is logically corrupt.
F. DB_LOST_WRITE_PROTECT=TYPICAL causes extra logging overhead on the
Standby database.
[不定项选择题]Choose three. Which three are true about Data Pump in an Oracle

Multitenant environment?


A. It can be used to transport data from a non-CDB to a PDB.
B. It can be used to clone a CDB.
C. It can be used to transport data between PDBs.
D. It can be used to transport data from a PDB to a non-CDB.
E. It can be used to create a new PDB.
[不定项选择题]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 a whole database backup?
A. It can be created only by using RMAN.
B. It always includes all data files, the current control file, the server parameter file,
And archived redo logs.
C. It can be consistent.
D. It is the only possible backup type for a database in NOARCHIVELOG mode.
E. It can consist of either backup sets or image copies.
F. It can be inconsistent.
[不定项选择题]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 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 the Oracle Optimizer?
A.

It considers the filters in WHERE clauses when generating execution plans for SQL statements.


B.

It obeys all hints.


C.

It considers object statistics when generating execution plans for SQL statements.


D.

It updates stale object statistics in the Data Dictionary.


E. It can only use SQL Plan Directives tied to the SQL statement for which a plan
Is being generated.
F.

It can re-optimize execution plans after previous executions detect suboptimal plans.

[不定项选择题]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.
[不定项选择题]Which three are true about managing memory components in an

Oracle database instance? (Choose three.)


A. With Automatic Shared Memory Management, the database instance can
Increase the Large Pool size by reducing the Shared Pool size.
B. With Automatic Memory Management, the database instance can increase the
System Global Area size by reducing the Program Global Area size.
C. Automatically tuned and resized System Global Area components will always
Revert to their initial sizes after an instance restart.
D. Automatic Memory Management must be used together with locking the
System Global Area into physical memory.
E. With Automatic Shared Memory Management, the database instance can
Increase the Program Global Area size by reducing the System Global Area size.
F. On Line Transaction Processing systems often use less Program Global Area
Than Decision Support Systems.
[不定项选择题]Which three are true about Automatic Workload Repository (AWR)?

(Choose three.)


A. By default, AWR snapshots are taken every 60 minutes.
B. Its collection level is determined by the value of the STATISTICS_LEVEL
Database parameter.
C. By default, AWR snapshots are retained for 7 days.
D. The taking of AWR snapshots can be disabled.
E. AWR data is stored in the SYSTEM tablespace.
[不定项选择题]Which three are true about an application seed pluggable database

(PDB)? (Choose three.)


A.

It is automatically synchronized with its application root PDB when an

Application is upgraded.


B.

It cannot be added to an application container after the application container

Has already been created.


C.

A new application PDB created by cloning an application seed PDB can have

An old version of the application installed after cloning completes.


D.

It is automatically synchronized with its application root PDB when an

Application is installed.


E. It cannot be dropped from its application container.
F. A new application PDB created by cloning an application seed PDB can have
An up-to-date version of the application installed after cloning completes.
G. It is not required in an application container.

我来回答:

购买搜题卡查看答案
[会员特权] 开通VIP, 查看 全部题目答案
[会员特权] 享免全部广告特权
推荐91天
¥36.8
¥80元
31天
¥20.8
¥40元
365天
¥88.8
¥188元
请选择支付方式
  • 微信支付
  • 支付宝支付
点击支付即表示同意并接受了《购买须知》
立即支付 系统将自动为您注册账号
请使用微信扫码支付

订单号:

请不要关闭本页面,支付完成后请点击【支付完成】按钮
恭喜您,购买搜题卡成功
重要提示:请拍照或截图保存账号密码!
我要搜题网官网:https://www.woyaosouti.com
我已记住账号密码