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

Answer Posted / m.kesava moorthi

it consist of three main types of files,there are 1.data
files, 2.control files,3.redo files and some other files
like initialization files,network administration files,alert
log files,trace files,password files

Is This Answer Correct ?    8 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to do clean up if create database failed?

578


How to declare a local variable?

601


What is the maximum number of triggers that can be applied to a single table?

563


Is java required for oracle client?

556


How to create an initialization parameter file?

546






How to find the duplicate rows count from employees table in oracle?

556


What is a snapshot log?

570


What is the relation of a user account and a schema?

619


What is a procedure in oracle?

620


Is there a combination of "like" and "in" in sql?

592


How to use fetch statement in a loop?

563


How to create a stored procedure in oracle?

582


How to get execution statistics reports on query statements?

573


How to manage transaction isolation level?

571


How do I find the database name in oracle?

605