083_在线真题试卷与模拟练习_083

更新时间：试题数量：购买人数：提供作者：

有效期：个月

章节介绍：共有个章节

我的练习

我的错题
(0道)

我的收藏
(0道)

我的斩题
(0道)

我的笔记
(0道)

专项练习

顺序练习 0 / 0

随机练习 自定义设置练习量

题型乱序 按导入顺序练习

模拟考试 仿真模拟

题型练习 按题型分类练习

易错题 精选高频易错题

学习资料 考试学习相关信息

搜索

题库预览

You are administering a multitenant container database (COB) that contains two pluggable databases (PDBs), pdb1 and pdb2. You are connected to pdb2 as a common user with DBA privileges. The statistics_level parameter is PDB modifiable. As the user sys, execute the following command on pdb2: SQL> ALTER SYSTEM SET STATISTICS_LEVEL=ALL SID='*' SCOPE=SPFILE; Which statement is true about the result of this command?

In one of your databases, unified auditing is enabled and an SH.SALES table exists. You successfully execute these commands: SQL> CREATE AUDIT POLICY sales_pol ACTIONS select on sh.sales; SQL> AUDIT POLICY sales_pol; Which statement is true about SALES_POL?

Oracle Data Redaction is active on the SCOTT.EMP table. You queried the table twice.

Choose the best answer. Which should be tuned first when doing a performance tuning exercise for an Oracle Database environment?

A user complains about poor database performance. You want to verify if the user’s session has waited for certain types of I/O activity. Which view displays all waits waited on by a session at least once?

Examine these actions:

1. Create a new database for a recovery catalog.

2. Create a tablespace with sufficient space in the catalog database for the recovery catalog.

3. Configure ARCHIVE LOG mode for the catalog database.

4. Create a user to own the recovery catalog schema with quota on the tablespace that will contain the catalog.

5. Grant the RECOVERY_CATALOG_OWNER role to the recovery catalog schema owner.

6. Grant the SYSBACKUP privilege to the recovery catalog schema owner.

Which are the minimum actions that must be performed before executing the CREATE CATALOG command?

Choose the best answer. Examine this configuration: 1. CDB1 is a container database. 2. 2. DEFAULT_SHARING is METADATA. 3. 3. APP_ROOT is an application root contained in CDB1. 4. 4. APP_PDB1 is an application PDB contained in APP_ROOT. 5. 5. COMPANYAPP is an application contained in APP_ROOT. 6. 6. EMP is a common table created in APP_ROOT and all its application PDBs, created when version 1.0 of COMPANYAPP was installed.

Aplication PDBs, SALES_APP1 and SALES_APP2, must be created and they must access common tables of the SALES APP application. Examine these steps:

1. Install the SALES_APP application, induding the common tables, in the application root.

2. Install the SALES_APP application in the application root and the common tables in both the CDB root and the application root.

3. Create an application seed.

4. Install the SALES_APP application in the application seed.

5. Create the SALES_APP1 and SALES_APP2 application PDBs.

6. Sync the SALES_APP1 and SALES_APP2 application PDBs with the application root.

7. Sync the SALES_APP1 and SALES_APP2 application PDBs with the application seed.

8. Sync the application seed with the application root. Which are the minimum required steps in the correct sequence?

Choose the best answer. Examine this configuration: 1. CDB1 is a container database. 2.COMMON_USER_PREFIX is set to an empty string. 3. PDB1 is a pluggable database in CDB1. 4. APP1_ROOT is an application container in CDB1. 5. APP1_PDB1 is an application PDB in APP1_ROOT. You execute these commands: S sqlplus sys/oracle@localhost:1521/cdb1 as sysdba SQL> CREATE ROLE role1 CONTAINER=CURRENT; Which is true?

Choose the best answer. Your CDB has two regular PDBs as well as one application container with two application PDBs and an application seed. No changes have been made to the standard PDB$SEED. How many default temporary tablespaces can be assigned in the CDB?

RMAN is connected to a target database instance and an auxilary instance. You execute the command: RMAN> DUPLICATE TARGET DATABASE TO dupdb FROM ACTIVE DATABASE SECTION SIZE 1G; What is the outcome?

Choose the best answer. SQL Performance Analyzer (SPA) has reported several regressed SQL statements for one of your databases. Which action could help in the performance management of these regressed SQL statements?

Choose two. Which two are true about PDB archive files?

Choose two. You plan to perform cross-platform PDB transport using XTTS. Which two are true?

HR_ROOT is an application container with the HR_APP application installed. No application PDBs and no application seed have yet been created in HR_ROOT. An application PDB, PDB1,must be created so that the HR_APP application's common objects are accessible to it. Which two methods can be used?

Choose three. Which three actions will add a resource to an Oracle Restart configuration?

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

Choose two. Which two are true about the automatic execution of operating system scripts when performing silent mode installation starting from Oracle Database 19c?

Which two statements are true about the Database Configuration Assistant (DBCA)?

A container database (CDB) contains two pluggable databases PDB1 and PDB2. The LOCAL_UNDO_ENABLED database property is set to FALSE in the CDB. Data file 24 of PDB2 was deleted and you need to restore and recover it. The only RMAN backup that exists was created with the BACKUP DATABASE command while connected to CDB$ROOT. Which three are true? (Choose three.)

1 2 3 4 5 6 15

更多题库