瑞通OCP-063

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

有效期：个月

章节介绍：共有个章节

收藏

我的练习

我的错题
(0道)

我的收藏
(0道)

我的斩题
(0道)

我的笔记
(0道)

专项练习

顺序练习 练习进度 0 / 0

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

模拟考试 仿真模拟

题型练习 按题型分类练习

易错题 精选高频易错题

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

搜索

题库预览

Which two statements are true about a common user?

Which two statements are true about recovering logically corrupted tables or table
Partitions from an RMAN backup?

YourOracle 12c multitenant container database (CDB) contains multiple pluggable
Databases (PDBs). In the PDB hr_pdb, the common user c##admin and the local user
B_admin have only the connect privilege.
You create a common role c##role1 with the create table and select any table privileges.
You then execute the commands:
SQL> GRANT c##role1 TO c##admin CONTAINER=ALL;
SQL> CONN sys/oracle@HR_PDB as sysdba;
SQL> GRANT c##role1 TO b_admin CONTAINER=CURRENT;
Which two statements are true?

Which two statements are true about theAutomatic Diagnostic Repository (ADR)?

Examine the resources consumed by a database instance whose current Resource
Manager plan is displayed.
SQL> SELECT name, active_sessions, queue_length, consumed_cpu_time, cpu_waits,
Cpu_wait_time FROM v$rsrc_consumer_group;
（含图）
Which two statements are true?

Which three tasks can be automatically performed by theAutomatic Data Optimization feature of Information Lifecycle Management(ILM)?

You want the execution of large database operations to suspend, and then resume, in the
Event of space allocation failures. You set the value of the initialization parameter
Resumable_timeout to 3600. Which two statements aretrue?

For which three pieces of information can you use the RMAN list command?

Examine the parameters for your database instance:
NAME TYPE VALUE
Optimizer_adaptive_reporting_only Boolean FALSE
Optimizer_capture_sql_plan_baselines Boolean FALSE
Optimizer_dynamic_sampling integer 2
Optimizer_features_enable string 12.1.0.1
Which three statements are true about the process of automatic optimization by using
Statistics feedback?

Which three statements correctly describe the relationship amongst jobs, programs, and
Schedules within the Oracle JobScheduler?

Which two statements are true regarding Oracle Data Pump?

RMAN is connected to the target database prod1 and an auxiliary instance in nomount

State. Examine the command to create a duplicate database:

RMAN> DUPLICATE TARGET DATABASE TO dup1 FROM ACTIVE DATABASE

NOFILENAMECHECK PASSWORD FILE SPFILE;

Which two statements are true about the execution of the duplicate command?

Which two statements are true regarding the Oracle Data Pump export and import
Operations?

Which three conditions must be true for unused block compression to be used
Automatically while performing backups by usingRMAN?

Automatic Undo Management is enabled for your database. Youwant a user to
Retrieve metadata and historical data for a given transaction or for transactions in a
Given time interval.
Which three are prerequisites to fulfill this requirement?

Which three statements are true regarding the use of the Database MigrationAssistant
For Unicode (DMU)?

You plan to use the In-Database Archiving feature of Oracle Database 12c, and store
Rows that are inactive for over three months, in Hybrid Columnar Compressed (HCC) format.
Which three storage options support the use of HCC?

A user issues a query on the sales table and receives the following error: ERROR at line 1:ORA-01565: error in identifying file '/u0l/app/oracle/oradata/ORCL/temp01.dbf' ORA-
27037: unable to obtain file status
Which two actions would you take to recover the temporary tablespace?

Which two statements are true regarding SecureFile lobs?

Identify two scenarios in which the RMAN crosscheck command can be used.

1 8 9 10 11 12 17