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

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

有效期：个月

章节介绍：共有个章节

我的练习

我的错题
(0道)

我的收藏
(0道)

我的斩题
(0道)

我的笔记
(0道)

专项练习

顺序练习 0 / 0

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

题型乱序 按导入顺序练习

模拟考试 仿真模拟

题型练习 按题型分类练习

易错题 精选高频易错题

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

搜索

题库预览

Which two are true about OS groups and users for Oracle Grid Infrastructure and the Oracle Relational Database Management System (RDBMS)? (Choose two.)

Which four are true about duplicating a database using Recovery Manager (RMAN)? (Choose four.)

choose two Examine these 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 two statements are true about the DUPLICATE command?

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 three You want to duplicate one of your databases when connected to the target database and to the recovery catalog.
Which three are true about this type of database duplication

choose two Examine the command to duplicate a database:
RMAN> DUPLICATE TARGET DATABASE TCddb PLUGGABLE DATABASE pdbl,pdb5;
Which two statements are true about the DUPLICATE command?

choose three Identify three reasons for using a recovery catalog with Recovery Manager (RMAN).

Choose the best answer You want to create a duplicate database DUP_DB from your production database PROD on the same host.

The PROD database uses Automatic Storage Management (ASM) for storage.

Regular backups are taken using RMAN connected to a recovery catalog.

You create an auxiliary instance and want to execute the command:

RMAN> DUPLICATE TARGET DATABASE TO dup_db FROM ACTIVE DATABASE;

What is a prerequisite for the successful execution of this command

A container database called CDB1 is OMF-enabled. PDB_FILE_NAME_CONVERT is not configured in CDB1. PDB1 was unplugged from CDB1 earlier in the week.
Examine this command, which will be executed in CDB1:
CREATE PLUGGABLE DATABASE pdb1 USING ‘/u01/app/oracle/oradata/pdb1.xml’ SOURCE_FILE_NAME_CONVERT=(‘/u01/app/oracle/oradata/’,‘/u02/app/oracle/ oradata/’);
Which two are true? (Choose two.)

Which three are true about transporting databases across platforms using Recovery Manager (RMAN) image copies? (Choose three.)

Examine this command: $ rhpctl move database –sourcehome Oracle_home_path – destinationhome Oracle_home_path For which two purposes can you use this command? (Choose two.)

Which two are true about changing the LOCAL_UNDO_ENABLED property to false in a CDB? (Choose two.)

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

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?

Which two are true about gathering optimizer statistics? (Choose two.)

Examine this output: Which two are true? (Choose two.)

Which two statements are true about Resource Manager plans for individual pluggable databases (PDB plans) in a multitenant container database (CDB.?

Which two are true about the execution of operating system scripts starting from Oracle Database 19c? (Choose two.)

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?

1 2 3 4 5 6 15

更多题库