Interested to Buy Any Domain ? << Click Here >> for more details...
What are the components of Physical database structure of
Oracle Database?
- 4 Answers
- 13160 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / chaudhry
ORACLE database is comprised of three types of files. One or
more Data files, two are more Redo Log files, and one or
more Control files
| Is This Answer Correct ? | 37 Yes | 1 No |
Answer / 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 |
Answer / chirag
Every oracle database has one or more physical datafiles.
These datafiles contain all the data in the database. The
data of the logical structures, such as tables and indexes,
are physically stored in the allocated datafiles.
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / 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 |
Explain the different normalization forms?
How to create id with auto_increment on oracle?
What are the factors causing the reparsing of SQL statements in SGA?
How to drop an index in oracle?
how table is defined in plsql table? how can i select column from plsql table? can i use select * from plsql table type?
What is the difference between Outer join and Full outer join?
How do you tell what your machine name is and what is its IP address?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
How many different types of indexes we have in oracle?
24 Answers IBM, TCS,
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
Whatz the main diff between Subquery and a Join
14 Answers Oracle, Zeta Interactive,
Oracle General 
