Explain the relationship among Database, Tablespace and Data
file?

Answer Posted / riddhi

An Oracle database consists of one or more logical storage
units called tablespaces.
tablespaces is consist of one or more datafiles.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the use of oracle?

779


What are the database administrators utilities available?

775


What is pragma autonomous transaction in oracle?

755


HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.

1195


Why we use bulk collect in oracle?

738


What is the difference between sharding and replication?

681


What to do if the startbd.bat failed to start the xe instance?

832


Explain temporal data types in oracle

813


How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1696


How to estimate disk space needed for an export job?

759


How to drop an existing view in oracle?

743


Differentiate between pre-select and pre-query?

832


What is oracle data type?

736


What is an index associated with a constraint?

765


what is difference between sql plus and sql*plus? (not sql and sql plus).

3552