083-100-200_在线真题试卷与模拟练习_083-100-200_考试宝

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

有效期：个月

章节介绍：共有个章节

收藏

我的练习

我的错题
(0道)

我的收藏
(0道)

我的斩题
(0道)

我的笔记
(0道)

专项练习

顺序练习 0 / 0

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

题型乱序 按导入顺序练习

模拟考试 仿真模拟

题型练习 按题型分类练习

易错题 精选高频易错题

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

搜索

题库预览

You notice a performance change in your production Oracle 12c database. You want to know which Change caused this performance difference. Which method or feature should you use?

In a recent Automatic Workload Repository (AWR) report for your database, you notice a high Number of buffer busy waits. The database consists of locally managed tablespaces with free list managed segments. On further investigation, you f ind that buffer busy waits is caused by contention on data blocks. Which option would you consider first to decrease the wait event immediately?

.Examine the RMAN command: RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON; RMAN> BACKUP DATABASE PLUS ARCHIVELOG; Which prerequisite must be met before accomplishing the backup?

Unified auditing is enabled in your database. The HR_ADMIN and OE_ADMIN roles exist and are Granted system privileges. You execute the command: SQL>CREATE AUDIT POLICY table_aud PRIVILEGES CREATE ANY TABLE, DROP ANY TABLE ROLES Hr_admin,oe_admin; Which statement is true?

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?

Choose the best answer. Examine this configuration: 1-CDB1 is a container database running in ARCHIVELOG mode. 2-Multiple uncommitted transactions are running in CDB1 . 3-Redo log groups 1 and 2 are INACTIVE. 4-Redo log group 3 is the CURRENT group. All members of redo log group 3 are lost before it is archived. Examine these possible steps: 1-SHUTDOWN ABORT 2-STARTUP NOMOUNT 3-STARTUP MOUNT 4-ALTER DATABASE MOUNT 5-RESTORE DATABASE 6-RECOVER DATABASE NOREDO 7-RECOVER DATABASE UNTIL AVAILABLE 8-RESTORE ARCHIVELOG ALL 9-ALTER DATABASE OPEN 10-ALTER DATABASE OPEN RESETLOGS Choose the minimum required steps in the correct order to recover the database.

Choose the best answer. Which statement correctly describes the SQL profiling performed by the SQL Tuning Advisor?

Choose the best answer. On the 10th of August, you implement an incremental database backup strategy and configure a Recovery window of five days. Level 0 backups are taken on the 10th, 17th, and 24th of August. Differential level 1 incremental backups are taken daily between the level 0 backups. Today is the 26th of August. Which backups will be obsolete?

Choose the best answer. How do you configure a CDB for local undo mode?

After implementing full Oracle Data Redaction, you change the default value for the NUMBER Data type as follows: SQL> select number_value from REDACTION_VALUES_FOR_TYPE_FULL; NUMBER_VALUE ------------ 0 SQL> exec DBMS_REDACT.UPDATE_FULL_REDACTION_VALUES(-1); SQL> select number_value from REDACTION_VALUES_FOR_TYPE_FULL; NUMBER_VALUE ------------ -1 After changing the value, you notice that FULL redaction continues to redact numeric data with Zero.您注意到FULL 编校继续以零编校数值数据也就是上面的修改还没有生效，该命令是把 Number 的数据类型编辑以后默认值为－1。 What must you do to activate the new default value for numeric full redaction?

Oracle Data Redaction is active on the SCOTT.EMP table.

You queried the table twice.

SQL> SELECT ENAME, SAL, COMM, MGR, HIREDATE FROM EMP WHERE

DEPTNO=30;

（含图）

SQL> SELECT ENAME, SAL, COMM, MGR, HIREDATE FROM EMP WHERE

DEPTNO=30;

（含图）

Which is guaranteed to be true concerning the redaction policy?

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?

What is the effect of specifying the "ENABLE PLUGGABLE DATABASE" clause in a "CREATE DATABASE" statement?

Examine the RMAN command: RMAN> RUN { ALLOCATE CHANNEL c1 DEVICE TYPE sbt; ALLOCATE CHANNEL c2 DEVICE TYPE sbt; ALLOCATE CHANNEL c3 DEVICE TYPE sbt; BACKUP INCREMENTAL LEVEL = 0 (DATAFILE 1,4,5 CHANNEL c1) (DATAFILE 2,3,9 CHANNEL c2) (DATAFILE 6,7,8 CHANNEL c3); SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT'; } Which statement is true about the command?

Choose one Examine the RMAN commands: RMAN> CONNECT TARGET "sbu@prod AS SYSBACKUP"; RMAN> CONNECT AUXILIARY "sbu@dup_db AS SYSBACKUP"; RMAN> DUPLICATE TARGET DATABASE TO dup_db FROM ACTIVE DATABASE PASSWORD FILE SECTION SIZE 400M; Which statement is true about the DUPLICATE command?

Choose the best answer. Application 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, including 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-There are several pluggable databases (PDBs) in CDB1. 5-Each PDB has several tables with referential integrity constraints. 6-FLASHBACK DATABASE is ON. 7-UNDO RETENTION GUARANTEE is enabled. Multiple undesired multitable changes were made in all the PDBs. Which method can be used to undo the changes using a single command?

Which three are true about Automatic Workload Repository (AWR)? (Choose three.)

Which three statements are true about Automatic Workload Repository (AWR)?

Which two are true about automatic block repair? (Choose two.)