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
Explain the use of parfile option in exp command.
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
How to set up autotrace for a user account?
How to do paging with oracle?
Can we insert data in view oracle?
How can I see all tables in oracle?
What is a server parameter file in oracle?
What is an external table?
Are truncate and delete commands same? If so why?
How to upsert (update or insert into a table)?
Explain the use of online redo log files in oracle.
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
What is background process in Oracle?
In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?
Why does Oracle not permit the use of PCTUSED with indexes?