It includes all used data blocks in the datafiles.

It includes a backup of datafiles that includes only the blocks that have changed since a previous incremental backup.

Incremental backups of control files and archived logs always include all blocks in the files.

Incremental backups require a full or incremental level 0 backup to serve as a basis.

Both (2) and (4)

Backing up the control file can be done only when the database is mounted or open.

The control file autobackup contains metadata about the previous backup.

We can not manually set the autobackup.

BACKUP CURRENT CONTROLFILE command is used to run the backup.

Both (2) and (3)

In this recovery, RMAN is responsible for creating the copes of datafiles and control files.

In this backup, RMAN only records backup sets in the repository that complete successfully.

Image copy backups can only be created on disk.

All of the above

Both (1) and (3)

A backup set consists of one or more files.

In this backup, RMAN only records backup sets in the repository that complete successfully.

In this backup, RMAN also supports binary compression of backup sets.

All of the above

Both (1) and (3)

A consistent database will be in consistent state when the database is shut down normally.

At consistent state, all the changes in the redo log have been applied to the datafiles.

For a consistent database state, Oracle must perform media recovery before the database can be opened.

All of the above

Both (1) and (2)

Datafiles exist or not.

This backup validation discovers corrupt blocks.

RMAN can issues an error message, in case if it cannot validate the backup of one or more of the files.

All of the above

Both (1) and (3)

Backing Up database files using RMAN, we can backup one or more individual tablespaces.

Backing Up database files using RMAN , we can back up datafiles and datafile copies when the database is mounted or open.

In this backup, RMAN uses a snapshot control file to ensure a read-consistent version.

In this back up, datafile copies exist on disk only.

None of the above

Information related to the datafiles backup

Information related to datafiles recoverability

Information related to current physical schema of the database

All of the above

Both (2) and (3)

The LIST command is used to query the RMAN repository.

This command is used to backup sets and image copies.

RMAN LIST output is sent either to standard output or to the message log.

This command can cause the deletion of backups or archived logs.

Both (2) and (4)

It is responsible for maintaining performance statistics for problem detection and self-tuning purposes.

It provides a quick and efficient technique for optimizing SQL statements without modifying any statements.

It provides advice on materialized views, indexes, and materialized view logs.

It provides server generated alerts.

Both (1) and (2)

It is used to collect, process, and maintain performance statistics for problem detection and self-tuning purposes

It is used to analyse the information collected by the AWR for possible performance problems with the Oracle database.

It provides a quick and efficient technique for optimizing SQL statements without modifying any statements.

It provides end-to-end application tracing.

Both (1) and (2)

Database statistics

Operating system statistics

Application statistics

Network statistics

All of the above

It allows a quick and efficient technique for optimizing SQL statements.

It collects, processes and maintains performance statistics for problem detection.

It provides advice on materialized views, indexes, and materialized view logs.

It analyses the information from the Automatic Workload Repository (AWR) for possible performance problems with the Oracle database.

Both (1) and (3)

Latch contention

Slow physical I/O

Excessive CPU usage

All of the above

Both (2) and (3)

It considers allocation of memory to database structures.

It determine the I/O requirements of different parts of the database.

It tunes the operating system for optimal performance of the database.

All of the above

Both (2) and (3)

Data consistency

Operating system workload

Reduced availability

All of the above

Both (2) and (3)