Examine this command which executes sccessfully：

ALTER SYSTEM ENABLE RESTRICTED SESSION;

Which two are true?

You executed this command in one of them：

ALTER SYSTEM SET MEMORY_MAX_TARGET=1024M;

Which statement is true?

Examine these steps：

1) Issue SHUTDOWN IMMEDIATE

2) Issue STARTUP MOUNT 

3) Issue STARTUP NOMOUNT

4) Copy the existing control file to the new location

5) Issue ALTER DATABASE OPEN

6) Issue STARTUP 

7)Update the CONTROL_FILES initialization parameter in the SPFILE to include an additional file.

Identify the minimum required steps in the correct order to multiplex the control file.

1) A LEVEL 0 backup is taken every two weeks.

2) A CUMULATIVE LEVEL 1 backup is taken weekly.

3) A DIFFERENTIAL LEVEL 1 backup is taken daily.

Which blocks are backed up in the CUMULATIVE LEVEL 1 backup?

Examine these commands:

CONFIGURE RETENTION POLICY TO REDUNDANCY 2;

RMAN> BACKUP TABLESPACE SYSTEM;

..

backup set complete, elapsed time: 00:00:03

..

RMAN> BACKUP TABLESPACE SYSTEM, SYSAUX;

..

backup set complete, elapsed time:00:00:04

RNAN> BACKUP DATABASE

..

backup set complete,elapsed time: 00:00:07

..

Which two are true about the execution of the third backup command?

1. A Fast Recovery Area(FRA) has been specified for a database.

2.The database instance is in ARCHIVELOG mode

3.The default location for archived redo log files is the FRA.

Which two types of files are removed automatically due to space pressure in the FRA?

SQL>ALTER SYSTEM SET ENABLE_DDL_LOGGING=TRUE;

Which two statements are true?

Backup scheduling for this database must be automated before upgrading to a new version of the database.

Which two tools or utilities can do this?

Daily full database backups are taken with RMAN which is configured to perform control file autobackup.

The control file and redo log files are multi-plexed

In which two cases is media recovery required?

1.    A Fast Recovery Area(FRA)has been specified for a database.

2.    The database instance is in ARCHIVELOG mode

3.    The default location for archived redo log files is the FRA.

Which two types of files are removed automatically due to space pressure in the FRA?

1.    UNDO_RETENTION parameter is 1000

2.    retention is not guaranteed

3.    the undo tablespace is fixed size.

Which two statements are true?

Which two statements are true?