What are the components of physical database structure in the Oracle database?



What are the components of physical database structure in the Oracle database?..

Answer / hr@tgksolutions.com

The components of the physical database structure are:
• Greater than equal to two redo log files.
• Greater than equal to one control file.
• Greater than equal to one data file.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle General Interview Questions

Differentiate between pre-select and pre-query?

0 Answers  


How to select the name of employee who is getting maximum sal with out using subquery

15 Answers  


What should be the return type for a cursor variable.Can we use a scalar data type as return type?

1 Answers  


how to i write the query 'NISHI' TO N I S H I

4 Answers   Attra, Metric Stream,


What is a package ? What are the advantages of package ?

0 Answers  


does the query needs a hint to access a materialized view?

1 Answers  


how many columns can a plsql table have

13 Answers   NIIT,


What is a table in oracle?

0 Answers  


What is difference between UNIQUE constraint and PRIMARY KEY constraint ?

3 Answers  


How to Truncate Table in Oracle

0 Answers   HCL,


What is Public Database Link ?

1 Answers  


Can cursor variables be stored in PL/SQL tables.If yes how. If not why?

1 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1808)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)