Oracle database is comprised of three types of files. One or more datafiles

What are the components of Physical database structure of
Oracle Database?

Question Posted / nishi

Answer Posted / nishi

Oracle database is comprised of three types of files. One or more datafiles, two are more redo log files, and one or more control files.

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the order of defining local variables and sub procedures/functions?

1061

what are the advantages of running a database in archive log mode?

2203

What is a system tablespace and when it is created?

972

How to define a variable of a specific record type?

1078

What is an oracle transaction?

1146

What are the various constraints used in oracle?

1046

Explain oracle insert into command?

1115

What is an oracle database table?

1015

What are the parameters that we can pass through a stored procedure?

1065

What is a static data dictionary in oracle?

1112

How to Truncate Table in Oracle

1156

What is the difference between PFILE and SPFILE in Oracle?

1061

Which environment variables are absolutely critical in order to run the OUI?

2120

What happens to the current transaction if the session is ended?

1098

What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.

979