has CREATE DATABASE LINK and CREATE SESSION privileges on both databases.

Eaxmine these command：

 conn SALES/SALES123 CREATE DATABASE LINK orcl2 USING ‘orcl12’;

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

Cloud?

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 method provides the fastest way of achieving this?

You have the CREATE DATABASE LINK and CREATE SESSION privileges on both the database.  

DENVER 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 that all users in the BOSTON database can access

the HR schema in the DENVER?

NAME    TYPE     VALUE 

undo_management         string        AUTO 

undo_retention         integer 1200 

undo_tablespace        string         UNDOTBS1

You execute the following command：

SQL> ALTER TABLESPACE undotbs1 RETENTION NOGUARANTEE; 

Which statement is true in this scenario?

As the DBA, you successfully execute the comands： 

SQL> CREATE AUDIT  POLICY sales_pol  ACTIONS  select  on sh.sales; 

SQL> AUDIT POLICY sales_pol;

Which statement is true about the SALES_POL audit policy?

1. The user account must be locked after five unsuccessful login attempts. 

2. Data read per session must be limited for the user.

3. The user cannot have more than three simultaneous sessions.

4. The user must have a maximum of 10 minutes session idle time before being logged off automatically.

 How would you accomplish this?

LSNRCTL> RELOAD

What Is the effect of RELOAD on sessions that were originally established by LISTENER?