Which two statements describe the relationship between a scheduler window, a resource manager plan, and a job class?

Which are two ways for a database service to be recognized by a listener in Oracle Database 12c?

Examine the parameters for a database instance：

NAME TYPE VALUE

Temp_undo_enabled boolean TRUE

Undo_management string AUTO

Undo_retention integer 900

Undo_tablespace string UNDOTBS1

Which two statements are true?

You want a job that performs a bulk insert as soon as the loader file arrives on the local file system.您希望一个作业在加载程序文件到达本地文件系统时立即执行大容量插入。

Which two would you do to accomplish this?

You want to create a test database as a replica of your production database with minimum intervention from a DBA. Which method would you use?

The HR.DEPARTMENTS table is the parent of the HR.EMPLOYEES table.

The EMPLOYEE.DEPARTMENT_ID column has a foreign key constraint with the ON DELETE CASCADE option that refers to the DEPARTMENTS.DEPARTMENT_ID column.

An index exists on the DEPARTMENTS.DEPARTMENT_ID column. A transaction delete a primary key in the DEPARTMENTS table,

Which has child rows in the EMPLOYEES table. Which statement is true?

Unified auditing is enabled in your databases. The HR_ADMIN and OE_ADMIN roles exist and are granted system privileges.

You execute the command：

SQL> CREATE AUDTT POLICY table_aud PRIVILEGES CREATE ANY TABLE, DROP ANY TAETE ROLES hr_admin, oe_admin; Which statement is true?

DAILY_ORDS_LST is created in locally managed tablespace ORDERS_TBS which uses automatic segment space management.

CREATE TABLE daily_ords_list (ordno NUMBER, ord_date DATE、 PCTFREE 20;

Which two are true?

You create a locally managed tablespace ORDER_TBS with automatic segment management.

You then create the table DAILY_ORDS_LST in the ORDERS_TBS tablespace using the command.

CREATE TABLE daily_ords_lst(ordno NUMBER, ord_date DATE、 PCTFREE 20;

How does the PCTFREE storae parameter influence data storage for this table?