Which two services may you see on the My Service Dashboard page? (Choose two.)

The HR schema exists in two databases, BOSTON and DENVER, and has the same password, HR. 

You have the CREATE DATABASE LINK and CREATE SESSION privileges on both the database. 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?

Examine the command: 

SQL> CONNECT hr/hr@orcl 

Which two configurations allow this command to execute successfully? (Choose two.)

Which three statements are true about Oracle Data Pump? (Choose three.)

Examine the command to perform a data pump export operation on a source database: 

$> expdp hr/hr DIRECTORY=dumpdir DUMPFILE=emp1.dmp VIEWS_AS_TABLE=emp_dept 

On the target database, you execute the data pump import command: 

$> impdp hr/hr DIRECTORY=dumpdir DUMPFILE=emp1.dmp VIEWS_AS_TABLE=emp_dept 

Which three statements are true? (Choose three.)

Examine the details of the uncompressed, non-partitioned heap table CITIES. 

Examine the command: 

SQL>ALTER TABLE cities SHRINK SPACE COMPACT; 

What must you do before executing it?

Your database has archive logging enabled and RMAN backups are taken at regular intervals. 

A data file in the USERS tablespace is damaged. 

Which command must you execute before starting the recovery of this tablespace?

Which statement is true regarding the DEFAULT profile?