Which four operations performed after the Oracle Restart installation are automatically added to the Oracle Restart configuration? (Choose four.)

You create an Oracle 12c database and then import schemas that are required by an application which has not yet been developed. 

You want to get advice on creation of or modifications to indexes, materialized views and partitioning in these schemas. 

What must you run to achieve this?

The HR user updates the salary of one of the employees in the non-partitioned EMPLOYEES table, but does not commit the transaction. 

Which two types of lock exist in this situation? (Choose two.)

You have a production Oracle 12c database running on a host. You want to install and create databases across multiple new machines that do not have any Oracle database software installed. 

You also want the new databases to have the same directory structure and components as your existing 12c database. The steps in random order: 

1. Create directory structures similar to the production database on all new machines. 

2. Create a response file for Oracle Universal Installer (OUI) with the same configurations as the production database. 

3. Create a database clone template for the database. 

4. Run the Database Configuration Assistant (DBCA) to create the database. 

5. Run OUI in graphical mode on each machine. 

6. Run OUI in silent mode using the OUI response file. 

Identify the required steps in the correct sequence to achieve the requirement with minimal human intervention.

For which three requirements would you use the Database Resource Manager? (Choose three.)

SMD is a smallfile locally managed tablespace with manual segment space management. 

The SH user receives the following error while inserting data into the sales table: 

Which three actions can be taken to enable the user to insert data? (Choose three.)

In your database instance, the UNDO_RETENTION parameter is set to 1000 and undo retention is not guaranteed for the fixed size undo tablespace. 

Which statement is true about undo retention?