databases irrespective of the platform.

Which method provides the fastest way of achieving this?

SHOW PARAMETER INMEMORY_ SIZE

NAME     TYPE   VALUE

inmemory_size big integer  1G

Now examine this command ：

ALTER TABLE hr.emp INMEMORY ;

Table altered .

Which is true about effects of this command and any subsequent processing on hr.emp?

NAME   TYPE   VALUE

db_create_file_dest string  /u01/ app/oracle/oradata/prod/

undo_management string  AUTO

undo_retention  integer  900

undo_tablespace string   UNDOTBS1

You execute this： 

CREATE UNDO TABLESPACE UNDOTBS2 SEGMENT SPACE MANAGEMENT AUTO;

Which is true?

SELECT open_mode FROM v$database ;

OPEN_MODE

READ WRITE

ARCHIVE LOG LIST ;

Database log mode   No Archive Mode

Automatic archival  Disabled

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.SHUTDOWN TRANSACTIONAL

6)ALTER DATABASE OPEN;

7)SHUTDOWN ABORT

8.ALTER DATABASE MOUNT

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

On the SALES database there is no LEVEL 0 backup.

Examine these commands issued against the SALES database target：

RMAN> BACKUP AS BACKUPSET DATABASE ;

backup set complete, elapsed time： 00： 00： 03

RMAN> BACKUP INCREMENTAL LEVEL 1 DATABAsE ;

What is true about the execution of these commands?

STARTUP FORCE

ORACLE instance started .

Total System Global Area  5117049968 bytes

Fixed size  9038960 bytes

Variable size  922746880 bytes

Database Buffers 4177526784 bytes 

Redo Buffers  7737344 bytes

Database mounted 

Database opened .

Now examine these steps：

1.Oracle instance is started.

2.The control file is read.

3.Instance recovery is started.

4.Datafiles and redo log files are opened.

5.The spfile or pfile is read.

6.The database is available for use .

7.The database is mounted .

8.Instance recovery is completed.

Identify the steps that were executed in the correct order to open the database：

Which st atement is true about undo retention?

Examine this command：

SELECT open mode FROM v$database;

OPEN MODE

READ WRITE

Now examine these steps executed from RMAN ：

1.SHUTDOWN IMMEDIATE

2.STARTUP MOUNT

3.BACKUP DATABASE ;

4.BACKUP ARCHIVELOG ALL;

5. ALTER DATABASE OPEN ;

6.STARTUP

Identify the minimum required steps in the correct order needed to perform a whole consistent databasebackup.

You want to disable archiving for the database.

Examine these steps：

1. Execute the ALTER DATABASE NOARCHIVELOG command.

2. Execute SHUTDOWN IMMEDIATE.

3. Execute STARTUP MOUNT.

4. Set the DB_ RECOVERY_ FILE_DEST parameter to $ORACLE_HOME/ dbs/.

5. Execute STARTUP NOMOUNT.

6. Open the database.

7. Execute SHUTDOWN TRANSACTIONAL

Identify the required steps in the correct sequence.

（含图）

Examine the command:

SQL>ALTER TABLE cities SHRINK SPACE COMPACT;

What must you do before executing it?

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?

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.

Which method can you use?