瑞通OCP-062_在线真题试卷与模拟练习_瑞通OCP-062_考试宝

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

有效期：个月

章节介绍：共有个章节

收藏

我的练习

我的错题
(0道)

我的收藏
(0道)

我的斩题
(0道)

我的笔记
(0道)

专项练习

顺序练习 0 / 0

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

题型乱序 按导入顺序练习

模拟考试 仿真模拟

题型练习 按题型分类练习

易错题 精选高频易错题

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

搜索

题库预览

What is a requirement for creating a remote database scheduler job?

Your production database uses file system storage. You want to move storage to Oracle
Automatic Storage
Management (ASM). How would you achieve this?

Examine the parameters for a database

（含图）

Your database has three undo tablespaces and the default undo tablespace is not

Autoextensible. Resumable space allocation is not enabled for any sessions in the database

Instance. What is the effect on new transactions when all undo space in the default undo

Tablespace is in use by active transaction?

One of your databases has archive logging enabled and RMAN backups are taken at regular
Intervals. The data file for the USERS tablespace is corrupt. Which command must you execute
Before starting the recovery of this tablespace?

Your database has archive logging enabled and RMAN backups are taken at regular intervals. A data file in the USERS tablespace is damaged. Which command must you execute before starting the recovery of this tablespace?

Your database instance is started by using a sever parameter file (SPFILE). You execute the following command to change the value of the LOG_BUFFER initialization parameter. ALTER SYSTEM SET LOG_BUFFER=32M;
What is the outcome of this command?

In your Oracle12c database, you plan to execute the command:
SQL> CREATE TABLESPACE tbs1 DATAFILE ‘/u02/oracle/data/tbs01.dbf’ SIZE 50M;
The u02 file system has 1 GB of free space available.
What is the outcome?

When is the UNDO_RETENTION parameter value ignored by a transaction?

The HR.DEPARTMENTS table is the parent of the HR.EMPLOYEES table. The EMPLOYEE.DEPARTMENT_ID column has a foreign key constraint with the ON DELETE
CASCADE option that refers to the DEPARTMENTS.DEPARTMENT_ID column. An index exists on the DEPARTMENTS.DEPARTMENT_ID column. A transaction delete a primary
Key in the DEPARTMENTS table, which has child rows in the EMPLOYEES table. Which statement is true?

Unified auditing is enabled in your databases. The HR_ADMIN and OE_ADMIN roles exist and are
Granted system privileges.
You execute the command:
SQL> CREATE AUDTT POLICY table_aud PRIVILEGES CREATE ANY TABLE, DROP ANY TAETE
ROLES hr_admin, oe_admin;
Which statement is true?

You create a locally managed tablespace ORDER_TBS with automatic segment management. You then create the table DAILY_ORDS_LST in the ORDERS_TBS tablespace using the
Command.
CREATE TABLE daily_ords_lst (ordno NUMBER, ord_date DATE) PCTFREE 20;
How does the PCTFREE storage parameter influence data storage for this table?

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?

Your database is configured in ARCHIVELOG mode. Examine the RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; #default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET ;
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
Examine the command:
RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;
What is the outcome?

Examine the command:
SQL> CREATE TABLESPACE test1 DATAFILE ‘/u01/app/oracle/oradata/orcl/test01.dbf’ size 5M
AUTOEXTEND ON UNIFORM;
Which statement is true?

Which task is performed by a background process in a database instance?

Your database is in NOARCHIVELOG mode. You want to enable archiving for database. Examine the steps:
1 Execute the ALTER DATABASE ARCHIVELOG command
2 Execute SHUTDOWN IMMEDIATE
3 Execute STARTUP MOUNT
4 Set the DA_RECOUVERY_FILE_DEST parameter to $ORACLE_HOME/dbs/
5 Execute STARTUP NOMOUNT
6 Open the database
Identify the require steps in the correct sequence.

Examine the details of the uncompressed, non-partitioned heap table CITIES.
Examine the command:
SQL>ALTER TABLE cities SHRINK SPACE COMPACT;
What must you do before executing it?

You want create a table, DAILY_ORDERS, for an OLTP application, where data should be
Compressed during both direct-path INSERT and conventional DML.The table will also be used
For queries.
Which compression option should be used?

Which statement is true about profile?

What is the outcome of the SHUTDOWN ABORT command?