062_在线真题试卷与模拟练习_062

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

有效期：个月

章节介绍：共有个章节

我的练习

我的错题
(0道)

我的收藏
(0道)

我的斩题
(0道)

我的笔记
(0道)

专项练习

顺序练习 0 / 0

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

题型乱序 按导入顺序练习

模拟考试 仿真模拟

题型练习 按题型分类练习

易错题 精选高频易错题

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

搜索

题库预览

You plan to upgrade your Oracle Database 9i to Oracle Database 12c. Which two methods can you use?

Which two statements describe the relationship between a scheduler window, a resource manager plan, and a job class?

Which are two ways for a database service to be recognized by a listener in Oracle Database 12c?

Your database is configured for ARCHIVELOG mode, and a daily full database backup is taken. RMAN is configured to perform control file autobackup. In which three scenarios do you need media recovery?

Examine the parameters for a database instance：

NAME TYPE VALUE

temp_undo_enabled boolean TRUE

undo_management string AUTO

undo_retention integer 900

undo_tablespace string UNDOTBS1

Which two statements are true?

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 generates lots of redo. Which two actions would you take to solve this problem?

Backup requirements for a database：

* Level 0 backup on Sunday

* Cumulative incremental level 1 backup on Monday, Wednesday, and Saturday

* Differential incremental level 1 backup on Tuesday, Thursday, and Friday

Which three statements are true about the strategy?

You want a job that performs a bulk insert as soon as the loader file arrives on the local file system. Which two would you do to accomplish this?

DAILY_ORDS_LST is created in locally managed tablespace ORDERS_TBS which uses automatic segment space management. CREATE TABLE daily_ords_list (ordno NUMBER, ord_date DATE) PCTFREE 20;

Which two are true?

Examine this command executed on a client that is remote from the database server.

SQL> CONNECT hr/hr@orcl

Which two are required for this command to connect the SQLPLUS client to a database instance?

The HR user executes the following query on the EMPLOYEE table but does not issue COMMIT, ROLLBACK, or an data definition language (DDL) command after that：

SQL> SELECT job FROM employees WHERE job=‘CLERK’ FOR UPDATE OF empno;

HR then opens a second session.

Which two operations wait when executed in H R’s second session?

Which three statements are true about Oracle checkpoint processing?

Which three statements are true about checkpointing?

Which statements are true about the purpose of checkpoints?

You database is open in read/write mode and multiple users are connected to the database instance. You execute the following command：

SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION; What would be the effect on current sessions?

A database is open READ WRITE and the instance has multiple sessions some of which have active transactions. You execute this command： SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION; Which three are true about the active transactions?

Which two categories of segments are analyzed by the Automatic segment Advisor?

Which four statements are true about database instance behavior?

Which three statement are true about Oracle Data Pump?

Which three statements are true about Oracle Data Pump?

1 2 3 4 5 6 8