OCP-082_在线真题试卷与模拟练习_OCP-082_考试宝

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

有效期：个月

章节介绍：共有个章节

收藏

我的练习

我的错题
(0道)

我的收藏
(0道)

我的斩题
(0道)

我的笔记
(0道)

专项练习

顺序练习 0 / 0

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

题型乱序 按导入顺序练习

模拟考试 仿真模拟

题型练习 按题型分类练习

易错题 精选高频易错题

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

搜索

题库预览

Your database instance is started with an SPFILE. A PFILE is also available.
You execute this command:
ALTER SYSTEM SET DB CACHE_SIZE=100K
Where is the value changed?

Examine the description of the products table:
Which query is valid?

Which two statements are true about space-saving features in an Oracle Database?

Which two statements are true about views?

You currently have an active transaction in your session and have been granted select access to V$TRANSACTION
（含图）
In which three situations will re-executing this query still return a row but with a different XID indicating a new transaction has started?

Which two statements are true about the PMON background process?

Which two statements are true about Database Instances and Real Application Clusters(RAC)?

While one of your databases was in mount state, the datafiles were renamed because they had been moved to a new file system.The database was then opened.

Which two statements are true?

The ORCL database has RESUMABLE_TIMEOUT =7200 and

DEFERRED_SEGMENT_CREATION=FALSE

User U1 has a 1 MB quota in tablespace DATA. Ul executes this command:

（含图）

U1 complains that the command is taking too long to execute. In the alert log, the database administrator (DBA) finds this

2017-03-06912:15:17.183438+05:30

Statement in resumable session 'User U1(136), session 1, Instance 1 ' was suspended due to ORA-01536: space quota exceeded for tablespace'DATA'.

Which are three actions any one of which the DBA could take take to resume the session?

The ORDERS table has a column ORDER_DATE of data type DATE. The default display format for a date is DD-MON-RR
Which two WHERE conditions demonstrate the correct usage of conversion functions?

Which two statements are true about the configuration and use of UNDO RETENTION with no GUARANTEED RETENTION?

1