A database runs in NOARCHTVELOG mode

多选题

A database runs in NOARCHTVELOG mode.

Backup scheduling for this database must be automated before upgrading to a new version of the database.

Which two tools or utilities can do this?

A、

SOL Developer

B、

Database upgrade Assistant (DBUA)

C、

Oracle Enterprise Manager Cloud Control

D、

Oracle Enterprise Manager Database Express(EM Express)

E、

Database Configuration Assistant (DBCA)

查看答案

下载APP答题

由4l***pi提供分享举报纠错

相关试题

单选题 Your production database uses file system storage. You want to move storage to Oracle Automatic Storage

Management (ASM). How would you achieve this?

A、

by using RMAN

B、

by using Data Pump

C、

by using the Database Upgrade Assistant (DBUA)

D、

by using a transportable database

查看答案

单选题 You want to create a test database as a replica of your production database with minimum intervention from a DBA. Which method would you use?

A、

Use DBCA to create a template from the existing database to contain the database structure with data files and then use the same template to create the database in the new location.

B、

Use DBCA to create a template from the existing database to contain the database structure and then manually copy the data by using Oracle Data Pump.

C、

Use Database Configuration Assistant (DBCA) to create a template from the existing database to contain the database structure.

D、

Create the database by using the CREATE DATABASE … command and manually import data by using Data Pump.

查看答案

单选题 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?

A、

SWITCH DATAFILE ALL;

B、

STARTUP FORCE

C、

ALTER TABLESPACE users OFFLINE TEMPORARY;

D、

ALTER TABLESPACE users OFELINE NORMAL;

E、

ALTER TABLESPACE users OFFLINE IMMEDIATE;

查看答案

单选题 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

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?

A、

Transactions write their undo in a temporary tablespace.

B、

Transactions fail.

C、

Transactions write their undo in the SYSTEM undo segment.

D、

Transactions wait until space becomes available in UNDOTBS1.

查看答案

单选题 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?

A、

SWITCH DATAFILE ALL

B、

STARTUP FORCE

C、

STARTUP FORCE NOMOUNT

D、

ALTER TABLESPACE users OFFLINE

查看答案

单选题 what is a requirement for creating a remote database scheduler job?

A、

The remote database job must run as a user that is valid on target remote database

B、

A private datbase link must be created from the originating database to the target remote database

C、

The target remote database on which the job is shceduled must be Oracle Database 11g Release 2 or later

D、

The target remote database must be on a different host from the originating scheduler database host

查看答案

单选题 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?

A、

It returns an error because SCOPE should be set to MEMORY.

B、

It returns an error because the value of this parameter cannot be changed dynamically.

C、

The parameter value is changed and it comes into effect as soon as space becomes available in the SGA.

D、

The parameter value is changed and it comes into effect at the next instance startup.

查看答案

单选题 In your Oracle12c database, you plan to execute the command：

SGL> 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?

A、

It creates a locally managed tablespace with manual segment space management enabled.

B、

It creates a dictionary-managed tablespace with manual segment space management enabled.

C、

It raises an error because extent management is not specified.

D、

It creates a locally managed tablespace with automatic segment space management enabled.

查看答案