瑞通OCP-063

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

有效期：个月

章节介绍：共有个章节

收藏

我的练习

我的错题
(0道)

我的收藏
(0道)

我的斩题
(0道)

我的笔记
(0道)

专项练习

顺序练习 练习进度 0 / 0

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

模拟考试 仿真模拟

题型练习 按题型分类练习

易错题 精选高频易错题

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

搜索

题库预览

In which three scenarios is media recovery required?

Examine the command to back up theASM metadata:

ASMCMD>md_backup /backup/ASM_backup

In which three situations can you use the backup?

Your multitenant container database (CDB) cdb1, which has no startup triggers and

Contains multiple pluggable databases (PDBs), is started up by using the command:

SQL>STARTUP

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

A complete database backup to media is taken for your database every day. Which three actions would you take to improve backup performance?

Evaluate these statements:
CREATE TABLE purchase_orders
(po_id NUMBER(4),
Po_date TIMESTAMP,
Supplier_id NUMBER(6),
Po_total NUMBER(8,2),
CONSTRAINT order_pk PRIMARY KEY(po_id))
PARTITION BY RANGE(po_date)
(PARTITION Q1 VALUES LESS THAN (TO_DATE('01-apr-2007','dd-mon-yyyy')),
PARTITION Q2 VALUES LESS THAN (TO_DATE('01-jul-2007','dd-mon-yyyy')),
PARTITION Q3 VALUES LESS THAN (TO_DATE('01-oct-2007','dd-mon-yyyy')),
PARTITION Q4 VALUES LESS THAN (TO_DATE('01-jan-2008','dd-mon-yyyy')));
CREATE TABLE purchase_order_items
( po_id NUMBER(4) NOT NULL,
Product_id NUMBER(6) NOT NULL,
Unit_prlce NUMBER(8,2),
Quantity NUMBER(8),
CONSTRAINT po_items_fk FOREIGN KEY(po_id) REFERENCES purchase_orders(po_id))
PARTITION BY REFERENCE (po_items_fk);
Which two statements are true?

You want to create a guaranteed restore point for your database by executing the
Command: SQL> CREATE RESTORE POINT dbrsp1 GUARANTEE FLASHBACKDATABASE;
Identify two prerequisites for the successful execution of this command.

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

Which two resources might be prioritized between competing pluggable databases (PDBs)
When creating a multitenant container database (CDB) plan using Oracle Database Resource
Manager?

Which three statements are true about Oracle Restart?

Which three statements are true about persistent lightweight jobs?

Which three conditions must be met before you create a Virtual Private Catalog (VPC)?

Your database supports an online transaction processing (OLTP) workload in which one
Of the applications creates a temporary table for a session and performs transactions on it.
This consumes a lot of undo tablespace and is affecting undo retention.
Which two actions would you take to solve this problem?

Examine the command and its output:
SQL> DROP TABLE EMPLOYEE;
SQL> SELECT object_name AS recycle_name, original_name, type FROM recyclebin;
RECYCLE_NAME ORIGINAL_NAME TYPE
--------------------------------------------------------------------------------------------------------------
Binsgk31sj/3akk5hg3j21kl5j3d==$$0 EMPLOYEE TABLE
You then successfully execute the command:
SQL> FLASHBACK TABLE "BINSgk31sj/3akk5hg3j21kl5j3d==$$0" TO BEFORE DROP;
Which two statements are true?

You want to consolidate backup information and centrally manage backup and recovery scripts for multiple databases running in your organization.
Which two backup solutions can be used?

user_data is a non encrypted tablespace containing tables with data. You must encrypt all data in this tablespace. Which three methods can do this?

Examine the command:
SQL>RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;
In which two scenarios is this command required?

Which three statements are true about the SQL*Loader utility?

You are administering a multitenant container database(CDB).
Identify two ways to access a pluggable database (PDB) that is open in read-only mode.

Your database is running in archivelog mode andAutomatic Undo Management is enabled.
Which two tasks should you perform before enabling Flashback Database?

Which three statements are true about the database instance startup after an instance failure?

1 6 7 8 9 10 17