What are the components of Physical database structure of
Oracle Database?
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 an integrity constrains?
Table1- have two column filename data AFGDFD-20112011 hi how r u bsdasd-23042011 name shoud be in bold Now i want output like filename data AFGDFD hi how r u bsdasd name shoud be in bold Kindly answer this
After update how do u know how many records got updated
What is oracle update statement with inner join ?
How to insert a new row into a table in oracle?
Explain overloading. Can functions be overloaded?
Hi can anyone tell me where are the dumps found of OCA certification.. Also the materials to be studied for the preparation.
What is the function of Redo Log ?
Hi Can any one tell me what are the API's used in requisition import.
how can find the second max sal for every group(i.e i want group the data based on key and find the second max sal for every group
What is Virtual Private Database in Oracle?
How to create a table index?