Examine this commanD.SQL>ALTER SY

多选题

Examine this commanD.

SQL>ALTER SYSTEM SET ENABLE_DDL_LOGGING=TRUE; Which two statements are true? 启动DDL日期记录=TRUE

A、

All DDL statements are logged in to a text file in Automatic Diagnostic Repository (ADR) home

B、

Some data definition language (DDL) statements are written to the control file.

C、

All data definition language (DDL) statements are written to the control file.

D、

Some DDL statements are written to a text file in the ADR home.

E、 The Alert Log still contains some DDL statements.

F、

Some DDL statements are written to an XML.,file in the ADR home.

查看答案

下载APP答题

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

相关试题

单选题
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 details of he uncompressed,non-partitioned heap table CITIES.

Name null type

CITYID NOT NULL NUMBER(4)

CITY_NAME VARCHAR2(50)

Examine the command:

SQL>ALTER TABLE cities SHRINK SPACE COMPACT;

What must you do before executing it?

A、

Make sure that row movement is disabled

B、

Disable any constraints on the table.

C、

Make sure that row movement is enabled.

D、

Make any invisible indexes on the table visible.

E、Make all indexes on the table invisible.

查看答案

单选题

You must upgrade your Oracle 11g Database to Oracle 12c R2. Which method can you use?

A、

Use Enterprise Manager Express.

B、

Use SQL*Developer

C、

Use the Database Creation Assistant(DBCA.to upgrade

D、

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

E、Perform a rolling upgrade.

查看答案

单选题

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

查看答案

单选题

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.

查看答案

单选题
Examine these commands and output:
SELECT open_mode from v4database;
------------------------------------
READ WRITE
ARCHIVE LOG LIST;
Database log mode No archive Mode
Automatic archive Dsiabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Now examine these steps
1)STARTUP NOMOUNT
2)STARTUP MOUNT
3)STARTUP FORCE
4)ALTER DATABASE ARCHIVELOG
5)ALTER DATABASE MOUNT;
6)ALTER DATABASE OPWEN RESETLOGS
7)SHUTDOWN IMMEDIATE
8)ALTER DATABASE OPEN;
Identify the required steps in the correct order to change the database to run in ARCHIBELOG mode.

A、7,1,4,5,6

B、7,2,4,8

C、3,4,8

D、7,2,4,6

E、3,4,6

查看答案

单选题

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、

ROW STORE COMPRESS ADVANCED

C、

COLUNN STORE COMPRESS FOR QUERY LOW

D、

COLUNN STORE COMPRESS FOR ARCHIVE HIGH

E、

COLUNN STORE COMPRESS FOR ARCHIVE LOW

查看答案