What is a requirement for creating a remote database scheduler job?

Your production database uses file system storage. You want to move storage to Oracle Automatic Storage

Management (ASM). How would you achieve this?

Examine the parameters for a database

（含图）

Your database has three undo tablespaces and the default undo tablespace is not autoextensible. Resumable space allocation is not enabled for any sessions in the database instance. What is the effect on new transactions when all undo space in the default undo tablespace is in use by active transaction?

One of your databases has archive logging enabled and RMAN backups are taken at regular Intervals. The data file for the USERS tablespace is corrupt. Which command must you execute before starting the recovery of this tablespace?

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?

Your database instance is started by using a sever parameter file (SPFILE). You execute the Following command to change the value of the LOG_BUFFER initialization parameter. ALTER SYSTEM SET LOG_BUFFER=32M;

What is the outcome of this command?

In your Oracle12c database, you plan to execute the command:

SQL> CREATE TABLESPACE tbs1 DATAFILE ‘/u02/oracle/data/tbs01.dbf’ SIZE 50M; The u02 file system has 1 GB of free space available.

What is the outcome?

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?

When is the UNDO_RETENTION parameter value ignored by a transaction?

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?

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 storage parameter influence data storage for this table?

You database is open in read/write mode and multiple users are connected to the database instance. You execute the following command:

SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;

What would be the effect on current sessions?

Your database is configured in ARCHIVELOG mode. Examine the RMAN configuration parameters:

 CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default

CONFIGURE BACKUP OPTIMIZATION OFF; # default 

CONFIGURE CONTROLFILE AUTOBACKUP OFF; #default

CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET ; 

CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

Examine the command:

RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;

What is the outcome?