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?

Which method can you use? 

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? 

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 

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?

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? 

1. UNDO RETENTION parameter is 1000 

2. Retention is not guaranteed 

3. The undo tablespace is fixed size 

Which two statements are true? 

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?

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?

SOL> CREATE TAILESPACE test1 

DATAFILE '/u01/app/oracle/oradata/orcl/test01. dbf ’SIZE 5M 

AUTOEXTEND ON AUTOALLOCATE； 

Which two statements are true? 

A new database has no RMAN backups yet. 

Examine these commands: 

Which two are true about the execution of the third backup command?