Oracle 19c考试原题集锦：创建Application PDBs策略

版权申诉

5星 · 超过95%的资源 70 浏览量更新于2024-07-03 1 收藏 350KB PDF 举报

"该资源为Oracle 19c的考试原题资料，包含了关于Oracle数据库管理的相关问题，旨在帮助考生准备Oracle 19c的认证考试。" 文章内容: Oracle 19c是Oracle数据库的一个版本，具有许多增强功能和优化，特别是在多租户架构方面。这份PDF资料提供的是针对Oracle 19c考试的原题，帮助备考者熟悉考试内容和格式。问题1涉及到在Oracle多租户环境中创建Application PDBs（应用容器数据库）并访问共享的公共表。正确的步骤顺序至关重要。选项C（1,5,6）是正确答案，具体步骤如下： 1. 在应用根容器中安装SALES_APP应用，包括公共表。 2. 创建应用种子。 3. 安装SALES_APP应用到应用种子中。 4. 创建SALES_APP1和SALES_APP2应用PDBs。 5. 同步SALES_APP1和SALES_APP2应用PDBs与应用根。这个过程确保了应用PDBs能够访问应用根中的公共表，并且按照正确的顺序进行操作。问题2提及了一个已包含PDB1的Container Database (CDB1)以及另一个名为C的Container Database。这个问题可能涉及PDB在不同CDB之间的迁移或者管理操作。虽然具体答案未给出，但通常这样的操作可能包括打开/关闭PDB、导出/导入数据、 unplugging（拔出）/plugging in（插入）PDB等步骤。通过这些原题，考生可以深入理解Oracle 19c在多租户环境下的管理，如CDB和PDB的管理、数据安全性、性能优化以及应用部署等方面的知识。对于计划获得Oracle 19c认证的专业人士来说，这份资料是宝贵的复习资源。

CDB$ROOT.

C. After the change, only one undo tablespace can exist in CDB$ROOT.

D. After the change, any user with the required privilege can create an undo tablespace in the PDBs.

E. Undo tablespaces existing in PDBs must be dropped before the change.

F. After the change, each existing PDB has to be reopened for the new undo mode to take effect.

Correct Answer: AB

Section: (none)

Explanation

Explanation/Reference:

QUESTION 42

Which two are true about SQL Performance Analyzer (SPA)? (Choose two.)

A. It is integrated with the SQL Access Advisor.

B. It predicts the impact of system changes on SQL workload response time.

C. It provides before and after execution statistics for each SQL statement in the analysis task

D. It offers fine-grained analysis of all the SQL statements in the analysis task as a group.

E. SQL statements that were originally run concurrently are run concurrently by SPA.

Correct Answer: BC

Section: (none)

Explanation

Explanation/Reference:

QUESTION 43

Which two are true about gathering optimizer statistics? (Choose two.)

A. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers

object statistics in all open PDBs except PDB$SEED.

B. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to a PDB opened in read/

write mode gathers object statistics for that PDB.

C. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers

object statistics only in CDB$ROOT.

D. System statistics can be gathered only while connected to CDB$ROOT.

E. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers

object statistics in all open pluggable databases (PDBs)

Correct Answer: BC

Section: (none)

Explanation

Explanation/Reference:

QUESTION 44

Examine this output: Which two are true? (Choose two.)

A. Any PDB not specified in the plan will be unable to execute statements in parallel.

B. PDB3 can use all available parallel execution processes at times.

C. PDB1 is always limited to 40% of the available system resources regardless of demand.

D. Any PDB notspecified in the plan will be able to use a maximum of 16.5% of the available system

resources.

E. PDB3 is guaranteed to receive at least 20% of the available system resources if there is enough

demand.

F. PDB2 is guaranteed at least 25% of the available parallel execution processes if there is enough

demand.

Correct Answer: F

Section: (none)

Explanation

Explanation/Reference:

QUESTION 45

Which two statements are true about Resource Manager plans for individual pluggable databases (PDB

plans) in a multitenant container database (CDB)?

A. If no PDB plan is enabled for a pluggable database, then all sessions for that PDB are treated to an

equal degree of the resource share of that PDB.

B. In a PDB plan, subplans may be used with up to eight consumer groups.

C. If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups

across all PDBs in the CDB.

D. If no PDB plan is enabled for a pluggable database, then the PDB share in the CDB plan is dynamically

calculated.

E. If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups

based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer

groups in the PDB plan.

Correct Answer: AE

Section: (none)

Explanation

Explanation/Reference:

QUESTION 46

Which two are true about the execution of operating system scripts starting from Oracle Database 19c?

(Choose two.)

A. orainstRoot.sh can be executed automatically by the Database installer by using sudo or root

credentials.

B. root.sh can be executed automatically by the Database Installer only if it is provided with root

credentials.

C. The sudo password can be specified in a response file.

D. root.sh can be executed automatically by the Database installer only by using sudo credentials.

E. The sudo password must be specified in a response file.

F. The root password cannot be specified in a response file.

Correct Answer: AF

Section: (none)

Explanation

Explanation/Reference:

QUESTION 47

Automatic Shared Memory Management is disabled for one of your database instances. Some SQL

statements perform poorly due to excessive hard parse activity, thereby degrading performance. What

would be your next step?

A. Run the SQL Access Advisor.

B. Run the Memory Advisor for the shared pool.

Run the SQL Tunning Advisor.

Run the Memory Advisor for the Program Global Area.

E. Run the Memory Advisor for the System Global Area.

Correct Answer: B

Section: (none)

Explanation

Explanation/Reference:

QUESTION 48

Which two are true about flashback features in Oracle Database 19c and later releases? (Choose two.)

A. Flashback logs are automatically purged when DB_FLASHBACK_RETENTION_TARGET is set lower

than the time they have already been retained.

B. Flashback logs are monitored and proactively deleted when beyond the retention period defined in

DB_FLASHBACK_RETENTION_TARGET only after there is space pressure.

C. Flashback logs are monitored and proactively deleted when beyond the retention period defined in

DB_FLASHBACK_RETENTION_TARGET before there is space pressure.

D. Flashback logs are monitored for being older than the retention period defined in

DB_FLASHBACK_RETENTION_TARGET and can be deleted by an administrator written event trigger.

E. Flashback logs are automatically purged whenever the value of

DB_FLASHBACK_RETENTION_TARGET is changed.

Correct Answer: AC

Section: (none)

Explanation

Explanation/Reference:

QUESTION 49

Examine these queries and their output: After a system crash, an instance restart and an attempted

opening of the PDBs result in: Which two are true? (Choose two.)

A. Data file 24 can be recovered while PDB2 is opened.

B. Data file 24 must be recovered while the CDB is opened.

C. Data file 24 can be recovered while CDB$ROOT and PDB$SEED are opened.

D. Data file 24 cannot be recovered while the CDB is opened.

E. Data file 24 must be recovered while PDB2 is closed.

Correct Answer: AC

Section: (none)

Explanation

Explanation/Reference:

QUESTION 50

Which two are true about RMAN duplexed backup sets? (Choose two.)

A. A duplexed backup set uses the same number of SBT channels as a non-duplexed backup set for the

same number of files.

B. A non-duplexed backup set written to disk can be duplexed to disk by backing up the backup set that is

already on disk.

C. A non-duplexed backup set written to SBT can be duplexed to tape by backing up the backup set that is

already on tape.

D. A non-duplexed backup set written to disk can be duplexed to tape by backing up the backup set that is

already on disk.

E. A non-duplexed backup set written to SBT can be duplexed to disk by backing up the backup set that is

already on tape.

F. A duplexed backup set always uses twice as many SBT channels as a non-duplexed backup set for the

same number of files.

Correct Answer: BD

Section: (none)

Explanation

Explanation/Reference:

QUESTION 51

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.

Correct Answer: ABC

Section: (none)

Explanation

Explanation/Reference:

QUESTION 52

Which two statements are true about RMAN duplexed backups?

A. It is not supported for image copies.

B. It is only supported for backups to tape via the media management interface.

C. Duplex backups can be performed on either disk or media, but cannot be performed on media and disk

simultaneously.

D. Duplex backups can contain only data files and control files.

E. For performing duplexed backups, the parallelism for the device must be set equal to the number of

copies.

Correct Answer: AC

Section: (none)

Explanation

Explanation/Reference:

QUESTION 53

Which three are true about RMAN persistent configuration settings, administration, and their effects?

(Choose three.)

A. A target database’s persistent RMAN configuration settings are always stored in the target’s control file

B. Backup older than the recovery window retention policy are always deleted automatically if the backup

location has insufficient space.

C. Backups written to the fast recovery area (FRA) that are oboslete based on the redundancy retention

policy can be deleted automatically to free space.

D. The RMAN SHOW ALL command displays only settings with nondefault values.

E. A target database’s persistent RMAN configuration settings are always synchronized automatically with

the RMAN catalog.

剩余91页未读，继续阅读

一洋。。

粉丝: 21
资源: 18

Oracle 19c考试原题集锦：创建Application PDBs策略

oracle+19c原题资料（PDF）第一部分

Oracle 19C-083[2021年10月更新].pdf

小布老师oracle材料，第二部分

oracle 资料 (下)

Oracle 19C OCP全程课堂笔记

twp-stats-concepts-19c-5324209.pdf

twp-sql-plan-mgmt-19c-5324207.pdf

ORACLE第一天.pdf

《Oracle从入门到精通》PDF版本下载.txt

oracle9i plsql fundamentals pdf

最新资源