【2025最新版】OPC083 甲骨文Oracle数据库管理II 19c OPC 1Z0-083 认证题库_在线真题试卷与模拟练习_【2025最新版】OPC083 甲骨文Oracle数据库管理II 19c OPC 1Z0-083 认证题库

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

有效期：个月

章节介绍：共有个章节

我的练习

我的错题
(0道)

我的收藏
(0道)

我的斩题
(0道)

我的笔记
(0道)

专项练习

顺序练习 0 / 0

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

题型乱序 按导入顺序练习

模拟考试 仿真模拟

题型练习 按题型分类练习

易错题 精选高频易错题

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

搜索

题库预览

choose one

You want to create a test database as a replica of your production database with minimum intervention from a DBA.

Which method would you use?

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

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&gt;CREATE AUDIT POLICY table_aud PRIVILEGES CREATE ANY TABLE, DROP ANY TABLE
ROLES
Hr_admin,oe_admin;
Which statement is true?

Which statement correctly describes the SQL profiling performed by the SQL Tuning Advisor?

choose one You take regular backups of one of your production databases by

Using RMAN

With a recovery catalog. You have added two new tablespaces to this database

Which must be included in future backups.

Which process occurs which allows the new backups to contain the new datafiles?

After implementing full Oracle Data Redaction, you change the default value for the NUMBER data type as follows:
（含图）

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?

How do you configure a CDB for local undo mode?

You notice that the performance of your production 24/7 Oracle 12c database
Has
Significantly degraded. Sometimes you are not able to connect to the instance
Because it hangs. You do not want to restart the database instance. How can
You detect the cause of the degraded performance?

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?

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.
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 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 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:
（含图）

What will be the outcome and why?

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

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&gt; STARTUP
UPGRADE;
SQL&gt; SHOW pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
2PDB$$SEED
3PDB1
4PDB2
MIGRATE YES
MOUNTED YES
MOUNTED YES
SQL&gt; ALTER PLUGGABLE DATABASE pdb1 OPEN UPGRADE; Pluggable database
Altered. SQL&gt; exit
$$ $ORACLE_HOME/perl/bin/perl catctl.pl -C 'PDB2' What is the outcome?

You plan to create a database by using the Database Configuration Assistant (DBCA), with t he following specifications:

Applications will connect to the database via a middle tier. The number of concurrent user connections will be high.

The database will have mixed workload, with t he execution of complex BI queries scheduled at night.

Which DBCA option must you choose to create the database?

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 one

You want to create a test database as a replica of your production

Database with minimum intervention from a DBA.

Which method would you use?

Choose the best answer. Examine this configuration:
1) CDB1 is a container database.
2) There are several pluggable databases (PDBs) in CDB1.
3) Each PDB has several tables with referential integrity constraints.
4)FLASHBACK DATABASE is ON.
5)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?

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&gt; ALTER SYSTEM SET STATISTICS_LEVEL=ALL SID='*' SCOPE=SPFILE; Which statement
Is true
About the result of this command?

更多题库