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?

you want to ensure that a user connecting remotely to the database instance a one-to-one  ratio between client and server  processes. 

Which connection method guarantees that this requirement is met?

SQL> CREATE TABLE acct1  (ac_no NUMBER,

ac_desc VARCHAR2(25), amount NUMBER(10, 2));

which three statements are true?

You execute the following command to create a table： 

SQL> CREATE TABLE acct1  (ac_no NUMBER,

ac_desc VARCHAR2(25), amount NUMBER(10, 2));

which two statements are true?

Examine the following parameters：

NAME                       TYPE    VALUE

-------------------------------------------- -------------- ---------------------------------------------

log_archive_dest              string

log_archive_dest_1            string

  log_recovery_file_dest         string    /u01/app/oracle/fast_recovery_area

  You execute the following command after performing a STARTUP MOUNT：

SQL >ALTER DATABASE ARCHIVELOG;

Which statement is true about the execution of the command?

SQL>CREATE USER sidney

IDENTIFIED BY out_standing1

DEFAULT TABLESPACE users

QUOTA 10M ON users

TEMPORARY TABLESPACE temp

ACCOUNT UNLOCK;

SQL> GRANT CREATE SESSION To sidney;

Which two statements are true?

SQL> GRANT SELECT ON bonuses To tom WITH GRANT OPTION;

TOM then executes this command to grant privileges to the user JIM：

SQL> GRANT SELECT ON hr.bonuses TO jim;

Which statement is true?

$> impdp <user_name> full=Y network_link=hrdb_test transportable=always transport_ datafiles=

'/u01/app/oracle/oradata/hrdb/salea01.dbf' ,

'/u01/app/oracle/oradata/hrdb/cust01.dbf' ,

'/u01/app/oracle/oradata/hrdb/emp01.dbf’

version=l2 logfile=import.log

Which three are prerequisites for successful execution of the command?

You plan to use the ALTER SYSTEM command.

Which two methods can be used?

Which two types of lock are held by the transaction?

Hostname：HOST01

Port：1521

Service_name：SALES_SRV

You issue this command：

$tnsping SALES

Which two are true?