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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the usage of save points in oracle database?

533


How to define an anonymous block?

621


Explain the use of owner option in exp command.

569


We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.

4932


IS it possible to built the oracle database without setting the kernal parameters?

1763






Explain an exception?

568


What is the quickest way to export a table to a flat file?

575


Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.

1652


What are the various constraints used in oracle?

556


How to display employee records who gets more salary than the average salary in the department?

599


Explain oracle 12c new features for developers?

540


How to specify default values in insert statement using oracle?

568


What is a database table in oracle?

574


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

1735


Is oracle the best database?

522