Which three statements are true about a Job chain?

You execute the commands：

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?

What should you do to ensure that a job stores minimal job metadata and runtime data on disk,and uses only existing PL/SQL programs?

An employee salary in the non-partitioned EMPLOYEES table, has been updated but the transaction is uncommitted.

Which two types of lock are held by the transaction?

Which three are true about the oracle job sheduler and its components?

SALES is a valid TNS entry referring to：

Hostname：HOST01

Port：1521

Service_name：SALES_SRV

You issue this command：

$tnsping SALES

Which two are true?

SHOW PARAMETER INMEMORY_SIZE

NAME TYPE VALUE

Inmemory_size big integer 1G

Now examine this command ：

ALTER TABLE hr.emp INMEMORY ;

Table altered .

Which is true about effects of this command and any subsequent processing on hr.emp?

Which four are true about the SHUTDOWN TRANSACTIONAL command and its effects in a single instance Oracle database environment with a single active transaction?

Which naming method enables clients to connect to a database instance without any client side configuration in sqlnet.ora or tnsnames.ora?

Examine this parameter：

NAME TYPE VALUE

Db_create_file_dest string /u01/app/oracle/oradata/prod/

Now examine this statement which executes successfully in an Oracle Database version 12c or later.

CREATE TABLESPACE data_olap;

Which two are true about this tablespace and its attributes?

In one of your databases, unified auditing is enabled and an SH.SALES table exists.

You successfully execute these commands：

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

SQL>AUDIT POLICY sales_pol;

Which statement is true about SALES_POL?

All of your live databases run in ARCHIVELOG mode.

On the SALES database there is no LEVEL 0 backup.

Examine these commands issued against the SALES database target：

RMAN> BACKUP AS BACKUPSET DATABASE ;

Backup set complete, elapsed time： 00：00：03

RMAN> BACKUP INCREMENTAL LEVEL 1 DATABASE ;

What is true about the execution of these commands?