Explain the relationship among Database, Tablespace and Data
file?

Answer Posted / chaudhry

Each databases logically divided into one or more
tablespaces One or more data files are explicitly created
for each tablespace.

Is This Answer Correct ?    8 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is rowid and rownum in oracle?

547


You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

1452


How to commit the current transaction in oracle?

581


Explain the blob datatype?

622


Why packages are used in oracle?

552






What is oracle rownum?

522


What types of joins are used in writing subqueries?

571


How index is implemented in oracle database?

598


How to calculate date and time differences in oracle?

538


What is snapshot is too old? Give and example for better understand.

1106


Explain temporal data types in oracle

617


Explain a segment?

625


Design database draw er diagram for a certain scenario ?

4107


Use of an integrity constraint is better to validate data. Explain

555


What are the predefined tablespaces in a database?

560