瑞通OCP-063

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

有效期：个月

章节介绍：共有个章节

收藏

我的练习

我的错题
(0道)

我的收藏
(0道)

我的斩题
(0道)

我的笔记
(0道)

专项练习

顺序练习 练习进度 0 / 0

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

模拟考试 仿真模拟

题型练习 按题型分类练习

易错题 精选高频易错题

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

搜索

题库预览

In a database supporting an OLTPworkload, tables are frequently updated on both key
And non-key columns. Reports are also generated by joining multiple tables.
Which table organization or type would provide the best performance for this hybrid
Workload?

Your database supports a Decision Support System (DSS)workload that involves the
Execution of complex queries. Currently, the database is running with peak workload. You
Want to analyze some of the most resource-intensive statements cached in the library cache.
What must you run to receive recommendations on the efficient use of indexes and
Materialized views to improve query performance?

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

You issue commands in SQL*Plus as the Oracle owner, to enable multithreading for your
10 / 60UNIX-based Oracle 12c database:
CONNECT /AS SYSDBA
ALTER SYSTEM SET THREADED EXECUTION= TRUE SCOPE=SPFILE;
SHUTDOWN IMMEDIATE
You then restart the instance and get an error:
STARTUP
ORA-01031: insufficient privileges
Why does the startup command return the error shown?

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 production database is running in archivelog mode. You use RMAN with a recovery catalog to back up your database to media and the database is uniquely identified in the recovery catalog.
You want to create a test database from the production database and allow the production database to remain open during the duplicate process. You restore the database backups to a new host with the same directory structure as the production database and want to use the recovery catalog for future backups after the database is successfully restored to the new host.
How would you achieve this?

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?

You specified the warning and critical thresholds for a locally managed tablespace to be

60% and 70%, respectively. From the tablespace space usage metrics, you find that the space

Usage has reached the specified warning threshold value, but no alerts have been generated.

What could be the reason for this?

Your database is running in noarchivelog mode. One of the data files belonging to the system tablespace is corrupted. You notice that all online redo logs have been overwritten since the last backup.
Which method would you use to recover the datafile?

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 reduce fragmentation and reclaim unused space for the sales table but not its
Dependent objects.
During this operation, you want to ensure the following:
I. Long-running queries are not affected.
Ii. No extra space is used.
Iii. Data manipulation language (DML) operations on the table succeed at all times throughout
The process.iv. Unused space is reclaimed both above and below the high water mark. Which alter TABLE
Option would yourecommend?

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 wish to create jobs to satisfy theserequirements:
1 Automatically bulk load data from a flat file.
2 Rebuild indexes on the SALES table after completion of the bulk load.
How would you create these jobs?

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?