A database runs in ARCHIVELOG mode&n

多选题

A database runs in ARCHIVELOG mode

Dally full database backups are taken with RMAN which is configured to perform control file autobackup

The control file and redo log files are multi-plexed.

In which two cases is media recovery required?

A、

loss of all inactive online redo log group members

B、

loss of one copy of the control file

C、

loss of a data file that belongs to the active undo tablespace

D、

loss of data files that belong to the SYSAUX tablespace

E、

Physical corruption of data

查看答案

下载APP答题

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

相关试题

单选题 Examine the details of the uncompressed, non-partitioned heap table CITIES:

Name Null? Type

-------------------------- -------------------------- --------------------------

CITYID NOT NULL NUMBER (4)

CITY_NAME VARCHAR2 (50)

Examine the command:

SCL>ALTER TABLE cities SHRINK SPACE COMPACT;

What must you do before executing it?

A、

Make all indexes on the table invisible

B、

Make any invisible indexes on the table visible

C、

Make sure that row movement is disabled D) Disable any constraints on the table

D、

E、

Make sure that row movement is enabled

查看答案

单选题 The hr schema exists in databases, BOSTON and DENVER, with the same password, HR.

You have CREATE DATABASE LINK and CREATE SESSION privileges in both databases.

DENVER is defined as a service name in the tnsnames.ora of both databases.

You plan to use this command:

CREATE DATABASE LINK hr link CONNECT TO hr IDENTIFIED BY hr USING ' DENVER'

What must be done to ensure that all users in BOSTON can access the hr schema in DENVER?

A、

Change the command to create a public database link in DENVER

B、

Execute the command as HR in BOSTON and sys in DENVER

C、

Execute the command as sys in BOSTON

D、

Change the command to create a public database link in BOSTON

E、

Execute the command as sys in both databases

F、

Execute the command as sys in DENVER

查看答案

单选题 You must create a table, DAILY ORDERS, for a DSS application。

Data should be compressed when using direct- path INSERT

The table will also be used for occasional DSS queries

Load performance is critical

Which compression option satisfies these requirements?

A、

COLUMN STORE COMPRESS FOR QUERY HIGH

B、

COLUMN STORE COMPRESS FOR ARCHIVE HIGH

C、

COLUMN STORE COMPRESS FOR ARCHIVE LOW

D、

ROW STORE COMPRESS ADVANCED

E、

COLUMN STORE COMPRESS FOR QUERY LOW

查看答案

多选题 Examine this configuration for one of your databases:

1. UNDO RETENTION parameter is 1000

2. Retention is not guaranteed

3. The undo tablespace is fixed size

Which two statements are true?

A、

Active undo is retained for only for 1000 seconds

B、

Expired undo is retained for 1000 seconds even if transactions fail due to lack of space in the undo

tablespace.

C、

Inactive undo is retained for at least 1000 seconds if free undo space is available

D、

Active undo never becomes expired

E、

Inactive undo is retained for 1000 seconds even if transactions fail due to lack of space in the undo

tablespace

查看答案

多选题 Examine these configuration details

1. A Fast Recovery Area (FRA) has been specified for a database

2. The database instance is in ARCHIVELOG mode

3. The default location for archived redo log files is the FRA

Which two types of files are removed automatically due to space pressure in the FRA?

A、

expired RMAN database backup sets

B、

flashback logs

C、

expired RMAN image copies

D、

obsolete spfiles

E、

obsolete RMAN database backup sets

F、

Mirrored copies of online logs

查看答案

单选题 You must upgrade your Oracle 11g Database to Oracle 12c R2.

Which method can you use?

A、

Use the Database Creation Assistant (DBCA) to upgrade

B、

Use SQL*Developer

C、

Perform a rolling upgrade

D、

Use Enterprise Manager Express.

E、

Perform a direct upgrade by running the Database Upgrade Assistant (DBUA)

查看答案

单选题 Examine these commands and output:

Now examine these steps

1) STAR NOMOUNT

2) STARTUP MOUNT

3) STARTUP FORCE

4) ALTER DATABASE ARCHIVELOG;

5) ALTER DATABASE MOUNT

6) ALTER DATABASE OPEN RESETLOGS;

7) SHUTDOWN IMMEDIATE

8) ALTER DATABASE OPEN;

Identify the required steps in the correct order to change the database to run in ARCHIVELOG

mode

A、

7, 2, 4, 6

B、

7, 2, 4, 8

C、

3, 4, 8

D、

3, 4, 6

E、

7, 1, 4, 5 , 6

查看答案

多选题 A database runs in NOARCHIVELOG 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、

SQL Developer

B、

Database Configuration Assistant (DBCA)

C、

Database Upgrade Assistant (DBUA)

D、

Oracle Enterprise Manager Cloud Control

E、

Oracle Enterprise Manager Database Express (EM Express)

查看答案