【2026年最新】ORACLE 19c OCP 1Z0-083 EN真题 Oracle Database Administration I (1Z0 083 )_在线真题试卷与模拟练习_【2026年最新】ORACLE 19c OCP 1Z0-083 EN真题 Oracle Database Administration I (1Z0 083 )

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

有效期：个月

章节介绍：共有个章节

我的练习

我的错题
(0道)

我的收藏
(0道)

我的斩题
(0道)

我的笔记
(0道)

专项练习

顺序练习 0 / 0

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

题型乱序 按导入顺序练习

模拟考试 仿真模拟

题型练习 按题型分类练习

易错题 精选高频易错题

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

搜索

题库预览

choose one
You enable Flashback Data Archive for a table for which you want to track and
Save all transactions for four years. After some time, the requirement changes
For keeping transactions from four to
Two years.
You execute the following command to change the
Requirement: SQL> ALTER FLASHBACK ARCHIVE fdal MODIFY
RETENTION 2 YEAR;
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>CREATE AUDIT POLICY tab1e_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 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
2PDB$$SEED
3PDB1
4PDB2
MIGRATE YES
MOUNTED YES
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?

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 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 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?

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 this configuration:
While CDB1 is open, ‘/u02/app/oracle/fast_recover_area/cdb1/CDB1/controlfile02.ctl’is
Accidentally deleted.
To recover from this critical failure, you execute these commands:
What will be the outcome?

Examine this configuration（含图）

SQL> ALTER PLUGGABLE DATABASE app_root CLOSE;

Pluggable database altered.

SQL> FLASHBACK PLUGGABLE DATABASE app_root TO SCN 2074756;

Which table or set of tables will exist after the Flashback operation has completed?

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?

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?

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?