Question

What Oracle backup and recover file contains user and system data?
A.Control file
B.Datafile
C.OnLine ReDo file
D.Offline ReDo file

Answer 1

Oracle backup and recover file contains user and system data.

Related Questions on Managing Databases with Oracle.

B.Datafile✔✔✔

Answer 2

Datafile is the oracle backup and recover file that has user and system data.

Datafile in Oracle:

a) Datafiles are the OS files that store the database's data.

b) The data is written to these files in an Oracle exclusive format that can't be seen by other programs.

c) Temp files are a special class of datafiles only associated with temporary tablespaces.

Components of Datafiles in Oracle:

. Segment: It contains a specific database object type.

. Extent: It is a contiguous set of data blocks.

. Data block: It is the smallest unit of I/O to database storage.