1.Execute the ALTER DATABASE ARCHIVELOG command   

2.Execute SHUTDOWN IMMEDIATE   

3.Execute STARTUP MOUNT  

4.Set the DA_RECOUVERY_FILE_DEST parameter to $ORACLE_HOME/dbs/   

5.Execute STARTUP NOMOUNT  

6.Open the database  

Identify the require steps in the correct sequence.

Name     Null       Type

CITYIDNOT NULL   NUMBER(4)

CITYNAME            VARCHAR2(50)

Examine the command：

SQL>ALTER TABLE cities SHRINK SPACE COMPACT; What must you do nefore executing it? 

Eaxmine these command： conn SALES/SALES123 CREATE DATABASE LINK orcl2 USING ‘orcl12’;

What is the outcome of executing these commands in the ORCL1 database?

NAME                 TYPE      VALUE

memory_max_target   big integer   0

memory_target      big integer   0

sga_max_size      big integer    2G

sga_target         big integer   2G

You want to increase the size of the buffer cache. Free memory is available to increase the size of the buffer cache. you execute the command：

SQL> ALTER SYSTEM SET DB_CACHE_SIZE=1024M; 

Which is the outcome?

The data files and redo log files are intact but control files are impacted due to media failure.

In which recovery scenario must you use the RESETLOGS option?

Which set of tablespace attributes can be specified for a tablespace the satifies the requirements?

Which method provides the fastest way of achieving this?

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

You plan to use the command：

CREATE DATABASE LINK hr_link；

CONNECT TO hr IDENTIFIED BY hr USING ‘denver’;

What must be done to ensure only the HR user in the BOSTON database can access the HR schema in the DENVER database?