083_在线真题试卷与模拟练习_083_考试宝

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

有效期：个月

章节介绍：共有个章节

收藏

我的练习

我的错题
(0道)

我的收藏
(0道)

我的斩题
(0道)

我的笔记
(0道)

专项练习

顺序练习 0 / 0

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

题型乱序 按导入顺序练习

模拟考试 仿真模拟

题型练习 按题型分类练习

易错题 精选高频易错题

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

搜索

题库预览

Which two are true about flashback features in Oracle Database 19c and later releases? (Choose two.)

Examine these queries and their output:
SQL> select log_mode from v$$database;
LOG_MODE
------------------------------------
ARCHIVELOG
SQL> select property_name,property_value from database_properties where property_name like '%UNOD%';
PROPERTY_NAMR PROPERTY_VALUE
------------------ ---------------
LOCAL_UNDO_ENABLED FALSE
SQL> select p.name,f.file#, t.name
2 from v$$containers p,v$$datafile
F,v$$tablespace t
3 where p.con_id=f.con_id
4 and p.con_id=t.con_id
5 and t.ts#=f.ts#
6 order by 1,2;
NAME FILE# NAME
------ ------- -----------
CDB$ROOT 1 SYSTEM
...
PDB1
...
PDB2
24 SYSTEM
16 SYSTEM
After a system crash, an instance restart and an attempted opening of the PDBs result in:
SQL> startup quiet
ORACLE instance started.
Database mounted.
Database open.
SQL> alter pluggavle database all open;
Alter pluggavle database all open
*
ERROR at line 1:
ORA-01157: cannot identify/lock data file 24 - see DBWR trace file
ORA-01110: data file 24:
'/ u 0 1 / orda t a / V 1 2 2 C D B1 / 5 1 6 0 0 0 7 2 D 4 6 4 D 0 4 E0 5 4 0 0 0 C 2 9 7 4 1 6 4 / da t a fi le /
O1_mf_system_dmj30kld_.dbf'
Which two are true? (Choose two.)

Which two are true about RMAN duplexed backup sets? (Choose two.)

choose three Which three are true about RMAN duplexed backup sets or image copies?

Which two statements are true about RMAN duplexed backups?

Which three are true about RMAN persistent configuration settings, administration, and their effects? (Choose three.)

choose three Which three RMAN persistent settings can be set explicitly?

Which three RMAN persistent settings can be set for a database?

The persistent configuration settings for RMAN have default for all parameters. Identify four RMAN commands that produce a multi-section backup.

The CATDB12c database contains an Oracle Database version 12c catalog schema owned by the RC12C user.
The RCAT11 database contains an Oracle Database version 11g catalog schema owned by the RC11 user in which several databases are registered. Both the databases are open.
You execute the RMAN commands:
RMAN> CONNECT CATALOG rcl2c/passl2c@catdbl2c
RMAN> IMPORT CATALOG rcll/pwdcatll@ractll
Which two tasks are performed as part of the import?

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?

Which three are true about Optimizer Statistics Advisor? (Choose three.)

You issued this command: RMAN> BACKUP RECOVERY FILES;
Which two are true? (Choose two.)

Which two are true about the Oracle database methodology? (Choose two.)

While backing up to the Oracle Fast Recovery Area (FRA., you determined the backup istaking too long and suspect a performance bottleneck.
Which three are true about diagnosing and tuning these problems? (Choose three.)

Choose two. You are managing this configuration:
1). CDB1 is a container database.
2). PDB1 and PDB2 are two pluggable databases in CDB1.
3). USER1.EMP is a table in PDB1 and USER2.DEPT is a table in PDB2 .
CDB1 user SYS executes these commands after connecting successfully to PDB2:
SQL> ALTER SESSION SET CONTAINER=pdb1;
Session altered.
SQL> INSERT INTO user1.emp VALUES (100, 'Alan' ,1) ;
1 row created.
SQL> INSERT INTO user1.emp VALUES (101, 'Ben' ,1) ;
1 row created.
SQL> ALTER SESSION SET CONTAINER=pdb2;
Session altered.
SQL> INSERT INTO user2.dept VALUES(1, 'IT');
Which two are true? (Choose two.)

Examine this configuration:

1). CDB1 is an Oracle Database 12c Release 2 database containing pluggable databases PDB$$SEED, PDB1, and PDB2.

2). PDB$$SEED is open READ ONLY.

3). PDB1 is open READ WRITE.

4). PDB2 is MOUNTED.

5). ORACLE_HOME is /u01/app/oracle/product/18.1.0/dbhome_1.

You execute these commands before upgrading the database to the current release: For which databases will fixup scripts be created?

Which two are true about Oracle Flashback features? (Choose two.)

Which three are true about an application seed pluggable database (PDB.? (Choose three.)

Examine this configuration: 1. CDB1 is a container database. 2. PDB1 and PDB2 are pluggable databases in CDB1. 3. PDB1 and PDB2 are OPEN in READ WRITE mode.
You execute these commands successfully: Which two are true? (Choose two.)

更多题库