083-V1.1_在线真题试卷与模拟练习_083-V1.1

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

有效期：个月

章节介绍：共有个章节

我的练习

我的错题
(0道)

我的收藏
(0道)

我的斩题
(0道)

我的笔记
(0道)

专项练习

顺序练习 0 / 0

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

题型乱序 按导入顺序练习

模拟考试 仿真模拟

题型练习 按题型分类练习

易错题 精选高频易错题

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

搜索

题库预览

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

------------

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.

What must you do to activate the new default value for numeric full redaction?

Choose the best Answer.

Examine this configuration:

1) CDB1 is an Oracle Database 12c Release 2 container database (CDB)..

2) PDB1 and PDB2 are two pluggable databases (PDBs) in CDB1.

After successfully performing all the preupgrade tasks, you execute these

Commands from the Oracle Database 18c environment:

$$ export ORACLE_SID=cdb1

$$ sqlplus / as sysdba

SQL> STARTUP UPGRADE;

SQL> SHOW pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED

---------------------------------------------------------------

2 PDB$$SEED MIGRATE YES

3 PDB1 MOUNTED YES

4 PDB2 MOUNTED YES

SQL> ALTER PLUGGABLE DATABASE pdb1 OPEN UPGRADE;

Pluggable database altered.

SQL> exit

$$ $ORACLE_HOME/perl/bin/perl catctl.pl -C 'PDB2'

What is the outcome?

Unified auditing is enabled in your database. The HR_ADMIN and OE_ADMIN roles exist and aregranted 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?

Choose the best Answer.
Examine this configuration:
1) CDB1 is a container database.
2) APP_ROOT is an application root in CDB1.
3) APP_PDB1 is an application PDB in APP_ROOT.
4) FLASHBACK DATABASE is ON.
You execute these commands:
$$ sqlplus sys/orac1e_4U@localhost:1521/cdb1
SQL> SELECT current_scn FROM v$$database;
CURRENT_SCN
-----------------------
2074756
SQL> CREATE TABLE cdb1_tab(c1 NUMBER) ;
Table created.
SQL> ALTER SESSION SET CONTAINER=app_root;
Session altered.
SQL> CREATE TABLE app_root_tab (c1 NUMBER) ;
Table created.
SQL> ALTER SESSION SET CONTAINER=app_pdb1;
Session altered.
SQL> CREATE TABLE app_pdb1_tab (c1 NUMBER) ;
Table created.
SQL> conn / as sysdba
Connected.
SQL> ALTER PLUGGABLE DATABASE app_root CLOSE;
Pluggable database altered.
SQL> FLASHBACK PLUGGABLE DATABASE app_root TO SCN 2074756;
Flashback complete.
Which table or set of tables will exist after the Flashback operation has completed?

Choose the best Answer.
Examine this configuration:
1) CDB1 is an Oracle container database from an older release.
2) PDB1, PDB2, PDB3, and PDB4 are pluggable databases in CDB1.
A priority list UpgrdList has these entries:
1) pdb2
2) pdb1, pdb3
You execute this command:
$ /u01/app/oracle/product/18.1.0/db_1/rdbms/admin/dbupgrade -L UpgrdList
In which order will the upgrade occur?

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?

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?

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?

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

Oracle Data Redaction is active on the SCOTT.EMP table.
You queried the table twice.
Which is guaranteed to be true concerning the redaction policy?

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?

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

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

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?

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?

Choose the best Answer.
A schema owner truncated a table in error and must recover the data.
Which Oracle Flashback feature could be used to recover the data?

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?

Examine these queries and their output: An online RMAN backup of the CDB was taken an hour before Restore Point R1 was created.
You want to recover PDB1 to Restore Point R1. How do you achieve this?

Choose the best Answer.
Examine this configuration:
1) CDB1 is a container database.
2) DEFAULT_SHARING is METADATA.
3) APP_ROOT is an application root contained in CDB1.
4) APP_PDB1 is an application PDB contained in APP_ROOT.
5) COMPANYAPP is an application contained in APP_ROOT.
6) EMP is a common table created in APP_ROOT and all its application PDBs,
Created when version 1。0 of COMPANYAPP was installed.
You execute these commands:
$ sqlplus sys/orac1e@localhost:1521/cdb1 as sysdba
SQL> ALTER SYSTEM SET DEFAULT_SHARING=DATA;
System altered.
SQL> ALTER SESSION SET CONTAINER=app_root;
Session altered.
SQL> ALTER PLUGGABLE DATABASE APPLICATION companyapp BEGIN UPGRADE '1。0' TO
'2。0';
Pluggable database altered.
SQL> ALTER TABLE emp ADD (sal NUMBER NOT NULL) ;
Table altered.
SQL> ALTER PLUGGABLE DATABASE APPLICATION companyapp END UPGRADE TO '2。0';
Pluggable database altered.
SQL> ALTER SESSION SET CONTAINER=app_pdb1;
Session altered.
SQL> DESC emp;
Name Null? Type
--------------------------------------------------------------
ENO NUMBER
ENAME VARCHAR2 (20)
SQL> SELECT * FROM emp;
ENO ENAME
---------------------------------
100 Alan
200 Ben
SQL> ALTER PLUGGABLE DATABASE APPLICATION companyapp SYNC;
What will be the outcome and why?

1 2 3 4 5 6 10